DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_EXHIBIT_DETAILS_MERGE_V

Line 25643: po_exhibit_details_merge_v poe,

25639: po_core_s.Get_translated_text('PO_CLM_EXHIBIT_ORPHAN', 'EXHIBIT_NAME', poe.exhibit_name),
25640: 'PO_CLM_EXHIBIT_ORPHAN',
25641: 'E'
25642: FROM
25643: po_exhibit_details_merge_v poe,
25644: po_headers_gt poh
25645: WHERE poh.po_header_id = p_document_id
25646: AND poh.po_header_id = poe.po_header_id
25647: AND poh.draft_id = poe.draft_id

Line 25686: po_exhibit_details_merge_v poed,

25682: po_core_s.Get_translated_text('PO_CLM_EXHIBIT_INVALID_REF', 'EXHIBIT_NAME', poed.exhibit_name),
25683: 'PO_CLM_EXHIBIT_INVALID_REF',
25684: 'E'
25685: FROM po_lines_gt pol,
25686: po_exhibit_details_merge_v poed,
25687: (SELECT exhibit_name,
25688: (SELECT Decode( Count(1), 0, fnd_message.get_string('PO','PO_EXHIBIT_NSP_LABEL'), fnd_message.get_string('PO','PO_EXHIBIT_PRICED_LABEL'))
25689: FROM po_lines_gt pl
25690: WHERE

Line 25695: FROM po_exhibit_details_merge_v ped WHERE ped.po_header_id = p_document_id AND ped.draft_id = p_draft_id) exhibit_pricing_cur

25691: pl.po_header_id = ped.PO_HEADER_ID AND
25692: pl.clm_exhibit_name = ped.EXHIBIT_NAME AND
25693: Nvl(pl.cost_constraint,'Priced') NOT IN ('NSP','NC')
25694: ) pricing
25695: FROM po_exhibit_details_merge_v ped WHERE ped.po_header_id = p_document_id AND ped.draft_id = p_draft_id) exhibit_pricing_cur
25696: WHERE pol.po_header_id = p_document_id
25697: AND pol.po_header_id = poed.po_header_id
25698: AND poed.draft_id = p_draft_id
25699: AND exhibit_pricing_cur.exhibit_name = poed.exhibit_name