APPS.INV_LABEL_PVT3 dependencies on RCV_TRANSACTIONS

Line 55: FROM rcv_transactions_interface rti, po_headers_all pha

51: SELECT rti.lpn_id lpn_id
52: , pha.segment1 purchase_order
53: , rti.subinventory
54: , rti.locator_id
55: FROM rcv_transactions_interface rti, po_headers_all pha
56: WHERE rti.interface_transaction_id = p_transaction_id
57: AND rti.po_header_id = pha.po_header_id(+);
58:
59: CURSOR c_rti_lpn_inspection IS

Line 64: FROM rcv_transactions_interface rti, po_headers_all pha

60: SELECT rti.transfer_lpn_id transfer_lpn_id
61: , pha.segment1 purchase_order
62: , rti.subinventory
63: , rti.locator_id
64: FROM rcv_transactions_interface rti, po_headers_all pha
65: WHERE rti.interface_transaction_id = p_transaction_id
66: AND rti.po_header_id = pha.po_header_id(+);
67:
68: CURSOR c_mmtt_lpn IS

Line 155: FROM rcv_transactions rt

151: SELECT lpn_id
152: , po_header_id
153: , subinventory
154: , locator_id
155: FROM rcv_transactions rt
156: WHERE lpn_id IS NOT NULL
157: AND rt.group_id = p_transaction_id
158: AND ((rt.transaction_type IN ('ACCEPT', 'REJECT')
159: AND p_label_type_info.business_flow_code = 2)

Line 174: FROM wms_license_plate_numbers lpn, rcv_transactions rt

170: SELECT lpn.parent_lpn_id
171: , rt.po_header_id
172: , rt.subinventory
173: , rt.locator_id
174: FROM wms_license_plate_numbers lpn, rcv_transactions rt
175: WHERE lpn.lpn_id = rt.lpn_id
176: -- AND lpn.parent_lpn_id <> rt.lpn_id
177: AND rt.group_id = p_transaction_id
178: AND lpn.parent_lpn_id is not null

Line 195: FROM wms_license_plate_numbers lpn, rcv_transactions rt

191: SELECT lpn.outermost_lpn_id
192: , rt.po_header_id
193: , rt.subinventory
194: , rt.locator_id
195: FROM wms_license_plate_numbers lpn, rcv_transactions rt
196: WHERE lpn.lpn_id = rt.lpn_id
197: -- AND lpn.outermost_lpn_id <> lpn.lpn_id
198: -- AND lpn.outermost_lpn_id <> lpn.parent_lpn_id
199: AND rt.group_id = p_transaction_id

Line 216: FROM rcv_transactions rt

212: SELECT transfer_lpn_id lpn_id
213: , po_header_id
214: , subinventory
215: , locator_id
216: FROM rcv_transactions rt
217: WHERE
218: --rt.transfer_lpn_id <> rt.lpn_id AND
219: rt.group_id = p_transaction_id
220: AND ((rt.transaction_type IN ('ACCEPT', 'REJECT')

Line 236: FROM wms_license_plate_numbers lpn, rcv_transactions rt

232: SELECT lpn.parent_lpn_id
233: , rt.po_header_id
234: , rt.subinventory
235: , rt.locator_id
236: FROM wms_license_plate_numbers lpn, rcv_transactions rt
237: WHERE lpn.lpn_id = rt.transfer_lpn_id
238: -- AND rt.transfer_lpn_id <> rt.lpn_id
239: -- AND lpn.parent_lpn_id <> lpn.lpn_id
240: AND lpn.parent_lpn_id is not null

Line 258: FROM wms_license_plate_numbers lpn, rcv_transactions rt

254: SELECT lpn.outermost_lpn_id
255: , rt.po_header_id
256: , rt.subinventory
257: , rt.locator_id
258: FROM wms_license_plate_numbers lpn, rcv_transactions rt
259: WHERE lpn.lpn_id = rt.transfer_lpn_id
260: -- AND rt.transfer_lpn_id <> rt.lpn_id
261: -- AND lpn.outermost_lpn_id <> lpn.lpn_id
262: -- AND lpn.outermost_lpn_id <> lpn.parent_lpn_id