APPS.OE_FLEX_COGS_PUB dependencies on MTL_SYSTEM_ITEMS

Line 550: MTL_SYSTEM_ITEMS M

546: BEGIN
547: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
548: INTO l_cost_sale_item_derived
549: FROM OE_ORDER_LINES OL,
550: MTL_SYSTEM_ITEMS M
551: WHERE OL.LINE_ID = l_line_id
552: AND M.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID
553: AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;
554: EXCEPTION

Line 585: MTL_SYSTEM_ITEMS M

581:
582: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
583: INTO l_cost_sale_item_derived
584: FROM OE_ORDER_LINES OL,
585: MTL_SYSTEM_ITEMS M
586: WHERE OL.LINE_ID = l_link_to_line_id
587: AND M.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID
588: AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;
589: EXCEPTION

Line 721: MTL_SYSTEM_ITEMS M

717: BEGIN
718: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
719: INTO l_cost_sale_model_derived
720: FROM OE_ORDER_LINES OL,
721: MTL_SYSTEM_ITEMS M
722: WHERE OL.LINE_ID = l_model_line_id
723: AND M.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID
724: AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;
725: EXCEPTION

Line 1276: FROM MTL_SYSTEM_ITEMS

1272: IF (L_INV_ITEM_ID IS NOT NULL) THEN
1273: BEGIN
1274: SELECT NVL(COST_OF_SALES_ACCOUNT, 0)
1275: INTO l_account_derived
1276: FROM MTL_SYSTEM_ITEMS
1277: WHERE INVENTORY_ITEM_ID = l_inv_item_id
1278: AND ORGANIZATION_ID = l_ship_from_org_id;
1279: EXCEPTION
1280: WHEN NO_DATA_FOUND THEN