DBA Data[Home] [Help]

APPS.PO_RETROACTIVE_PRICING_PVT dependencies on PO_DOCUMENT_TYPES_ALL_B

Line 341: po_headers_archive_all poha, po_document_types_all_b pdt,

337: poh.po_header_id,
338: poh.authorization_status, poh.revision_num,
339: poha.revision_num
340: from po_headers_all poh, po_lines_all pol, po_line_locations_all poll,
341: po_headers_archive_all poha, po_document_types_all_b pdt,
342: financials_system_params_all fsp
343: where pol.from_line_id = l_po_line_id
344: and poh.po_header_id = pol.po_header_id
345: and poh.org_id = fsp.org_id -- -- Bug 3573266

Line 474: po_document_types_all_b pdt,

470: FROM po_headers_all poh,
471: po_lines_all pol,
472: po_line_locations_all poll,
473: po_headers_archive_all poha,
474: po_document_types_all_b pdt,
475: financials_system_params_all fsp
476: WHERE pol.Contract_id = l_po_header_id
477: AND pol.from_header_id IS NULL
478: AND poh.po_header_id = pol.po_header_id