APPS.POR_RCV_ORD_SV dependencies on MTL_SYSTEM_ITEMS

Line 616: FROM mtl_system_items

612: AND base_uom_flag = 'Y';
613: ELSE
614: SELECT primary_unit_of_measure
615: INTO X_primary_uom
616: FROM mtl_system_items
617: WHERE inventory_item_id = x_item_id
618: AND organization_id = x_org_id;
619:
620: END IF;

Line 779: MTL_SYSTEM_ITEMS MSI

775: X_WayBillNum,
776: NULL
777: FROM RCV_SHIPMENT_HEADERS RSH,
778: RCV_SHIPMENT_LINES RSL,
779: MTL_SYSTEM_ITEMS MSI
780: WHERE RSH.RECEIPT_SOURCE_CODE <> 'VENDOR' AND
781: RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID AND
782: MSI.ORGANIZATION_ID (+) = RSL.TO_ORGANIZATION_ID AND
783: MSI.INVENTORY_ITEM_ID (+) = RSL.ITEM_ID and

Line 931: FROM mtl_system_items

927: AND base_uom_flag = 'Y';
928: ELSE
929: SELECT primary_unit_of_measure
930: INTO X_primary_uom
931: FROM mtl_system_items
932: WHERE inventory_item_id = x_item_id
933: AND organization_id = x_org_id;
934: END IF;
935:

Line 1030: FROM MTL_SYSTEM_ITEMS MSI,

1026: l_wip_resource_seq_num,
1027: l_bom_resource_id,
1028: --Bug 8893932 PO RECEIVED FROM IPROCUREMENT DOESNT POPULATE COUNTRY OF ORIGIN
1029: l_country_of_origin
1030: FROM MTL_SYSTEM_ITEMS MSI,
1031: PO_LINES_ALL POL,
1032: PO_DISTRIBUTIONS_ALL POD,
1033: PO_HEADERS_ALL POH,
1034: PO_LINE_LOCATIONS_ALL POLL