VIEW: APPS.PO_EXHIBIT_DETAILS_MERGE_V

Source

View Text - Preformatted

SELECT ped.po_exhibit_details_id, ped.exhibit_name, ped.exhibit_description, ped.is_cdrl, ped.po_header_id, ped.draft_id, ped.reference_line_id, ped.change_status, ped.change_accepted_flag, ped.delete_flag, ped.last_update_date, ped.last_updated_by, ped.creation_date, ped.created_by, ped.last_update_login FROM PO_DRAFTS DFT,PO_EXHIBIT_DETAILS_DRAFT PED WHERE ped.draft_id = dft.draft_id and nvl(ped.delete_flag,'N') = 'N' union all select pe.po_exhibit_details_id, pe.exhibit_name, pe.exhibit_description, pe.is_cdrl, pe.po_header_id, to_number(-1), pe.reference_line_id, null , null, null, pe.last_update_date, pe.last_updated_by, pe.creation_date, pe.created_by, pe.last_update_login from po_exhibit_details pe union all select pe.po_exhibit_details_id, pe.exhibit_name, pe.exhibit_description, pe.is_cdrl, pe.po_header_id, dft.draft_id, pe.reference_line_id, null , null, null, pe.last_update_date, pe.last_updated_by, pe.creation_date, pe.created_by, pe.last_update_login from po_exhibit_details pe, po_drafts dft where pe.po_header_id = dft.document_id and not exists (select 'draft exists for this line' from po_exhibit_details_draft pld where pe.po_exhibit_details_id = pld.po_exhibit_details_id and pld.draft_id = dft.draft_id and nvl(pld.delete_flag,'N') = 'N' )

View Text - HTML Formatted

SELECT PED.PO_EXHIBIT_DETAILS_ID
, PED.EXHIBIT_NAME
, PED.EXHIBIT_DESCRIPTION
, PED.IS_CDRL
, PED.PO_HEADER_ID
, PED.DRAFT_ID
, PED.REFERENCE_LINE_ID
, PED.CHANGE_STATUS
, PED.CHANGE_ACCEPTED_FLAG
, PED.DELETE_FLAG
, PED.LAST_UPDATE_DATE
, PED.LAST_UPDATED_BY
, PED.CREATION_DATE
, PED.CREATED_BY
, PED.LAST_UPDATE_LOGIN
FROM PO_DRAFTS DFT
, PO_EXHIBIT_DETAILS_DRAFT PED
WHERE PED.DRAFT_ID = DFT.DRAFT_ID
AND NVL(PED.DELETE_FLAG
, 'N') = 'N' UNION ALL SELECT PE.PO_EXHIBIT_DETAILS_ID
, PE.EXHIBIT_NAME
, PE.EXHIBIT_DESCRIPTION
, PE.IS_CDRL
, PE.PO_HEADER_ID
, TO_NUMBER(-1)
, PE.REFERENCE_LINE_ID
, NULL
, NULL
, NULL
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATED_BY
, PE.CREATION_DATE
, PE.CREATED_BY
, PE.LAST_UPDATE_LOGIN
FROM PO_EXHIBIT_DETAILS PE UNION ALL SELECT PE.PO_EXHIBIT_DETAILS_ID
, PE.EXHIBIT_NAME
, PE.EXHIBIT_DESCRIPTION
, PE.IS_CDRL
, PE.PO_HEADER_ID
, DFT.DRAFT_ID
, PE.REFERENCE_LINE_ID
, NULL
, NULL
, NULL
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATED_BY
, PE.CREATION_DATE
, PE.CREATED_BY
, PE.LAST_UPDATE_LOGIN
FROM PO_EXHIBIT_DETAILS PE
, PO_DRAFTS DFT
WHERE PE.PO_HEADER_ID = DFT.DOCUMENT_ID
AND NOT EXISTS (SELECT 'DRAFT EXISTS FOR THIS LINE'
FROM PO_EXHIBIT_DETAILS_DRAFT PLD
WHERE PE.PO_EXHIBIT_DETAILS_ID = PLD.PO_EXHIBIT_DETAILS_ID
AND PLD.DRAFT_ID = DFT.DRAFT_ID
AND NVL(PLD.DELETE_FLAG
, 'N') = 'N' )