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_PVT4 dependencies on HR_LOCATIONS_ALL

Line 141: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,

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
143: po_vendor_sites_all pvs, per_people_f ppf
144: where rti.interface_transaction_id = p_transaction_id
145: AND rti.po_header_id = pha.po_header_id(+)

Line 173: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,

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
175: po_vendor_sites_all pvs, per_people_f ppf
176: where rti.interface_transaction_id = p_transaction_id
177: AND rti.po_header_id = pha.po_header_id(+)

Line 392: -- , hr_locations_all hrl1

388: , rcv_shipment_lines rsl
389: -- MOAC : po_line_locations changed to po_line_locations_all
390: , po_line_locations_trx_v pll
391: , po_vendors pov
392: -- , hr_locations_all hrl1
393: -- , hr_locations_all hrl2
394: -- MOAC : po_vendor_sites changed to po_vendor_sites_all
395: , po_vendor_sites_all pvs
396: , per_people_f ppf

Line 393: -- , hr_locations_all hrl2

389: -- MOAC : po_line_locations changed to po_line_locations_all
390: , po_line_locations_trx_v pll
391: , po_vendors pov
392: -- , hr_locations_all hrl1
393: -- , hr_locations_all hrl2
394: -- MOAC : po_vendor_sites changed to po_vendor_sites_all
395: , po_vendor_sites_all pvs
396: , per_people_f ppf
397: , wms_license_plate_numbers wlpn

Line 434: from hr_locations_all hrl1

430: Select
431: decode(l_deliver_to_location_id,null,null,hrl1.location_code)
432: deliver_to_location
433: , decode(l_location_id,null,null,hrl2.location_code) location
434: from hr_locations_all hrl1
435: , hr_locations_all hrl2
436: where hrl1.location_id = decode(l_deliver_to_location_id,null,hrl1.location_id,l_deliver_to_location_id)
437: AND hrl2.location_id = decode(l_location_id,null,hrl2.location_id,l_location_id)
438: and hrl1.location_id = hrl2.location_id;

Line 435: , hr_locations_all hrl2

431: decode(l_deliver_to_location_id,null,null,hrl1.location_code)
432: deliver_to_location
433: , decode(l_location_id,null,null,hrl2.location_code) location
434: from hr_locations_all hrl1
435: , hr_locations_all hrl2
436: where hrl1.location_id = decode(l_deliver_to_location_id,null,hrl1.location_id,l_deliver_to_location_id)
437: AND hrl2.location_id = decode(l_location_id,null,hrl2.location_id,l_location_id)
438: and hrl1.location_id = hrl2.location_id;
439:

Line 1200: hr_locations_all hrl1 ,

1196: -- MOAC : po_line_locations changed to po_line_locations_all
1197: ,
1198: po_line_locations_trx_v pll ,
1199: po_vendors pov ,
1200: hr_locations_all hrl1 ,
1201: hr_locations_all hrl2
1202: -- MOAC : po_vendor_sites changed to po_vendor_sites_all
1203: ,
1204: po_vendor_sites_all pvs ,

Line 1201: hr_locations_all hrl2

1197: ,
1198: po_line_locations_trx_v pll ,
1199: po_vendors pov ,
1200: hr_locations_all hrl1 ,
1201: hr_locations_all hrl2
1202: -- MOAC : po_vendor_sites changed to po_vendor_sites_all
1203: ,
1204: po_vendor_sites_all pvs ,
1205: per_people_f ppf

Line 1445: l_deliver_to_location hr_locations_all.LOCATION_CODE%TYPE;

1441: -- Increased this variable size to the corresponding column size in the table.
1442: l_supplier_name po_vendors.VENDOR_NAME%TYPE;
1443: l_supplier_site po_vendor_sites.VENDOR_SITE_CODE%TYPE;
1444: l_requestor per_people_f.FULL_NAME%TYPE;
1445: l_deliver_to_location hr_locations_all.LOCATION_CODE%TYPE;
1446: l_location_code hr_locations_all.LOCATION_CODE%TYPE;
1447: l_note_to_receiver po_line_locations.NOTE_TO_RECEIVER%TYPE;
1448:
1449: -- END of Bug fix for 3916663

Line 1446: l_location_code hr_locations_all.LOCATION_CODE%TYPE;

1442: l_supplier_name po_vendors.VENDOR_NAME%TYPE;
1443: l_supplier_site po_vendor_sites.VENDOR_SITE_CODE%TYPE;
1444: l_requestor per_people_f.FULL_NAME%TYPE;
1445: l_deliver_to_location hr_locations_all.LOCATION_CODE%TYPE;
1446: l_location_code hr_locations_all.LOCATION_CODE%TYPE;
1447: l_note_to_receiver po_line_locations.NOTE_TO_RECEIVER%TYPE;
1448:
1449: -- END of Bug fix for 3916663
1450: