[Home] [Help]
1029: AND rti.processing_status_code = 'WSH_INTERFACED'
1030: AND wdd.organization_id <> rti.to_organization_id
1031: AND rti.shipment_line_id IS NOT NULL
1032: AND NOT EXISTS (SELECT 1
1033: FROM mtl_material_transactions mmt
1034: WHERE mmt.picking_line_id = wdd.delivery_detail_id)
1035: ORDER BY source_line_id, source_line_number;
1036:
1037: -- Cursor for picking Returns made from an org different from Receipt's org which are pending after DIrect org txr.
1050: AND rti.processing_status_code = 'WSH_INTERFACED'
1051: AND wdd.organization_id <> rti.to_organization_id
1052: AND rti.shipment_line_id IS NOT NULL
1053: AND EXISTS (SELECT 1
1054: FROM mtl_material_transactions mmt
1055: WHERE mmt.picking_line_id = wdd.delivery_detail_id)
1056: AND NOT EXISTS (SELECT 1 from rcv_transactions rt
1057: WHERE rt.transaction_type = 'RETURN TO VENDOR'
1058: AND rt.interface_source_line_id = wdd.delivery_detail_id)
1077: CURSOR wdd_cursor_6 IS
1078: SELECT wdd.delivery_detail_id
1079: FROM wsh_delivery_details wdd,
1080: wsh_delivery_assignments wda,
1081: mtl_material_transactions mmt
1082: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
1083: AND wda.delivery_id = p_delivery_id
1084: AND wdd.source_code = 'RTV'
1085: AND wdd.released_status = 'C'
1121: asn_debug.put_line('-------------------------------------------');
1122: asn_debug.put_line(' Processing Returns without receipts');
1123: asn_debug.put_line('-------------------------------------------');
1124: END IF;
1125: SELECT mtl_material_transactions_s.nextval INTO l_header_id FROM DUAL; -- Bug 11831232
1126: END IF;
1127: load_mtl_interfaces ('Issue out', wdd_rec, l_header_id, p_delivery_id);
1128: END LOOP;
1129:
1220: asn_debug.put_line('-------------------------------------------');
1221: asn_debug.put_line('Processing Direct transfers from Return hub');
1222: asn_debug.put_line('-------------------------------------------');
1223: END IF;
1224: SELECT mtl_material_transactions_s.nextval INTO l_header_id FROM DUAL; -- Bug 11831232
1225: END IF;
1226: load_mtl_interfaces ('Direct Transfer', wdd_rec, l_header_id, p_delivery_id);
1227: END LOOP;
1228:
1691: INTO l_txn_reference
1692: FROM rcv_transactions_interface
1693: WHERE interface_transaction_id = p_wdd_rec.source_line_id; -- Bug 12974284
1694: --
1695: SELECT mtl_material_transactions_s.nextval INTO l_temp_id FROM DUAL; -- Bug 11831232
1696: --
1697: INSERT INTO mtl_transactions_interface
1698: ( transaction_header_id,
1699: transaction_interface_id,
2292: IF (l_source_allows_lot AND p_wdd_rec.lot_number IS NOT NULL ) THEN
2293: IF (p_source = 'INV') THEN
2294: l_temp_id := p_parent_id;
2295: ELSIF (p_source = 'RCV') THEN
2296: SELECT mtl_material_transactions_s.nextval INTO l_temp_id FROM DUAL; -- Bug 11831232
2297: END IF;
2298: --
2299: INSERT INTO mtl_transaction_lots_interface
2300: ( transaction_interface_id,
2369:
2370: IF (l_serial_temp_id IS NULL) THEN
2371: IF (p_source = 'INV') THEN
2372: IF (l_lot_inserted) THEN
2373: SELECT mtl_material_transactions_s.nextval INTO l_serial_temp_id FROM DUAL; -- Bug 11831232
2374: ELSE
2375: l_serial_temp_id := p_parent_id;
2376: END IF;
2377: ELSIF (p_source = 'RCV') THEN
2374: ELSE
2375: l_serial_temp_id := p_parent_id;
2376: END IF;
2377: ELSIF (p_source = 'RCV') THEN
2378: SELECT mtl_material_transactions_s.nextval INTO l_serial_temp_id FROM DUAL; -- Bug 11831232
2379: END IF;
2380: END IF;
2381: --
2382: -- Transfer tagged serial to receipt org if return is done from another org ie, direct txr is completed at this point.
2636: rti.secondary_unit_of_measure bkup_rti_suom,
2637: rti.source_doc_unit_of_measure bkup_rti_src_uom
2638: FROM wsh_delivery_details wdd,
2639: wsh_delivery_assignments wda,
2640: mtl_material_transactions mmt,
2641: rcv_transactions_interface rti
2642: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
2643: AND wda.delivery_id = p_delivery_id
2644: AND wdd.source_code = 'RTV'