APPS.INV_LABEL_PVT3 dependencies on PO_HEADERS_TRX_V

Line 57: FROM rcv_transactions_interface rti, po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables

53: SELECT rti.lpn_id lpn_id
54: , pha.segment1 purchase_order
55: , rti.subinventory
56: , rti.locator_id
57: FROM rcv_transactions_interface rti, po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables
58: WHERE rti.interface_transaction_id = p_transaction_id
59: AND rti.po_header_id = pha.po_header_id(+);
60:
61: CURSOR c_rti_lpn_inspection IS

Line 66: FROM rcv_transactions_interface rti, po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables

62: SELECT rti.transfer_lpn_id transfer_lpn_id
63: , pha.segment1 purchase_order
64: , rti.subinventory
65: , rti.locator_id
66: FROM rcv_transactions_interface rti, po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables
67: WHERE rti.interface_transaction_id = p_transaction_id
68: AND rti.po_header_id = pha.po_header_id(+);
69:
70: CURSOR c_mmtt_lpn IS

Line 301: , po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables

297: --AND rt.routing_header_id <> 3
298: AND p_label_type_info.business_flow_code = 1
299: )
300: )) all_lpn
301: , po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables
302: , wms_license_plate_numbers wlpn -- Bug 3836623
303: WHERE pha.po_header_id(+) = all_lpn.po_header_id
304: -- Bug 3836623
305: -- Add check for LPN context

Line 470: , po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables

466: and rsh.shipment_header_id = p_transaction_id
467: and rsl.asn_lpn_id = lpn.lpn_id
468: AND rsh.asn_type = 'ASN'
469: ) all_lpn
470: , po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables
471: , po_lines_trx_v pol
472: , rcv_shipment_headers rsh
473: , po_line_locations_trx_v pll
474: WHERE pha.po_header_id(+) = all_lpn.po_header_id