[Home] [Help]
38: , msi.lot_control_code
39: , DECODE(MSI.RETURN_INSPECTION_REQUIREMENT,1,'Y','N') INSPECTION_REQUIRED_FLAG
40: , rsl.from_organization_id
41: , rsl.asn_line_flag
42: FROM rcv_shipment_lines rsl
43: , mtl_system_items msi
44: , rcv_transactions rt
45: WHERE rt.group_id = p_group_id
46: AND (rt.transaction_type = 'CORRECT'
77: , rt.parent_transaction_id
78: , rsl.asn_line_flag
79: , DECODE(MSI.RETURN_INSPECTION_REQUIREMENT,1,'Y','N') INSPECTION_REQUIRED_FLAG
80: FROM mtl_transaction_lots_temp mtlt
81: , rcv_shipment_lines rsl
82: , rcv_transactions rt
83: , mtl_system_items msi
84: WHERE rt.group_id = p_group_id
85: AND (mtlt.transaction_temp_id (+) = rt.interface_transaction_id
135: , rsl.asn_line_flag
136: , DECODE(MSI.RETURN_INSPECTION_REQUIREMENT,1,'Y','N') INSPECTION_REQUIRED_FLAG
137: FROM mtl_material_transactions mmt
138: , mtl_transaction_lot_numbers mtln
139: , rcv_shipment_lines rsl
140: , rcv_transactions rt
141: , mtl_system_items msi
142: WHERE rt.group_id = p_group_id
143: AND mmt.rcv_transaction_id = rt.transaction_id
358: BEGIN
359: l_progress := '118';
360: SELECT routing_header_id
361: INTO l_routing_id
362: FROM rcv_shipment_lines
363: WHERE shipment_line_id = i.shipment_line_id;
364: EXCEPTION
365: WHEN OTHERS THEN NULL;
366: END;
694: BEGIN
695: l_progress := '350';
696: SELECT routing_header_id
697: INTO l_routing_id
698: FROM rcv_shipment_lines
699: WHERE shipment_line_id = i.shipment_line_id;
700: EXCEPTION
701: WHEN OTHERS THEN NULL;
702: END;
1251: msn.inventory_item_id, msn.revision, msn.lot_number,
1252: msn.serial_number, to_number(NULL) quantity, rt.transaction_type,
1253: rt.interface_transaction_id, msn.COST_GROUP_ID cg_id,
1254: rt.destination_type_code, rt.quantity rt_quantity, rt.parent_transaction_id
1255: FROM mtl_serial_numbers msn, rcv_transactions rt, rcv_shipment_lines rsl
1256: WHERE rt.group_id = p_group_id
1257: AND ((rt.transaction_type = 'CORRECT' AND Nvl(msn.lpn_id,-1) = Nvl(rt.lpn_id,-1))
1258: OR (rt.transaction_type = 'RETURN TO RECEIVING'
1259: AND Nvl(msn.lpn_id,-1) = Nvl(rt.transfer_lpn_id,-1)))
1275: msn.inventory_item_id, msn.revision, msn.lot_number,
1276: msn.serial_number, to_number(NULL) quantity, rt.transaction_type,
1277: rt.interface_transaction_id, msn.COST_GROUP_ID cg_id,
1278: rt.destination_type_code, rt.quantity rt_quantity, rt.parent_transaction_id
1279: FROM mtl_serial_numbers msn, rcv_transactions rt, rcv_shipment_lines rsl
1280: WHERE rt.transaction_date >= (Sysdate - 1)
1281: AND rt.lpn_group_id = p_group_id
1282: AND ((rt.transaction_type = 'CORRECT' AND Nvl(msn.lpn_id,-1) = Nvl(rt.lpn_id,-1))
1283: OR (rt.transaction_type = 'RETURN TO RECEIVING'
1301: msn.inventory_item_id, msn.revision, msn.lot_number,
1302: msn.serial_number, to_number(NULL) quantity, rt.transaction_type,
1303: rt.interface_transaction_id, msn.COST_GROUP_ID cg_id,
1304: rt.destination_type_code, rt.quantity rt_quantity, rt.parent_transaction_id
1305: FROM mtl_serial_numbers msn, rcv_transactions rt, rcv_shipment_lines rsl
1306: WHERE rt.group_id = p_group_id
1307: AND ((rt.transaction_type = 'CORRECT' AND Nvl(msn.lpn_id,-1) = Nvl(rt.lpn_id,-1))
1308: OR (rt.transaction_type = 'RETURN TO RECEIVING'
1309: AND Nvl(msn.lpn_id,-1) = Nvl(rt.transfer_lpn_id,-1)))
1353: rt.from_subinventory,
1354: rt.from_locator_id,
1355: rt.lpn_id,
1356: rt.quantity
1357: FROM rcv_transactions rt, rcv_shipment_lines rsl
1358: WHERE rt.group_id = p_group_id
1359: AND p_txn_mode <> 'LPN_GROUP'
1360: AND rt.transaction_type IN ('RETURN TO VENDOR','RETURN TO RECEIVING', 'RETURN TO CUSTOMER')
1361: AND rt.shipment_line_id = rsl.shipment_line_id;
1369: rt.from_subinventory,
1370: rt.from_locator_id,
1371: rt.lpn_id,
1372: rt.quantity
1373: FROM rcv_transactions rt, rcv_shipment_lines rsl
1374: WHERE rt.transaction_date >= (SYSDATE-1)
1375: AND rt.lpn_group_id = p_group_id
1376: AND p_txn_mode = 'LPN_GROUP'
1377: AND rt.transaction_type IN ('RETURN TO VENDOR','RETURN TO RECEIVING', 'RETURN TO CUSTOMER')