DBA Data[Home] [Help]

APPS.INV_LABEL_PVT5 dependencies on PO_HEADERS_TRX_V

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

203: pov.vendor_id vendor_id, pov.vendor_name supplier_name,
204: pvs.vendor_site_id vendor_site_id, pvs.vendor_site_code supplier_site,
205: ppf.full_name requestor, hrl1.location_code deliver_to_location,
206: hrl2.location_code location, pll.note_to_receiver note_to_receiver
207: FROM rcv_transactions_interface rti, po_headers_trx_v pha,--CLM Changes,using CLM views instead of base tables
208: -- MOAC : changed po_line_locations to po_line_locations_all
209: po_lines_trx_v pol, rcv_shipment_headers rsh, po_line_locations_trx_v pll,
210: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
211: -- MOAC : changed po_vendor_sites to po_vendor_sites_all

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

235: pvs.vendor_site_id vendor_site_id,
236: pvs.vendor_site_code supplier_site, ppf.full_name requestor,
237: hrl1.location_code deliver_to_location, hrl2.location_code location,
238: pll.note_to_receiver note_to_receiver
239: FROM rcv_transactions_interface rti, po_headers_trx_v pha,--CLM Changes,using CLM views instead of base tables
240: -- MOAC : changed po_line_locations to po_line_locations_all
241: po_lines_trx_v pol, rcv_shipment_headers rsh, po_line_locations_trx_v pll,
242: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
243: -- MOAC : changed po_vendor_sites to po_vendor_sites_all

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

421: AND p_label_type_info.business_flow_code = 1
422: )
423: )
424: ) all_lpn
425: , po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables
426: , po_lines_trx_v pol
427: , rcv_shipment_headers rsh
428: , rcv_shipment_lines rsl
429: -- MOAC : changed po_line_locations to po_line_locations_all

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

699: and rsh.shipment_header_id = p_transaction_id
700: and rsl.asn_lpn_id = lpn.lpn_id
701: AND rsh.asn_type = 'ASN'
702: ) all_lpn
703: , po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables
704: , po_lines_trx_v pol
705: , rcv_shipment_headers rsh
706: -- MOAC : changed po_line_locations to po_line_locations_all
707: , po_line_locations_trx_v pll