eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_PICKING_PVT dependencies on MTL_SYSTEM_ITEMS

Line 112: || ' (SELECT inventory_item_id FROM mtl_system_items_kfv WHERE organization_id = :organization_id'

108: || ' AND NVL(oprn_vers, -1) = NVL(:oprn_vers, NVL(oprn_vers, -1))'
109: || ' AND (:product_no IS NULL OR batch_id IN (SELECT DISTINCT batch_id FROM gme_material_details'
110: || ' WHERE organization_id = :organization_id'
111: || ' AND line_type = 1 AND inventory_item_id IN'
112: || ' (SELECT inventory_item_id FROM mtl_system_items_kfv WHERE organization_id = :organization_id'
113: || ' AND concatenated_segments LIKE :product_no)))'
114: || ' AND (:ingredient_no IS NULL OR batch_id IN (SELECT DISTINCT batch_id FROM gme_material_details'
115: || ' WHERE organization_id = :organization_id'
116: || ' AND line_type = -1 AND inventory_item_id IN'

Line 117: || ' (SELECT inventory_item_id FROM mtl_system_items_kfv WHERE organization_id = :organization_id'

113: || ' AND concatenated_segments LIKE :product_no)))'
114: || ' AND (:ingredient_no IS NULL OR batch_id IN (SELECT DISTINCT batch_id FROM gme_material_details'
115: || ' WHERE organization_id = :organization_id'
116: || ' AND line_type = -1 AND inventory_item_id IN'
117: || ' (SELECT inventory_item_id FROM mtl_system_items_kfv WHERE organization_id = :organization_id'
118: || ' AND concatenated_segments LIKE :ingredient_no)))'
119: || ' AND material_requirement_date <= SYSDATE + NVL(:days_forward, 100000)'
120: || ' AND material_requirement_date >= NVL(:from_req_date, material_requirement_date)'
121: || ' AND material_requirement_date <= NVL(:to_req_date, material_requirement_date)';

Line 710: item_rec mtl_system_items%ROWTYPE;

706: l_rsv_detailed_qty_conv NUMBER; -- The qty detailed for a reservation. (In reservation UOM)
707: l_is_serial_control BOOLEAN;
708: l_is_revision_control BOOLEAN;
709: l_is_lot_control BOOLEAN;
710: item_rec mtl_system_items%ROWTYPE;
711: l_mtl_dtl_rec gme_material_details%ROWTYPE;
712: l_qty_on_hand NUMBER;
713: l_qty_res_on_hand NUMBER;
714: l_qty_res NUMBER;

Line 918: --item_rec is required to get all UOM quantities from MTL_SYSTEM_ITEMS

914: IF l_inv_resv_tbl.COUNT > 0 THEN
915: --initializing the index
916: l_res_ordered_index := l_inv_resv_tbl.FIRST;
917: LOOP
918: --item_rec is required to get all UOM quantities from MTL_SYSTEM_ITEMS
919: SELECT *
920: INTO item_rec
921: FROM MTL_SYSTEM_ITEMS
922: WHERE organization_id = l_inv_resv_tbl(l_res_ordered_index).organization_id

Line 921: FROM MTL_SYSTEM_ITEMS

917: LOOP
918: --item_rec is required to get all UOM quantities from MTL_SYSTEM_ITEMS
919: SELECT *
920: INTO item_rec
921: FROM MTL_SYSTEM_ITEMS
922: WHERE organization_id = l_inv_resv_tbl(l_res_ordered_index).organization_id
923: AND inventory_item_id = l_inv_resv_tbl(l_res_ordered_index).inventory_item_id;
924:
925: l_primary_uom:= item_rec.primary_uom_code;