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 PO_VENDOR_SITES

Line 142: -- MOAC : po_vendor_sites changed to po_vendor_sites_all

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(+)
146: AND rsh.shipment_header_id(+) = rti.shipment_header_id

Line 143: po_vendor_sites_all pvs, per_people_f ppf

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(+)
146: AND rsh.shipment_header_id(+) = rti.shipment_header_id
147: AND pol.po_line_id (+) = rti.po_line_id

Line 174: -- MOAC : po_vendor_sites changed to po_vendor_sites_all

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(+)
178: AND rsh.shipment_header_id(+) = rti.shipment_header_id

Line 175: po_vendor_sites_all pvs, per_people_f ppf

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(+)
178: AND rsh.shipment_header_id(+) = rti.shipment_header_id
179: AND pol.po_line_id (+) = rti.po_line_id

Line 394: -- MOAC : po_vendor_sites changed to po_vendor_sites_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
398: WHERE pha.po_header_id(+) = all_lpn.po_header_id

Line 395: , po_vendor_sites_all pvs

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
398: WHERE pha.po_header_id(+) = all_lpn.po_header_id
399: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id

Line 1202: -- MOAC : po_vendor_sites changed to po_vendor_sites_all

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
1206: WHERE pha.po_header_id(+) = all_lpn.po_header_id

Line 1204: po_vendor_sites_all pvs ,

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
1206: WHERE pha.po_header_id(+) = all_lpn.po_header_id
1207: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id
1208: AND pol.po_line_id (+) = all_lpn.po_line_id

Line 1443: l_supplier_site po_vendor_sites.VENDOR_SITE_CODE%TYPE;

1439: --l_note_to_receiver VARCHAR2(240);
1440:
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;