APPS.WSH_FLEX_PKG_COGS dependencies on MTL_SYSTEM_ITEMS

Line 241: MTL_SYSTEM_ITEMS M

237: BEGIN
238: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
239: INTO L_COST_SALE_ITEM_DERIVED
240: FROM SO_LINE_DETAILS LD,
241: MTL_SYSTEM_ITEMS M
242: WHERE LD.LINE_DETAIL_ID = L_LINE_DETAIL_ID
243: AND M.ORGANIZATION_ID = LD.WAREHOUSE_ID
244: AND M.INVENTORY_ITEM_ID = LD.INVENTORY_ITEM_ID;
245: IF (DEBUG_COGS) THEN

Line 276: MTL_SYSTEM_ITEMS M

272: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
273: INTO L_COST_SALE_ITEM_DERIVED
274: FROM SO_PICKING_LINE_DETAILS PLD,
275: SO_PICKING_LINES PL,
276: MTL_SYSTEM_ITEMS M
277: WHERE PLD.PICKING_LINE_DETAIL_ID = L_PICK_LINE_DETAIL_ID
278: AND PL.PICKING_LINE_ID = PLD.PICKING_LINE_ID
279: AND M.ORGANIZATION_ID = PLD.WAREHOUSE_ID
280: AND M.INVENTORY_ITEM_ID = PL.INVENTORY_ITEM_ID;

Line 311: MTL_SYSTEM_ITEMS M

307: BEGIN
308: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
309: INTO L_COST_SALE_ITEM_DERIVED
310: FROM SO_LINES L,
311: MTL_SYSTEM_ITEMS M
312: WHERE M.ORGANIZATION_ID = L_ORGANIZATION_ID
313: AND L.LINE_ID = L_ORDER_LINE_ID
314: AND M.INVENTORY_ITEM_ID = L.INVENTORY_ITEM_ID;
315: IF (DEBUG_COGS) THEN

Line 403: MTL_SYSTEM_ITEMS M

399: END IF;
400: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
401: INTO L_COST_SALE_MODEL_DERIVED
402: FROM SO_LINE_DETAILS LD,
403: MTL_SYSTEM_ITEMS M
404: WHERE LD.LINE_DETAIL_ID = L_LINE_DETAIL_ID
405: AND M.ORGANIZATION_ID = LD.WAREHOUSE_ID
406: AND M.INVENTORY_ITEM_ID = LD.INVENTORY_ITEM_ID;
407: IF (DEBUG_COGS) THEN

Line 437: MTL_SYSTEM_ITEMS M

433: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
434: INTO L_COST_SALE_MODEL_DERIVED
435: FROM SO_PICKING_LINE_DETAILS PLD,
436: SO_PICKING_LINES PL,
437: MTL_SYSTEM_ITEMS M
438: WHERE PLD.PICKING_LINE_DETAIL_ID = L_PICK_LINE_DETAIL_ID
439: AND PL.PICKING_LINE_ID = PLD.PICKING_LINE_ID
440: AND M.ORGANIZATION_ID = PLD.WAREHOUSE_ID
441: AND M.INVENTORY_ITEM_ID = PL.INVENTORY_ITEM_ID;

Line 472: MTL_SYSTEM_ITEMS M

468: BEGIN
469: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
470: INTO L_COST_SALE_MODEL_DERIVED
471: FROM SO_LINES L,
472: MTL_SYSTEM_ITEMS M
473: WHERE M.ORGANIZATION_ID = L_ORGANIZATION_ID
474: AND L.LINE_ID = L_ORDER_LINE_ID
475: AND M.INVENTORY_ITEM_ID = L.INVENTORY_ITEM_ID;
476: IF (DEBUG_COGS) THEN

Line 859: FROM MTL_SYSTEM_ITEMS

855: END IF;
856: BEGIN
857: SELECT NVL(COST_OF_SALES_ACCOUNT, 0)
858: INTO L_ACCOUNT_DERIVED
859: FROM MTL_SYSTEM_ITEMS
860: WHERE INVENTORY_ITEM_ID = L_INV_ITEM_ID
861: AND ORGANIZATION_ID = L_ORGANIZATION_ID;
862: IF (DEBUG_COGS) THEN
863: PRINTLN('L_ACCOUNT_DERIVED = '||L_ACCOUNT_DERIVED);