APPS.OE_FLEX_COGS_PUB dependencies on MTL_SYSTEM_ITEMS

Line 564: MTL_SYSTEM_ITEMS M

560: BEGIN
561: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
562: INTO l_cost_sale_item_derived
563: FROM OE_ORDER_LINES OL,
564: MTL_SYSTEM_ITEMS M
565: WHERE OL.LINE_ID = l_line_id
566: AND M.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID
567: AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;
568: EXCEPTION

Line 599: MTL_SYSTEM_ITEMS M

595:
596: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
597: INTO l_cost_sale_item_derived
598: FROM OE_ORDER_LINES OL,
599: MTL_SYSTEM_ITEMS M
600: WHERE OL.LINE_ID = l_link_to_line_id
601: AND M.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID
602: AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;
603: EXCEPTION

Line 735: MTL_SYSTEM_ITEMS M

731: BEGIN
732: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
733: INTO l_cost_sale_model_derived
734: FROM OE_ORDER_LINES OL,
735: MTL_SYSTEM_ITEMS M
736: WHERE OL.LINE_ID = l_model_line_id
737: AND M.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID
738: AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;
739: EXCEPTION

Line 1290: FROM MTL_SYSTEM_ITEMS

1286: IF (L_INV_ITEM_ID IS NOT NULL) THEN
1287: BEGIN
1288: SELECT NVL(COST_OF_SALES_ACCOUNT, 0)
1289: INTO l_account_derived
1290: FROM MTL_SYSTEM_ITEMS
1291: WHERE INVENTORY_ITEM_ID = l_inv_item_id
1292: AND ORGANIZATION_ID = l_ship_from_org_id;
1293: EXCEPTION
1294: WHEN NO_DATA_FOUND THEN