VIEW: APPS.PO_EXHIBITS_DRAFT_DIFF_V

Source

View Text - Preformatted

SELECT po_header_id pk1_value, draft_id pk2_value, po_exhibit_details_id pk3_value, null pk4_value, null pk5_value, col_name , col_value, revision_num from ( SELECT pedd.po_header_id, pedd.draft_id draft_id, pedd.po_exhibit_details_id, pedd.exhibit_description, To_Char(pedd.reference_line_id) REFERENCE_LINE_ID, To_Char(pedd.revision_num) REVISION_NUM FROM po_exhibit_details_draft pedd WHERE pedd.change_status = 'UPDATE' AND pedd.po_header_id = PO_GEN_DIFF_PKG.getModPK1 AND pedd.draft_id = PO_GEN_DIFF_PKG.getModPK2) po_exhibit_unpivot_data unpivot include nulls ( col_value for col_name in ( EXHIBIT_DESCRIPTION, REFERENCE_LINE_ID ) )

View Text - HTML Formatted

SELECT PO_HEADER_ID PK1_VALUE
, DRAFT_ID PK2_VALUE
, PO_EXHIBIT_DETAILS_ID PK3_VALUE
, NULL PK4_VALUE
, NULL PK5_VALUE
, COL_NAME
, COL_VALUE
, REVISION_NUM
FROM ( SELECT PEDD.PO_HEADER_ID
, PEDD.DRAFT_ID DRAFT_ID
, PEDD.PO_EXHIBIT_DETAILS_ID
, PEDD.EXHIBIT_DESCRIPTION
, TO_CHAR(PEDD.REFERENCE_LINE_ID) REFERENCE_LINE_ID
, TO_CHAR(PEDD.REVISION_NUM) REVISION_NUM
FROM PO_EXHIBIT_DETAILS_DRAFT PEDD
WHERE PEDD.CHANGE_STATUS = 'UPDATE'
AND PEDD.PO_HEADER_ID = PO_GEN_DIFF_PKG.GETMODPK1
AND PEDD.DRAFT_ID = PO_GEN_DIFF_PKG.GETMODPK2) PO_EXHIBIT_UNPIVOT_DATA UNPIVOT INCLUDE NULLS ( COL_VALUE FOR COL_NAME IN ( EXHIBIT_DESCRIPTION
, REFERENCE_LINE_ID ) )