APPS.MRP_MRPRPROP_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS

Line 1284: MTL_SYSTEM_ITEMS SYS,

1280: ,NVL(SYS.ORDER_COST
1281: ,0) / (CST.ITEM_COST * (SYS.CARRYING_COST / 100)))
1282: INTO COST_RATIO
1283: FROM
1284: MTL_SYSTEM_ITEMS SYS,
1285: CST_ITEM_COSTS_FOR_GL_VIEW CST
1286: WHERE cst.organization_id (+) = SYS.ORGANIZATION_ID
1287: AND SYS.ORGANIZATION_ID = ORG_ID
1288: AND cst.inventory_item_id (+) = SYS.INVENTORY_ITEM_ID

Line 1303: MTL_SYSTEM_ITEMS SYS

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
1304: WHERE SYS.ORGANIZATION_ID = ORG_ID
1305: AND SYS.INVENTORY_ITEM_ID = ITEM_ID;
1306: END IF;
1307: SELECT

Line 1369: MTL_SYSTEM_ITEMS

1365: SELECT
1366: ROUNDING_CONTROL_TYPE
1367: INTO L_ROUND
1368: FROM
1369: MTL_SYSTEM_ITEMS
1370: WHERE ORGANIZATION_ID = ORG_ID
1371: AND INVENTORY_ITEM_ID = ITEM_ID;
1372: IF L_ROUND = 1 THEN
1373: RETURN (ROUND(REORDER_QTY));

Line 1757: FROM mtl_supply sup, mtl_system_items items

1753: SCD := TO_CHAR(SUPPLY_CUTOFF_DATE
1754: ,'DD-MON-RRRR');
1755: L_STMT := 'SELECT to_char(nvl(sum(to_org_primary_quantity), 0))
1756: INTO :char_qty
1757: FROM mtl_supply sup, mtl_system_items items
1758: WHERE sup.supply_type_code in (''PO'',''REQ'',''ASN'',''SHIPMENT'',''RECEIVING'')
1759: AND sup.destination_type_code =''INVENTORY''
1760: AND sup.to_organization_id =' || TO_CHAR(ORG_ID) || '
1761: AND sup.item_id =' || TO_CHAR(CURRENT_ITEM_ID) || '