DBA Data[Home] [Help]

APPS.INV_LABEL_PVT4 dependencies on PO_HEADERS_TRX_V

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

134: pov.vendor_name supplier_name, pvs.vendor_site_id vendor_site_id,
135: pvs.vendor_site_code supplier_site, ppf.full_name requestor,
136: hrl1.location_code deliver_to_location,
137: hrl2.location_code location, pll.note_to_receiver note_to_receiver
138: FROM rcv_transactions_interface rti, po_headers_trx_v pha,--CLM Changes, using CLM views instead of base tables
139: -- MOAC : po_line_locations changed to po_line_locations_all
140: po_lines_trx_v pol, rcv_shipment_headers rsh, po_line_locations_trx_v pll,
141: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
142: -- MOAC : po_vendor_sites changed to po_vendor_sites_all

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

166: pov.vendor_name supplier_name, pvs.vendor_site_id vendor_site_id,
167: pvs.vendor_site_code supplier_site, ppf.full_name requestor,
168: hrl1.location_code deliver_to_location,
169: hrl2.location_code location, pll.note_to_receiver note_to_receiver
170: FROM rcv_transactions_interface rti, po_headers_trx_v pha,--CLM Changes,using CLM views instead of base tables
171: -- MOAC : po_line_locations changed to po_line_locations_all
172: po_lines_trx_v pol, rcv_shipment_headers rsh, po_line_locations_trx_v pll,
173: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
174: -- MOAC : po_vendor_sites changed to po_vendor_sites_all

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

381: AND p_label_type_info.business_flow_code = 1
382: )
383: )
384: ) all_lpn
385: , po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables
386: , po_lines_trx_v pol
387: , rcv_shipment_headers rsh
388: , rcv_shipment_lines rsl
389: -- MOAC : po_line_locations changed to po_line_locations_all

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

1188: AND lpn.outermost_lpn_id <> lpn.lpn_id
1189: AND lpn.outermost_lpn_id <> lpn.parent_lpn_id
1190: AND rsh.asn_type = 'ASN'
1191: ) all_lpn ,
1192: po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables
1193: ,
1194: po_lines_trx_v pol ,
1195: rcv_shipment_headers rsh
1196: -- MOAC : po_line_locations changed to po_line_locations_all