DBA Data[Home] [Help]

APPS.INV_LABEL_PVT4 dependencies on PO_VENDORS

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 391: , po_vendors pov

387: , rcv_shipment_headers rsh
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

Line 1199: po_vendors pov ,

1195: rcv_shipment_headers rsh
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: ,

Line 1442: l_supplier_name po_vendors.VENDOR_NAME%TYPE;

1438: --l_location_code VARCHAR2(20);
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;