DBA Data[Home] [Help]

APPS.INV_LABEL_PVT4 dependencies on PO_LINE_LOCATIONS

Line 139: -- MOAC : po_line_locations changed to po_line_locations_all

135: pvs.vendor_site_code supplier_site, ppf.full_name requestor,
136: hrl1.location_code deliver_to_location,
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

Line 140: po_lines_trx_v pol, rcv_shipment_headers rsh, po_line_locations_trx_v pll,

136: hrl1.location_code deliver_to_location,
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

Line 171: -- MOAC : po_line_locations changed to po_line_locations_all

167: pvs.vendor_site_code supplier_site, ppf.full_name requestor,
168: hrl1.location_code deliver_to_location,
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

Line 172: po_lines_trx_v pol, rcv_shipment_headers rsh, po_line_locations_trx_v pll,

168: hrl1.location_code deliver_to_location,
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

Line 389: -- MOAC : po_line_locations changed to po_line_locations_all

385: , po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables
386: , po_lines_trx_v pol
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

Line 390: , po_line_locations_trx_v pll

386: , po_lines_trx_v pol
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

Line 1196: -- MOAC : po_line_locations changed to po_line_locations_all

1192: po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables
1193: ,
1194: po_lines_trx_v pol ,
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 ,

Line 1198: po_line_locations_trx_v pll ,

1194: po_lines_trx_v pol ,
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

Line 1447: l_note_to_receiver po_line_locations.NOTE_TO_RECEIVER%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:
1451: l_label_index NUMBER;