APPS.PO_RETROACTIVE_PRICING_PVT dependencies on PO_HEADERS_ARCHIVE_ALL

Line 251: po_headers_archive_all poha,financials_system_params_all fsp

247: poh.po_header_id,
248: poh.authorization_status, poh.revision_num,
249: poha.revision_num
250: from po_headers_all poh, po_lines_all pol, po_line_locations_all poll,
251: po_headers_archive_all poha,financials_system_params_all fsp
252: where pol.from_line_id = l_po_line_id
253: and poh.po_header_id = pol.po_header_id
254: and poh.org_id = fsp.org_id -- -- Bug 3573266
255: and nvl(fsp.purch_encumbrance_flag,'N') = 'N' -- Bug 3573266

Line 360: po_headers_archive_all poha, po_document_types_all_b pdt,

356: poh.po_header_id,
357: poh.authorization_status, poh.revision_num,
358: poha.revision_num
359: from po_headers_all poh, po_lines_all pol, po_line_locations_all poll,
360: po_headers_archive_all poha, po_document_types_all_b pdt,
361: financials_system_params_all fsp
362: where pol.from_line_id = l_po_line_id
363: and poh.po_header_id = pol.po_header_id
364: and poh.org_id = fsp.org_id -- -- Bug 3573266

Line 434: po_headers_archive_all poha,

430: poha.revision_num
431: FROM po_headers_all poh,
432: po_lines_all pol,
433: po_line_locations_all poll,
434: po_headers_archive_all poha,
435: financials_system_params_all fsp
436: WHERE pol.Contract_id = l_po_header_id
437: AND pol.from_header_id IS NULL
438: AND poh.po_header_id = pol.po_header_id

Line 498: po_headers_archive_all poha,

494: poha.revision_num
495: FROM po_headers_all poh,
496: po_lines_all pol,
497: po_line_locations_all poll,
498: po_headers_archive_all poha,
499: po_document_types_all_b pdt,
500: financials_system_params_all fsp
501: WHERE pol.Contract_id = l_po_header_id
502: AND pol.from_header_id IS NULL