[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;
1270: msn.inventory_item_id, msn.revision, msn.lot_number,
1271: msn.serial_number, to_number(NULL) quantity, rt.transaction_type,
1272: rt.interface_transaction_id, msn.COST_GROUP_ID cg_id,
1273: rt.destination_type_code, rt.quantity rt_quantity, rt.parent_transaction_id
1274: FROM mtl_serial_numbers msn, rcv_transactions rt, rcv_shipment_lines rsl
1275: WHERE rt.group_id = p_group_id
1276: AND ((rt.transaction_type = 'CORRECT' AND Nvl(msn.lpn_id,-1) = Nvl(rt.lpn_id,-1))
1277: OR (rt.transaction_type = 'RETURN TO RECEIVING'
1278: AND Nvl(msn.lpn_id,-1) = Nvl(rt.transfer_lpn_id,-1)))
1294: msn.inventory_item_id, msn.revision, msn.lot_number,
1295: msn.serial_number, to_number(NULL) quantity, rt.transaction_type,
1296: rt.interface_transaction_id, msn.COST_GROUP_ID cg_id,
1297: rt.destination_type_code, rt.quantity rt_quantity, rt.parent_transaction_id
1298: FROM mtl_serial_numbers msn, rcv_transactions rt, rcv_shipment_lines rsl
1299: WHERE rt.transaction_date >= (Sysdate - 1)
1300: AND rt.lpn_group_id = p_group_id
1301: AND ((rt.transaction_type = 'CORRECT' AND Nvl(msn.lpn_id,-1) = Nvl(rt.lpn_id,-1))
1302: OR (rt.transaction_type = 'RETURN TO RECEIVING'
1320: msn.inventory_item_id, msn.revision, msn.lot_number,
1321: msn.serial_number, to_number(NULL) quantity, rt.transaction_type,
1322: rt.interface_transaction_id, msn.COST_GROUP_ID cg_id,
1323: rt.destination_type_code, rt.quantity rt_quantity, rt.parent_transaction_id
1324: FROM mtl_serial_numbers msn, rcv_transactions rt, rcv_shipment_lines rsl
1325: WHERE rt.group_id = p_group_id
1326: AND ((rt.transaction_type = 'CORRECT' AND Nvl(msn.lpn_id,-1) = Nvl(rt.lpn_id,-1))
1327: OR (rt.transaction_type = 'RETURN TO RECEIVING'
1328: AND Nvl(msn.lpn_id,-1) = Nvl(rt.transfer_lpn_id,-1)))
1372: rt.from_subinventory,
1373: rt.from_locator_id,
1374: rt.lpn_id,
1375: rt.quantity
1376: FROM rcv_transactions rt, rcv_shipment_lines rsl
1377: WHERE rt.group_id = p_group_id
1378: AND p_txn_mode <> 'LPN_GROUP'
1379: AND rt.transaction_type IN ('RETURN TO VENDOR','RETURN TO RECEIVING', 'RETURN TO CUSTOMER')
1380: AND rt.shipment_line_id = rsl.shipment_line_id;
1388: rt.from_subinventory,
1389: rt.from_locator_id,
1390: rt.lpn_id,
1391: rt.quantity
1392: FROM rcv_transactions rt, rcv_shipment_lines rsl
1393: WHERE rt.transaction_date >= (SYSDATE-1)
1394: AND rt.lpn_group_id = p_group_id
1395: AND p_txn_mode = 'LPN_GROUP'
1396: AND rt.transaction_type IN ('RETURN TO VENDOR','RETURN TO RECEIVING', 'RETURN TO CUSTOMER')