DBA Data[Home] [Help]

APPS.MRP_MRPRPROP_XMLP_PKG dependencies on GMP_APS_OUTPUT_PKG

Line 1292: DECODE(NVL(GMP_APS_OUTPUT_PKG.RETRIEVE_ITEM_COST(ITEM_ID

1288: AND cst.inventory_item_id (+) = SYS.INVENTORY_ITEM_ID
1289: AND SYS.INVENTORY_ITEM_ID = ITEM_ID;
1290: ELSE
1291: SELECT
1292: DECODE(NVL(GMP_APS_OUTPUT_PKG.RETRIEVE_ITEM_COST(ITEM_ID
1293: ,ORG_ID)
1294: ,0) * NVL(SYS.CARRYING_COST / 100
1295: ,0)
1296: ,0

Line 1299: ,0) / (GMP_APS_OUTPUT_PKG.RETRIEVE_ITEM_COST(ITEM_ID

1295: ,0)
1296: ,0
1297: ,0
1298: ,NVL(SYS.ORDER_COST
1299: ,0) / (GMP_APS_OUTPUT_PKG.RETRIEVE_ITEM_COST(ITEM_ID
1300: ,ORG_ID) * (SYS.CARRYING_COST / 100)))
1301: INTO COST_RATIO
1302: FROM
1303: MTL_SYSTEM_ITEMS SYS