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 HR_LOCATIONS_ALL

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

203: hrl2.location_code location, pll.note_to_receiver note_to_receiver
204: FROM rcv_transactions_interface rti, po_headers_all pha,
205: -- MOAC : changed po_line_locations to po_line_locations_all
206: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,
207: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
208: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
209: po_vendor_sites_all pvs, per_people_f ppf
210: where rti.interface_transaction_id = p_transaction_id
211: AND rti.po_header_id = pha.po_header_id(+)

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

235: pll.note_to_receiver note_to_receiver
236: FROM rcv_transactions_interface rti, po_headers_all pha,
237: -- MOAC : changed po_line_locations to po_line_locations_all
238: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,
239: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
240: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
241: po_vendor_sites_all pvs, per_people_f ppf
242: where rti.interface_transaction_id = p_transaction_id
243: AND rti.po_header_id = pha.po_header_id(+)

Line 429: -- , hr_locations_all hrl1

425: , rcv_shipment_lines rsl
426: -- MOAC : changed po_line_locations to po_line_locations_all
427: , po_line_locations_all pll
428: , po_vendors pov
429: -- , hr_locations_all hrl1
430: -- , hr_locations_all hrl2
431: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
432: , po_vendor_sites_all pvs
433: , per_people_f ppf

Line 430: -- , hr_locations_all hrl2

426: -- MOAC : changed po_line_locations to po_line_locations_all
427: , po_line_locations_all pll
428: , po_vendors pov
429: -- , hr_locations_all hrl1
430: -- , hr_locations_all hrl2
431: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
432: , po_vendor_sites_all pvs
433: , per_people_f ppf
434: , wms_license_plate_numbers wlpn -- Bug 3836623

Line 467: from hr_locations_all hrl1

463: Select
464: decode(l_deliver_to_location_id,null,null,hrl1.location_code)
465: deliver_to_location
466: , decode(l_location_id,null,null,hrl2.location_code) location
467: from hr_locations_all hrl1
468: , hr_locations_all hrl2
469: where hrl1.location_id = decode(l_deliver_to_location_id,null,hrl1.location_id,l_deliver_to_location_id)
470: AND hrl2.location_id = decode(l_location_id,null,hrl2.location_id,l_location_id)
471: and hrl1.location_id = hrl2.location_id;

Line 468: , hr_locations_all hrl2

464: decode(l_deliver_to_location_id,null,null,hrl1.location_code)
465: deliver_to_location
466: , decode(l_location_id,null,null,hrl2.location_code) location
467: from hr_locations_all hrl1
468: , hr_locations_all hrl2
469: where hrl1.location_id = decode(l_deliver_to_location_id,null,hrl1.location_id,l_deliver_to_location_id)
470: AND hrl2.location_id = decode(l_location_id,null,hrl2.location_id,l_location_id)
471: and hrl1.location_id = hrl2.location_id;
472:

Line 680: , hr_locations_all hrl1

676: , rcv_shipment_headers rsh
677: -- MOAC : changed po_line_locations to po_line_locations_all
678: , po_line_locations_all pll
679: , po_vendors pov
680: , hr_locations_all hrl1
681: , hr_locations_all hrl2
682: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
683: , po_vendor_sites_all pvs
684: , per_people_f ppf

Line 681: , hr_locations_all hrl2

677: -- MOAC : changed po_line_locations to po_line_locations_all
678: , po_line_locations_all pll
679: , po_vendors pov
680: , hr_locations_all hrl1
681: , hr_locations_all hrl2
682: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
683: , po_vendor_sites_all pvs
684: , per_people_f ppf
685: WHERE pha.po_header_id(+) = all_lpn.po_header_id

Line 1264: l_deliver_to_location hr_locations_all.LOCATION_CODE%TYPE;

1260: -- Increased this variable size to the corresponding column size in the table.
1261: l_supplier_name po_vendors.VENDOR_NAME%TYPE;
1262: l_supplier_site po_vendor_sites.VENDOR_SITE_CODE%TYPE;
1263: l_requestor per_people_f.FULL_NAME%TYPE;
1264: l_deliver_to_location hr_locations_all.LOCATION_CODE%TYPE;
1265: l_location_code hr_locations_all.LOCATION_CODE%TYPE;
1266: l_note_to_receiver po_line_locations.NOTE_TO_RECEIVER%TYPE;
1267:
1268: -- END of Bug fix for 3916663

Line 1265: l_location_code hr_locations_all.LOCATION_CODE%TYPE;

1261: l_supplier_name po_vendors.VENDOR_NAME%TYPE;
1262: l_supplier_site po_vendor_sites.VENDOR_SITE_CODE%TYPE;
1263: l_requestor per_people_f.FULL_NAME%TYPE;
1264: l_deliver_to_location hr_locations_all.LOCATION_CODE%TYPE;
1265: l_location_code hr_locations_all.LOCATION_CODE%TYPE;
1266: l_note_to_receiver po_line_locations.NOTE_TO_RECEIVER%TYPE;
1267:
1268: -- END of Bug fix for 3916663
1269: