DBA Data[Home] [Help]

APPS.POA_SUPPLIER_CONSOLIDATION_PK dependencies on PO_LINE_LOCATIONS_ALL

Line 138: po_line_locations_all psc2,

134: FROM po_headers_all phc2,
135: po_headers_all phc1,
136: po_lines_all plc2,
137: po_lines_all plc1,
138: po_line_locations_all psc2,
139: po_line_locations_all psc1
140: WHERE psc1.line_location_id = v_cons_shipment_id
141: AND plc1.po_line_id = psc1.po_line_id
142: AND plc1.po_header_id = psc1.po_header_id

Line 139: po_line_locations_all psc1

135: po_headers_all phc1,
136: po_lines_all plc2,
137: po_lines_all plc1,
138: po_line_locations_all psc2,
139: po_line_locations_all psc1
140: WHERE psc1.line_location_id = v_cons_shipment_id
141: AND plc1.po_line_id = psc1.po_line_id
142: AND plc1.po_header_id = psc1.po_header_id
143: AND phc1.po_header_id = psc1.po_header_id

Line 180: po_line_locations_all psc2,

176: FROM po_headers_all phc2,
177: po_headers_all phc1,
178: po_lines_all plc2,
179: po_lines_all plc1,
180: po_line_locations_all psc2,
181: po_line_locations_all psc1
182: WHERE psc1.line_location_id = v_cons_shipment_id
183: AND plc1.po_line_id = psc1.po_line_id
184: AND plc1.po_header_id = psc1.po_header_id

Line 181: po_line_locations_all psc1

177: po_headers_all phc1,
178: po_lines_all plc2,
179: po_lines_all plc1,
180: po_line_locations_all psc2,
181: po_line_locations_all psc1
182: WHERE psc1.line_location_id = v_cons_shipment_id
183: AND plc1.po_line_id = psc1.po_line_id
184: AND plc1.po_header_id = psc1.po_header_id
185: AND phc1.po_header_id = psc1.po_header_id

Line 230: po_line_locations_all psc1

226: FROM po_headers_all phc2,
227: po_headers_all phc1,
228: po_lines_all plc2,
229: po_lines_all plc1,
230: po_line_locations_all psc1
231: WHERE psc1.line_location_id = v_cons_shipment_id
232: AND plc1.po_line_id = psc1.po_line_id
233: AND plc1.po_header_id = psc1.po_header_id
234: AND phc1.po_header_id = psc1.po_header_id

Line 265: po_line_locations_all psc1

261: FROM po_headers_all phc2,
262: po_headers_all phc1,
263: po_lines_all plc2,
264: po_lines_all plc1,
265: po_line_locations_all psc1
266: WHERE psc1.line_location_id = v_cons_shipment_id
267: AND plc1.po_line_id = psc1.po_line_id
268: AND plc1.po_header_id = psc1.po_header_id
269: AND phc1.po_header_id = psc1.po_header_id