APPS.PO_RETROACTIVE_PRICING_PVT dependencies on PO_DOCUMENT_TYPES

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 499: po_document_types_all_b pdt,

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
503: AND poh.po_header_id = pol.po_header_id

Line 619: l_archive_mode_rel PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE;

615: l_temp_row_id_table char30_table;
616: l_module VARCHAR2(100);
617: l_retroactive_update VARCHAR2(30) := 'NEVER';
618: l_tax_failure exception;
619: l_archive_mode_rel PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE;
620: l_current_org_id NUMBER;
621: l_error_message VARCHAR2(2000);
622:
623: --Bug 4176111: Variable to show if Adv Pricing API is enabled for PO