eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LABEL_PVT5 dependencies on PO_LINE_LOCATIONS

Line 208: -- MOAC : changed po_line_locations to po_line_locations_all

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
212: po_vendor_sites_all pvs, per_people_f ppf

Line 209: po_lines_trx_v pol, rcv_shipment_headers rsh, po_line_locations_trx_v pll,

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
212: po_vendor_sites_all pvs, per_people_f ppf
213: where rti.interface_transaction_id = p_transaction_id

Line 240: -- MOAC : changed po_line_locations to po_line_locations_all

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
244: po_vendor_sites_all pvs, per_people_f ppf

Line 241: po_lines_trx_v pol, rcv_shipment_headers rsh, po_line_locations_trx_v pll,

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
244: po_vendor_sites_all pvs, per_people_f ppf
245: where rti.interface_transaction_id = p_transaction_id

Line 429: -- MOAC : changed po_line_locations to po_line_locations_all

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
430: , po_line_locations_trx_v pll
431: , po_vendors pov
432: -- , hr_locations_all hrl1
433: -- , hr_locations_all hrl2

Line 430: , po_line_locations_trx_v pll

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
430: , po_line_locations_trx_v pll
431: , po_vendors pov
432: -- , hr_locations_all hrl1
433: -- , hr_locations_all hrl2
434: -- MOAC : changed po_vendor_sites to po_vendor_sites_all

Line 706: -- MOAC : changed po_line_locations to po_line_locations_all

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
708: , po_vendors pov
709: , hr_locations_all hrl1
710: , hr_locations_all hrl2

Line 707: , po_line_locations_trx_v pll

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
708: , po_vendors pov
709: , hr_locations_all hrl1
710: , hr_locations_all hrl2
711: -- MOAC : changed po_vendor_sites to po_vendor_sites_all

Line 1414: l_note_to_receiver po_line_locations.NOTE_TO_RECEIVER%TYPE;

1410: l_supplier_site po_vendor_sites.VENDOR_SITE_CODE%TYPE;
1411: l_requestor per_people_f.FULL_NAME%TYPE;
1412: l_deliver_to_location hr_locations_all.LOCATION_CODE%TYPE;
1413: l_location_code hr_locations_all.LOCATION_CODE%TYPE;
1414: l_note_to_receiver po_line_locations.NOTE_TO_RECEIVER%TYPE;
1415:
1416: -- END of Bug fix for 3916663
1417:
1418: -- Bug 2515486