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 930: FROM mtl_system_items

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

Line 1025: FROM MTL_SYSTEM_ITEMS MSI,

1021: l_wip_repetitive_schedule_id,
1022: l_wip_operation_seq_num,
1023: l_wip_resource_seq_num,
1024: l_bom_resource_id
1025: FROM MTL_SYSTEM_ITEMS MSI,
1026: PO_LINES_ALL POL,
1027: PO_DISTRIBUTIONS_ALL POD,
1028: PO_HEADERS_ALL POH,
1029: PO_LINE_LOCATIONS_ALL POLL