APPS.POA_SUPPLIER_CONSOLIDATION_PK dependencies on PO_HEADERS_ALL

Line 134: FROM po_headers_all phc2,

130: p_currency_code,
131: NVL(phc2.rate_date, phc2.creation_date),
132: NVL(phc2.rate_type, 'Corporate')),
133: 1) blanket_price
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,

Line 135: po_headers_all phc1,

131: NVL(phc2.rate_date, phc2.creation_date),
132: NVL(phc2.rate_type, 'Corporate')),
133: 1) blanket_price
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

Line 176: FROM po_headers_all phc2,

172: p_currency_code,
173: NVL(phc2.rate_date, phc2.creation_date),
174: NVL(phc2.rate_type, 'Corporate')),
175: 1) blanket_price
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,

Line 177: po_headers_all phc1,

173: NVL(phc2.rate_date, phc2.creation_date),
174: NVL(phc2.rate_type, 'Corporate')),
175: 1) blanket_price
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

Line 226: FROM po_headers_all phc2,

222: p_currency_code,
223: NVL(phc2.rate_date, phc2.creation_date),
224: NVL(phc2.rate_type, 'Corporate')),
225: 1) blanket_price
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

Line 227: po_headers_all phc1,

223: NVL(phc2.rate_date, phc2.creation_date),
224: NVL(phc2.rate_type, 'Corporate')),
225: 1) blanket_price
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

Line 261: FROM po_headers_all phc2,

257: p_currency_code,
258: NVL(phc2.rate_date, phc2.creation_date),
259: NVL(phc2.rate_type, 'Corporate')),
260: 1) blanket_price
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

Line 262: po_headers_all phc1,

258: NVL(phc2.rate_date, phc2.creation_date),
259: NVL(phc2.rate_type, 'Corporate')),
260: 1) blanket_price
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