储藏室

CREATE OR REPLACE FUNCTION APPS.MEW_ITEM_GROUP_F(P_ORGANIZATION_ID   NUMBER                                                ,P_INVENTORY_ITEM_ID NUMBER

--Subinventory Transfer  BEGIN    SELECT OP.ACCT_PERIOD_ID      INTO V_ACCT_PERIOD_ID      FROM ORG_ACCT_PERIODS OP     WHERE OP.ORGANIZATION_ID = :PARAMETER.ORG_ID       AND SYSDATE BETWE

--接收数量SELECT RSH.RECEIPT_NUM      ,RT.QUANTITY --当前接收 接收数量      ,RT.*  FROM RCV_SHIPMENT_HEADERS RSH      ,RCV_SHIPMENT_LINES   RSL      ,RCV_TRANSACTIONS     RT WHERE RSH.SHIPMENT_HEADE

--Convert the transaction quantity to Primary UOM's quantityDECLARE  L_PRIMARY_QTY NUMBER;BEGIN  PO_UOM_S.UOM_CONVERT(100 --Transaction Quantity                       ,'PC' --Transaction Uom

--用户物料类型SELECT *  FROM FND_COMMON_LOOKUPS FCL WHERE FCL.LOOKUP_TYPE = 'ITEM_TYPE'   AND FCL.ENABLED_FLAG = 'Y'1.  --物料类别集SELECT *  FROM MTL_CATEGORY_SETS MCS WHERE MCS.CATEGORY_SET