DBA Data[Home] [Help]

APPS.INV_LABEL_PVT5 dependencies on PO_VENDORS

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

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
214: AND rti.po_header_id = pha.po_header_id(+)

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

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
246: AND rti.po_header_id = pha.po_header_id(+)

Line 431: , po_vendors pov

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
435: , po_vendor_sites_all pvs

Line 708: , po_vendors pov

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
712: , po_vendor_sites_all pvs

Line 1409: l_supplier_name po_vendors.VENDOR_NAME%TYPE;

1405: --l_location_code VARCHAR2(20);
1406: --l_note_to_receiver VARCHAR2(240);
1407:
1408: -- Increased this variable size to the corresponding column size in the table.
1409: l_supplier_name po_vendors.VENDOR_NAME%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;