VRM_XLA_REVENUE_LINES_V

Details

• Schema: FUSION

• Object owner: VRM

• Object type: VIEW

Columns

Name

PERF_OBLIGATION_LINE_DIST_ID H_SRC_ATTRIBUTE_CATEGORY H_SRC_ATTRIBUTE_CHAR1 H_SRC_ATTRIBUTE_CHAR10 H_SRC_ATTRIBUTE_CHAR11 H_SRC_ATTRIBUTE_CHAR12 H_SRC_ATTRIBUTE_CHAR13 H_SRC_ATTRIBUTE_CHAR14 H_SRC_ATTRIBUTE_CHAR15 H_SRC_ATTRIBUTE_CHAR16 H_SRC_ATTRIBUTE_CHAR17 H_SRC_ATTRIBUTE_CHAR18 H_SRC_ATTRIBUTE_CHAR19 H_SRC_ATTRIBUTE_CHAR2 H_SRC_ATTRIBUTE_CHAR20 H_SRC_ATTRIBUTE_CHAR21 H_SRC_ATTRIBUTE_CHAR22 H_SRC_ATTRIBUTE_CHAR23 H_SRC_ATTRIBUTE_CHAR24 H_SRC_ATTRIBUTE_CHAR25 H_SRC_ATTRIBUTE_CHAR26 H_SRC_ATTRIBUTE_CHAR27 H_SRC_ATTRIBUTE_CHAR28 H_SRC_ATTRIBUTE_CHAR29 H_SRC_ATTRIBUTE_CHAR3 H_SRC_ATTRIBUTE_CHAR30 H_SRC_ATTRIBUTE_CHAR31 H_SRC_ATTRIBUTE_CHAR32 H_SRC_ATTRIBUTE_CHAR33 H_SRC_ATTRIBUTE_CHAR34 H_SRC_ATTRIBUTE_CHAR35 H_SRC_ATTRIBUTE_CHAR36 H_SRC_ATTRIBUTE_CHAR37 H_SRC_ATTRIBUTE_CHAR38 H_SRC_ATTRIBUTE_CHAR39 H_SRC_ATTRIBUTE_CHAR4 H_SRC_ATTRIBUTE_CHAR40 H_SRC_ATTRIBUTE_CHAR41 H_SRC_ATTRIBUTE_CHAR42 H_SRC_ATTRIBUTE_CHAR43 H_SRC_ATTRIBUTE_CHAR44 H_SRC_ATTRIBUTE_CHAR45 H_SRC_ATTRIBUTE_CHAR46 H_SRC_ATTRIBUTE_CHAR47 H_SRC_ATTRIBUTE_CHAR48 H_SRC_ATTRIBUTE_CHAR49 H_SRC_ATTRIBUTE_CHAR5 H_SRC_ATTRIBUTE_CHAR50 H_SRC_ATTRIBUTE_CHAR51 H_SRC_ATTRIBUTE_CHAR52 H_SRC_ATTRIBUTE_CHAR53 H_SRC_ATTRIBUTE_CHAR54 H_SRC_ATTRIBUTE_CHAR55 H_SRC_ATTRIBUTE_CHAR56 H_SRC_ATTRIBUTE_CHAR57 H_SRC_ATTRIBUTE_CHAR58 H_SRC_ATTRIBUTE_CHAR59 H_SRC_ATTRIBUTE_CHAR6 H_SRC_ATTRIBUTE_CHAR60 H_SRC_ATTRIBUTE_CHAR7 H_SRC_ATTRIBUTE_CHAR8 H_SRC_ATTRIBUTE_CHAR9 PERF_OBLIG_ATTRIBUTE_CATEGORY PERF_OBLIG_ATTRIBUTE1 PERF_OBLIG_ATTRIBUTE10 PERF_OBLIG_ATTRIBUTE11 PERF_OBLIG_ATTRIBUTE12 PERF_OBLIG_ATTRIBUTE13 PERF_OBLIG_ATTRIBUTE14 PERF_OBLIG_ATTRIBUTE15 PERF_OBLIG_ATTRIBUTE16 PERF_OBLIG_ATTRIBUTE17 PERF_OBLIG_ATTRIBUTE18 PERF_OBLIG_ATTRIBUTE19 PERF_OBLIG_ATTRIBUTE2 PERF_OBLIG_ATTRIBUTE20 PERF_OBLIG_ATTRIBUTE3 PERF_OBLIG_ATTRIBUTE4 PERF_OBLIG_ATTRIBUTE5 PERF_OBLIG_ATTRIBUTE6 PERF_OBLIG_ATTRIBUTE7 PERF_OBLIG_ATTRIBUTE8 PERF_OBLIG_ATTRIBUTE9 SRC_DOC_HEADER_TYPE DOCUMENT_TYPE_NAME SRC_DOC_CURRENCY_CODE PERFORMANCE_OBLIGATION_NUMBER REVISION_INTENT_OBLIGATION DIST_EXCHANGE_RATE DIST_EXCHANGE_RATE_DATE DIST_EXCHANGE_RATE_TYPE LEGAL_ENTITY_NAME SRC_DOC_DATE SRC_DOC_NUMBER BUSINESS_UNIT_NAME DIST_ACCOUNT_CLASS DIST_ACCOUNTING_DATE DIST_ACCTD_AMOUNT DIST_AMOUNT PERF_OBLIG_LINE_ATTR_CATEGORY PERF_OBLIG_LINE_ATTRIBUTE1 PERF_OBLIG_LINE_ATTRIBUTE10 PERF_OBLIG_LINE_ATTRIBUTE11 PERF_OBLIG_LINE_ATTRIBUTE12 PERF_OBLIG_LINE_ATTRIBUTE13 PERF_OBLIG_LINE_ATTRIBUTE14 PERF_OBLIG_LINE_ATTRIBUTE15 PERF_OBLIG_LINE_ATTRIBUTE16 PERF_OBLIG_LINE_ATTRIBUTE17 PERF_OBLIG_LINE_ATTRIBUTE18 PERF_OBLIG_LINE_ATTRIBUTE19 PERF_OBLIG_LINE_ATTRIBUTE2 PERF_OBLIG_LINE_ATTRIBUTE20 PERF_OBLIG_LINE_ATTRIBUTE3 PERF_OBLIG_LINE_ATTRIBUTE4 PERF_OBLIG_LINE_ATTRIBUTE5 PERF_OBLIG_LINE_ATTRIBUTE6 PERF_OBLIG_LINE_ATTRIBUTE7 PERF_OBLIG_LINE_ATTRIBUTE8 PERF_OBLIG_LINE_ATTRIBUTE9 POL_REVENUE_RULE_NAME SOURCE_DOCUMENT_LINE_NUMBER L_SRC_ATTRIBUTE_CATEGORY L_SRC_ATTRIBUTE_CHAR1 L_SRC_ATTRIBUTE_CHAR10 L_SRC_ATTRIBUTE_CHAR11 L_SRC_ATTRIBUTE_CHAR12 L_SRC_ATTRIBUTE_CHAR13 L_SRC_ATTRIBUTE_CHAR14 L_SRC_ATTRIBUTE_CHAR15 L_SRC_ATTRIBUTE_CHAR16 L_SRC_ATTRIBUTE_CHAR17 L_SRC_ATTRIBUTE_CHAR18 L_SRC_ATTRIBUTE_CHAR19 L_SRC_ATTRIBUTE_CHAR2 L_SRC_ATTRIBUTE_CHAR20 L_SRC_ATTRIBUTE_CHAR21 L_SRC_ATTRIBUTE_CHAR22 L_SRC_ATTRIBUTE_CHAR23 L_SRC_ATTRIBUTE_CHAR24 L_SRC_ATTRIBUTE_CHAR25 L_SRC_ATTRIBUTE_CHAR26 L_SRC_ATTRIBUTE_CHAR27 L_SRC_ATTRIBUTE_CHAR28 L_SRC_ATTRIBUTE_CHAR29 L_SRC_ATTRIBUTE_CHAR3 L_SRC_ATTRIBUTE_CHAR30 L_SRC_ATTRIBUTE_CHAR31 L_SRC_ATTRIBUTE_CHAR32 L_SRC_ATTRIBUTE_CHAR33 L_SRC_ATTRIBUTE_CHAR34 L_SRC_ATTRIBUTE_CHAR35 L_SRC_ATTRIBUTE_CHAR36 L_SRC_ATTRIBUTE_CHAR37 L_SRC_ATTRIBUTE_CHAR38 L_SRC_ATTRIBUTE_CHAR39 L_SRC_ATTRIBUTE_CHAR4 L_SRC_ATTRIBUTE_CHAR40 L_SRC_ATTRIBUTE_CHAR41 L_SRC_ATTRIBUTE_CHAR42 L_SRC_ATTRIBUTE_CHAR43 L_SRC_ATTRIBUTE_CHAR44 L_SRC_ATTRIBUTE_CHAR45 L_SRC_ATTRIBUTE_CHAR46 L_SRC_ATTRIBUTE_CHAR47 L_SRC_ATTRIBUTE_CHAR48 L_SRC_ATTRIBUTE_CHAR49 L_SRC_ATTRIBUTE_CHAR5 L_SRC_ATTRIBUTE_CHAR50 L_SRC_ATTRIBUTE_CHAR51 L_SRC_ATTRIBUTE_CHAR52 L_SRC_ATTRIBUTE_CHAR53 L_SRC_ATTRIBUTE_CHAR54 L_SRC_ATTRIBUTE_CHAR55 L_SRC_ATTRIBUTE_CHAR56 L_SRC_ATTRIBUTE_CHAR57 L_SRC_ATTRIBUTE_CHAR58 L_SRC_ATTRIBUTE_CHAR59 L_SRC_ATTRIBUTE_CHAR6 L_SRC_ATTRIBUTE_CHAR60 L_SRC_ATTRIBUTE_CHAR7 L_SRC_ATTRIBUTE_CHAR8 L_SRC_ATTRIBUTE_CHAR9 PERF_OBLIG_LINE_NUMBER REVISION_INTENT_OBLIG_LINE PERFORMANCE_OBLIGATION_TYPE SRC_DOC_LINE_TYPE EVENT_ID LEDGER_ID LINE_NUMBER CONTRACT_REVENUE_CLEARING_CCID REVENUE_SPLIT_REV_CCID TRANSFER_TO_GL DEVOLVE_PO_FLAG OBLIGATION_REFERENCE PERF_OBLIG_CLASSIFICATION_CODE AS PO_RESIDUAL_APPROACH_FLAG AS POL_RESIDUAL_APPROACH_FLAG FOREIGN_CURR_TREATMENT_CODE PO_MEMO_LINE_NAME PO_CUST_PO_NUMBER PO_DOCUMENT_LINE_ID PO_ELEMENT_TYPE PO_ITEM_NUMBER PO_SRC_ATTRIBUTE_CHAR1 PO_SRC_ATTRIBUTE_CHAR10 PO_SRC_ATTRIBUTE_CHAR11 PO_SRC_ATTRIBUTE_CHAR12 PO_SRC_ATTRIBUTE_CHAR13 PO_SRC_ATTRIBUTE_CHAR14 PO_SRC_ATTRIBUTE_CHAR15 PO_SRC_ATTRIBUTE_CHAR16 PO_SRC_ATTRIBUTE_CHAR17 PO_SRC_ATTRIBUTE_CHAR18 PO_SRC_ATTRIBUTE_CHAR19 PO_SRC_ATTRIBUTE_CHAR2 PO_SRC_ATTRIBUTE_CHAR20 PO_SRC_ATTRIBUTE_CHAR21 PO_SRC_ATTRIBUTE_CHAR22 PO_SRC_ATTRIBUTE_CHAR23 PO_SRC_ATTRIBUTE_CHAR24 PO_SRC_ATTRIBUTE_CHAR25 PO_SRC_ATTRIBUTE_CHAR26 PO_SRC_ATTRIBUTE_CHAR27 PO_SRC_ATTRIBUTE_CHAR28 PO_SRC_ATTRIBUTE_CHAR29 PO_SRC_ATTRIBUTE_CHAR3 PO_SRC_ATTRIBUTE_CHAR30 PO_SRC_ATTRIBUTE_CHAR31 PO_SRC_ATTRIBUTE_CHAR32 PO_SRC_ATTRIBUTE_CHAR33 PO_SRC_ATTRIBUTE_CHAR34 PO_SRC_ATTRIBUTE_CHAR35 PO_SRC_ATTRIBUTE_CHAR36 PO_SRC_ATTRIBUTE_CHAR37 PO_SRC_ATTRIBUTE_CHAR38 PO_SRC_ATTRIBUTE_CHAR39 PO_SRC_ATTRIBUTE_CHAR4 PO_SRC_ATTRIBUTE_CHAR40 PO_SRC_ATTRIBUTE_CHAR41 PO_SRC_ATTRIBUTE_CHAR42 PO_SRC_ATTRIBUTE_CHAR43 PO_SRC_ATTRIBUTE_CHAR44 PO_SRC_ATTRIBUTE_CHAR45 PO_SRC_ATTRIBUTE_CHAR46 PO_SRC_ATTRIBUTE_CHAR47 PO_SRC_ATTRIBUTE_CHAR48 PO_SRC_ATTRIBUTE_CHAR49 PO_SRC_ATTRIBUTE_CHAR5 PO_SRC_ATTRIBUTE_CHAR50 PO_SRC_ATTRIBUTE_CHAR51 PO_SRC_ATTRIBUTE_CHAR52 PO_SRC_ATTRIBUTE_CHAR53 PO_SRC_ATTRIBUTE_CHAR54 PO_SRC_ATTRIBUTE_CHAR55 PO_SRC_ATTRIBUTE_CHAR56 PO_SRC_ATTRIBUTE_CHAR57 PO_SRC_ATTRIBUTE_CHAR58 PO_SRC_ATTRIBUTE_CHAR59 PO_SRC_ATTRIBUTE_CHAR6 PO_SRC_ATTRIBUTE_CHAR60 PO_SRC_ATTRIBUTE_CHAR7 PO_SRC_ATTRIBUTE_CHAR8 PO_SRC_ATTRIBUTE_CHAR9 PO_SRC_ATTRIBUTE_NUMBER1 PO_SRC_ATTRIBUTE_NUMBER10 PO_SRC_ATTRIBUTE_NUMBER11 PO_SRC_ATTRIBUTE_NUMBER12 PO_SRC_ATTRIBUTE_NUMBER13 PO_SRC_ATTRIBUTE_NUMBER14 PO_SRC_ATTRIBUTE_NUMBER15 PO_SRC_ATTRIBUTE_NUMBER16 PO_SRC_ATTRIBUTE_NUMBER17 PO_SRC_ATTRIBUTE_NUMBER18 PO_SRC_ATTRIBUTE_NUMBER19 PO_SRC_ATTRIBUTE_NUMBER2 PO_SRC_ATTRIBUTE_NUMBER20 PO_SRC_ATTRIBUTE_NUMBER3 PO_SRC_ATTRIBUTE_NUMBER4 PO_SRC_ATTRIBUTE_NUMBER5 PO_SRC_ATTRIBUTE_NUMBER6 PO_SRC_ATTRIBUTE_NUMBER7 PO_SRC_ATTRIBUTE_NUMBER8 PO_SRC_ATTRIBUTE_NUMBER9 POL_LINE_SATISFACTION_DATE POL_FIRST_SATIS_EVENT_DATE

Query

SQL_Statement

SELECT /*+ cardinality(l 2) LEADING(l) INDEX(l VRM_XLA_IFRS15_EXTRACT_GT_N1) INDEX(dists VRM_PERF_OBLIG_LIN_DIST_U1) INDEX(vpol VRM_PERF_OBLIG_LINES_U1) INDEX(vpo VRM_PERF_OBLIGATIONS_U1) INDEX(vsdl VRM_SOURCE_DOC_LINES_U1) INDEX(vsd VRM_SOURCE_DOCUMENTS_U1) INDEX(vcch VRM_CUST_CONTRACT_HDRS_U1) */ l.PERF_OBLIGATION_LINE_DIST_ID PERF_OBLIGATION_LINE_DIST_ID , vsd.SRC_ATTRIBUTE_CATEGORY H_SRC_ATTRIBUTE_CATEGORY , vsd.SRC_ATTRIBUTE_CHAR1 H_SRC_ATTRIBUTE_CHAR1 , vsd.SRC_ATTRIBUTE_CHAR10 H_SRC_ATTRIBUTE_CHAR10 , vsd.SRC_ATTRIBUTE_CHAR11 H_SRC_ATTRIBUTE_CHAR11 , vsd.SRC_ATTRIBUTE_CHAR12 H_SRC_ATTRIBUTE_CHAR12 , vsd.SRC_ATTRIBUTE_CHAR13 H_SRC_ATTRIBUTE_CHAR13 , vsd.SRC_ATTRIBUTE_CHAR14 H_SRC_ATTRIBUTE_CHAR14 , vsd.SRC_ATTRIBUTE_CHAR15 H_SRC_ATTRIBUTE_CHAR15 , vsd.SRC_ATTRIBUTE_CHAR16 H_SRC_ATTRIBUTE_CHAR16 , vsd.SRC_ATTRIBUTE_CHAR17 H_SRC_ATTRIBUTE_CHAR17 , vsd.SRC_ATTRIBUTE_CHAR18 H_SRC_ATTRIBUTE_CHAR18 , vsd.SRC_ATTRIBUTE_CHAR19 H_SRC_ATTRIBUTE_CHAR19 , vsd.SRC_ATTRIBUTE_CHAR2 H_SRC_ATTRIBUTE_CHAR2 , vsd.SRC_ATTRIBUTE_CHAR20 H_SRC_ATTRIBUTE_CHAR20 , vsd.SRC_ATTRIBUTE_CHAR21 H_SRC_ATTRIBUTE_CHAR21 , vsd.SRC_ATTRIBUTE_CHAR22 H_SRC_ATTRIBUTE_CHAR22 , vsd.SRC_ATTRIBUTE_CHAR23 H_SRC_ATTRIBUTE_CHAR23 , vsd.SRC_ATTRIBUTE_CHAR24 H_SRC_ATTRIBUTE_CHAR24 , vsd.SRC_ATTRIBUTE_CHAR25 H_SRC_ATTRIBUTE_CHAR25 , vsd.SRC_ATTRIBUTE_CHAR26 H_SRC_ATTRIBUTE_CHAR26 , vsd.SRC_ATTRIBUTE_CHAR27 H_SRC_ATTRIBUTE_CHAR27 , vsd.SRC_ATTRIBUTE_CHAR28 H_SRC_ATTRIBUTE_CHAR28 , vsd.SRC_ATTRIBUTE_CHAR29 H_SRC_ATTRIBUTE_CHAR29 , vsd.SRC_ATTRIBUTE_CHAR3 H_SRC_ATTRIBUTE_CHAR3 , vsd.SRC_ATTRIBUTE_CHAR30 H_SRC_ATTRIBUTE_CHAR30 , vsd.SRC_ATTRIBUTE_CHAR31 H_SRC_ATTRIBUTE_CHAR31 , vsd.SRC_ATTRIBUTE_CHAR32 H_SRC_ATTRIBUTE_CHAR32 , vsd.SRC_ATTRIBUTE_CHAR33 H_SRC_ATTRIBUTE_CHAR33 , vsd.SRC_ATTRIBUTE_CHAR34 H_SRC_ATTRIBUTE_CHAR34 , vsd.SRC_ATTRIBUTE_CHAR35 H_SRC_ATTRIBUTE_CHAR35 , vsd.SRC_ATTRIBUTE_CHAR36 H_SRC_ATTRIBUTE_CHAR36 , vsd.SRC_ATTRIBUTE_CHAR37 H_SRC_ATTRIBUTE_CHAR37 , vsd.SRC_ATTRIBUTE_CHAR38 H_SRC_ATTRIBUTE_CHAR38 , vsd.SRC_ATTRIBUTE_CHAR39 H_SRC_ATTRIBUTE_CHAR39 , vsd.SRC_ATTRIBUTE_CHAR4 H_SRC_ATTRIBUTE_CHAR4 , vsd.SRC_ATTRIBUTE_CHAR40 H_SRC_ATTRIBUTE_CHAR40 , vsd.SRC_ATTRIBUTE_CHAR41 H_SRC_ATTRIBUTE_CHAR41 , vsd.SRC_ATTRIBUTE_CHAR42 H_SRC_ATTRIBUTE_CHAR42 , vsd.SRC_ATTRIBUTE_CHAR43 H_SRC_ATTRIBUTE_CHAR43 , vsd.SRC_ATTRIBUTE_CHAR44 H_SRC_ATTRIBUTE_CHAR44 , vsd.SRC_ATTRIBUTE_CHAR45 H_SRC_ATTRIBUTE_CHAR45 , vsd.SRC_ATTRIBUTE_CHAR46 H_SRC_ATTRIBUTE_CHAR46 , vsd.SRC_ATTRIBUTE_CHAR47 H_SRC_ATTRIBUTE_CHAR47 , vsd.SRC_ATTRIBUTE_CHAR48 H_SRC_ATTRIBUTE_CHAR48 , vsd.SRC_ATTRIBUTE_CHAR49 H_SRC_ATTRIBUTE_CHAR49 , vsd.SRC_ATTRIBUTE_CHAR5 H_SRC_ATTRIBUTE_CHAR5 , vsd.SRC_ATTRIBUTE_CHAR50 H_SRC_ATTRIBUTE_CHAR50 , vsd.SRC_ATTRIBUTE_CHAR51 H_SRC_ATTRIBUTE_CHAR51 , vsd.SRC_ATTRIBUTE_CHAR52 H_SRC_ATTRIBUTE_CHAR52 , vsd.SRC_ATTRIBUTE_CHAR53 H_SRC_ATTRIBUTE_CHAR53 , vsd.SRC_ATTRIBUTE_CHAR54 H_SRC_ATTRIBUTE_CHAR54 , vsd.SRC_ATTRIBUTE_CHAR55 H_SRC_ATTRIBUTE_CHAR55 , vsd.SRC_ATTRIBUTE_CHAR56 H_SRC_ATTRIBUTE_CHAR56 , vsd.SRC_ATTRIBUTE_CHAR57 H_SRC_ATTRIBUTE_CHAR57 , vsd.SRC_ATTRIBUTE_CHAR58 H_SRC_ATTRIBUTE_CHAR58 , vsd.SRC_ATTRIBUTE_CHAR59 H_SRC_ATTRIBUTE_CHAR59 , vsd.SRC_ATTRIBUTE_CHAR6 H_SRC_ATTRIBUTE_CHAR6 , vsd.SRC_ATTRIBUTE_CHAR60 H_SRC_ATTRIBUTE_CHAR60 , vsd.SRC_ATTRIBUTE_CHAR7 H_SRC_ATTRIBUTE_CHAR7 , vsd.SRC_ATTRIBUTE_CHAR8 H_SRC_ATTRIBUTE_CHAR8 , vsd.SRC_ATTRIBUTE_CHAR9 H_SRC_ATTRIBUTE_CHAR9 , vpo.ATTRIBUTE_CATEGORY PERF_OBLIG_ATTRIBUTE_CATEGORY , vpo.ATTRIBUTE1 PERF_OBLIG_ATTRIBUTE1 , vpo.ATTRIBUTE10 PERF_OBLIG_ATTRIBUTE10 , vpo.ATTRIBUTE11 PERF_OBLIG_ATTRIBUTE11 , vpo.ATTRIBUTE12 PERF_OBLIG_ATTRIBUTE12 , vpo.ATTRIBUTE13 PERF_OBLIG_ATTRIBUTE13 , vpo.ATTRIBUTE14 PERF_OBLIG_ATTRIBUTE14 , vpo.ATTRIBUTE15 PERF_OBLIG_ATTRIBUTE15 , vpo.ATTRIBUTE16 PERF_OBLIG_ATTRIBUTE16 , vpo.ATTRIBUTE17 PERF_OBLIG_ATTRIBUTE17 , vpo.ATTRIBUTE18 PERF_OBLIG_ATTRIBUTE18 , vpo.ATTRIBUTE19 PERF_OBLIG_ATTRIBUTE19 , vpo.ATTRIBUTE2 PERF_OBLIG_ATTRIBUTE2 , vpo.ATTRIBUTE20 PERF_OBLIG_ATTRIBUTE20 , vpo.ATTRIBUTE3 PERF_OBLIG_ATTRIBUTE3 , vpo.ATTRIBUTE4 PERF_OBLIG_ATTRIBUTE4 , vpo.ATTRIBUTE5 PERF_OBLIG_ATTRIBUTE5 , vpo.ATTRIBUTE6 PERF_OBLIG_ATTRIBUTE6 , vpo.ATTRIBUTE7 PERF_OBLIG_ATTRIBUTE7 , vpo.ATTRIBUTE8 PERF_OBLIG_ATTRIBUTE8 , vpo.ATTRIBUTE9 PERF_OBLIG_ATTRIBUTE9 , vsd.DOCUMENT_TYPE SRC_DOC_HEADER_TYPE , doc_type.NAME DOCUMENT_TYPE_NAME , /*vcch.CONTRACT_CURRENCY_CODE SRC_DOC_CURRENCY_CODE ,Enh 28337021 */ vpo.OBLIG_CURRENCY_CODE SRC_DOC_CURRENCY_CODE , /*vsd.DOCUMENT_DATE C_DOCUMENT_DATE , Moved to header as contract date*/ vpo.PERF_OBLIGATION_NUMBER PERFORMANCE_OBLIGATION_NUMBER , vpo.LATEST_REVISION_INTENT_CODE REVISION_INTENT_OBLIGATION, dists.EXCHANGE_RATE DIST_EXCHANGE_RATE , dists.EXCHANGE_RATE_DATE DIST_EXCHANGE_RATE_DATE , dists.EXCHANGE_RATE_TYPE DIST_EXCHANGE_RATE_TYPE , le.NAME LEGAL_ENTITY_NAME , vsd.DOCUMENT_DATE SRC_DOC_DATE , vsd.DOCUMENT_NUMBER SRC_DOC_NUMBER , funbu.BU_NAME BUSINESS_UNIT_NAME , dists.ACCOUNT_CLASS DIST_ACCOUNT_CLASS , dists.ACCOUNTING_DATE DIST_ACCOUNTING_DATE , ((CASE WHEN dists.ACCOUNT_CLASS = 'ORA_REV' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_REV_CLR' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_CL' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_CA' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_DISC_CLR' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_PRICE_VAR' THEN 1 ELSE 1 END ) * dists.ACCTD_AMOUNT) DIST_ACCTD_AMOUNT , (CASE WHEN (vcch.CONTRACT_CURRENCY_CODE = vpo.OBLIG_CURRENCY_CODE) AND ((CASE WHEN dists.ACCOUNT_CLASS = 'ORA_REV' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_REV_CLR' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_CL' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_CA' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_DISC_CLR' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_PRICE_VAR' THEN 1 ELSE 1 END ) * dists.ACCTD_AMOUNT) != ((CASE WHEN dists.ACCOUNT_CLASS = 'ORA_REV' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_REV_CLR' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_CL' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_CA' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_DISC_CLR' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_PRICE_VAR' THEN 1 ELSE 1 END ) * DECODE( NVL(vpo.DEVOLVE_PO_FLAG,'N'), 'Y', dists.ACCTD_AMOUNT, NVL(dists.AMOUNT,dists.ACCTD_AMOUNT)) ) THEN ((CASE WHEN dists.ACCOUNT_CLASS = 'ORA_REV' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_REV_CLR' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_CL' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_CA' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_DISC_CLR' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_PRICE_VAR' THEN 1 ELSE 1 END ) * dists.ACCTD_AMOUNT) ELSE ((CASE WHEN dists.ACCOUNT_CLASS = 'ORA_REV' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_REV_CLR' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_CL' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_CA' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_DISC_CLR' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_PRICE_VAR' THEN 1 ELSE 1 END ) * DECODE( NVL(vpo.DEVOLVE_PO_FLAG,'N'), 'Y', dists.ACCTD_AMOUNT, NVL(dists.AMOUNT,dists.ACCTD_AMOUNT))) END) DIST_AMOUNT , vpol.ATTRIBUTE_CATEGORY PERF_OBLIG_LINE_ATTR_CATEGORY , vpol.ATTRIBUTE1 PERF_OBLIG_LINE_ATTRIBUTE1 , vpol.ATTRIBUTE10 PERF_OBLIG_LINE_ATTRIBUTE10 , vpol.ATTRIBUTE11 PERF_OBLIG_LINE_ATTRIBUTE11 , vpol.ATTRIBUTE12 PERF_OBLIG_LINE_ATTRIBUTE12 , vpol.ATTRIBUTE13 PERF_OBLIG_LINE_ATTRIBUTE13 , vpol.ATTRIBUTE14 PERF_OBLIG_LINE_ATTRIBUTE14 , vpol.ATTRIBUTE15 PERF_OBLIG_LINE_ATTRIBUTE15 , vpol.ATTRIBUTE16 PERF_OBLIG_LINE_ATTRIBUTE16 , vpol.ATTRIBUTE17 PERF_OBLIG_LINE_ATTRIBUTE17 , vpol.ATTRIBUTE18 PERF_OBLIG_LINE_ATTRIBUTE18 , vpol.ATTRIBUTE19 PERF_OBLIG_LINE_ATTRIBUTE19 , vpol.ATTRIBUTE2 PERF_OBLIG_LINE_ATTRIBUTE2 , vpol.ATTRIBUTE20 PERF_OBLIG_LINE_ATTRIBUTE20 , vpol.ATTRIBUTE3 PERF_OBLIG_LINE_ATTRIBUTE3 , vpol.ATTRIBUTE4 PERF_OBLIG_LINE_ATTRIBUTE4 , vpol.ATTRIBUTE5 PERF_OBLIG_LINE_ATTRIBUTE5 , vpol.ATTRIBUTE6 PERF_OBLIG_LINE_ATTRIBUTE6 , vpol.ATTRIBUTE7 PERF_OBLIG_LINE_ATTRIBUTE7 , vpol.ATTRIBUTE8 PERF_OBLIG_LINE_ATTRIBUTE8 , vpol.ATTRIBUTE9 PERF_OBLIG_LINE_ATTRIBUTE9 , ra_rules.NAME POL_REVENUE_RULE_NAME , vsdl.LINE_NUM SOURCE_DOCUMENT_LINE_NUMBER , vsdl.SRC_ATTRIBUTE_CATEGORY L_SRC_ATTRIBUTE_CATEGORY , vsdl.SRC_ATTRIBUTE_CHAR1 L_SRC_ATTRIBUTE_CHAR1, vsdl.SRC_ATTRIBUTE_CHAR10 L_SRC_ATTRIBUTE_CHAR10 , vsdl.SRC_ATTRIBUTE_CHAR11 L_SRC_ATTRIBUTE_CHAR11 , vsdl.SRC_ATTRIBUTE_CHAR12 L_SRC_ATTRIBUTE_CHAR12, vsdl.SRC_ATTRIBUTE_CHAR13 L_SRC_ATTRIBUTE_CHAR13 , vsdl.SRC_ATTRIBUTE_CHAR14 L_SRC_ATTRIBUTE_CHAR14 , vsdl.SRC_ATTRIBUTE_CHAR15 L_SRC_ATTRIBUTE_CHAR15 , vsdl.SRC_ATTRIBUTE_CHAR16 L_SRC_ATTRIBUTE_CHAR16 , vsdl.SRC_ATTRIBUTE_CHAR17 L_SRC_ATTRIBUTE_CHAR17 , vsdl.SRC_ATTRIBUTE_CHAR18 L_SRC_ATTRIBUTE_CHAR18 , vsdl.SRC_ATTRIBUTE_CHAR19 L_SRC_ATTRIBUTE_CHAR19 , vsdl.SRC_ATTRIBUTE_CHAR2 L_SRC_ATTRIBUTE_CHAR2 , vsdl.SRC_ATTRIBUTE_CHAR20 L_SRC_ATTRIBUTE_CHAR20 , vsdl.SRC_ATTRIBUTE_CHAR21 L_SRC_ATTRIBUTE_CHAR21 , vsdl.SRC_ATTRIBUTE_CHAR22 L_SRC_ATTRIBUTE_CHAR22 , vsdl.SRC_ATTRIBUTE_CHAR23 L_SRC_ATTRIBUTE_CHAR23 , vsdl.SRC_ATTRIBUTE_CHAR24 L_SRC_ATTRIBUTE_CHAR24 , vsdl.SRC_ATTRIBUTE_CHAR25 L_SRC_ATTRIBUTE_CHAR25 , vsdl.SRC_ATTRIBUTE_CHAR26 L_SRC_ATTRIBUTE_CHAR26 , vsdl.SRC_ATTRIBUTE_CHAR27 L_SRC_ATTRIBUTE_CHAR27 , vsdl.SRC_ATTRIBUTE_CHAR28 L_SRC_ATTRIBUTE_CHAR28 , vsdl.SRC_ATTRIBUTE_CHAR29 L_SRC_ATTRIBUTE_CHAR29 , vsdl.SRC_ATTRIBUTE_CHAR3 L_SRC_ATTRIBUTE_CHAR3 , vsdl.SRC_ATTRIBUTE_CHAR30 L_SRC_ATTRIBUTE_CHAR30 , vsdl.SRC_ATTRIBUTE_CHAR31 L_SRC_ATTRIBUTE_CHAR31 , vsdl.SRC_ATTRIBUTE_CHAR32 L_SRC_ATTRIBUTE_CHAR32 , vsdl.SRC_ATTRIBUTE_CHAR33 L_SRC_ATTRIBUTE_CHAR33 , vsdl.SRC_ATTRIBUTE_CHAR34 L_SRC_ATTRIBUTE_CHAR34 , vsdl.SRC_ATTRIBUTE_CHAR35 L_SRC_ATTRIBUTE_CHAR35 , vsdl.SRC_ATTRIBUTE_CHAR36 L_SRC_ATTRIBUTE_CHAR36 , vsdl.SRC_ATTRIBUTE_CHAR37 L_SRC_ATTRIBUTE_CHAR37 , vsdl.SRC_ATTRIBUTE_CHAR38 L_SRC_ATTRIBUTE_CHAR38 , vsdl.SRC_ATTRIBUTE_CHAR39 L_SRC_ATTRIBUTE_CHAR39 , vsdl.SRC_ATTRIBUTE_CHAR4 L_SRC_ATTRIBUTE_CHAR4 , vsdl.SRC_ATTRIBUTE_CHAR40 L_SRC_ATTRIBUTE_CHAR40 , vsdl.SRC_ATTRIBUTE_CHAR41 L_SRC_ATTRIBUTE_CHAR41 , vsdl.SRC_ATTRIBUTE_CHAR42 L_SRC_ATTRIBUTE_CHAR42 , vsdl.SRC_ATTRIBUTE_CHAR43 L_SRC_ATTRIBUTE_CHAR43 , vsdl.SRC_ATTRIBUTE_CHAR44 L_SRC_ATTRIBUTE_CHAR44 , vsdl.SRC_ATTRIBUTE_CHAR45 L_SRC_ATTRIBUTE_CHAR45 , vsdl.SRC_ATTRIBUTE_CHAR46 L_SRC_ATTRIBUTE_CHAR46 , vsdl.SRC_ATTRIBUTE_CHAR47 L_SRC_ATTRIBUTE_CHAR47 , vsdl.SRC_ATTRIBUTE_CHAR48 L_SRC_ATTRIBUTE_CHAR48 , vsdl.SRC_ATTRIBUTE_CHAR49 L_SRC_ATTRIBUTE_CHAR49 , vsdl.SRC_ATTRIBUTE_CHAR5 L_SRC_ATTRIBUTE_CHAR5 , vsdl.SRC_ATTRIBUTE_CHAR50 L_SRC_ATTRIBUTE_CHAR50 , vsdl.SRC_ATTRIBUTE_CHAR51 L_SRC_ATTRIBUTE_CHAR51 , vsdl.SRC_ATTRIBUTE_CHAR52 L_SRC_ATTRIBUTE_CHAR52 , vsdl.SRC_ATTRIBUTE_CHAR53 L_SRC_ATTRIBUTE_CHAR53 , vsdl.SRC_ATTRIBUTE_CHAR54 L_SRC_ATTRIBUTE_CHAR54 , vsdl.SRC_ATTRIBUTE_CHAR55 L_SRC_ATTRIBUTE_CHAR55 , vsdl.SRC_ATTRIBUTE_CHAR56 L_SRC_ATTRIBUTE_CHAR56 , vsdl.SRC_ATTRIBUTE_CHAR57 L_SRC_ATTRIBUTE_CHAR57 , vsdl.SRC_ATTRIBUTE_CHAR58 L_SRC_ATTRIBUTE_CHAR58 , vsdl.SRC_ATTRIBUTE_CHAR59 L_SRC_ATTRIBUTE_CHAR59 , vsdl.SRC_ATTRIBUTE_CHAR6 L_SRC_ATTRIBUTE_CHAR6 , vsdl.SRC_ATTRIBUTE_CHAR60 L_SRC_ATTRIBUTE_CHAR60 , vsdl.SRC_ATTRIBUTE_CHAR7 L_SRC_ATTRIBUTE_CHAR7 , vsdl.SRC_ATTRIBUTE_CHAR8 L_SRC_ATTRIBUTE_CHAR8 , vsdl.SRC_ATTRIBUTE_CHAR9 L_SRC_ATTRIBUTE_CHAR9 , vpol.PERF_OBLIGATION_LINE_NUMBER PERF_OBLIG_LINE_NUMBER , vpol.LATEST_REVISION_INTENT_CODE REVISION_INTENT_OBLIG_LINE, lkp.meaning PERFORMANCE_OBLIGATION_TYPE , vsdl.LINE_TYPE SRC_DOC_LINE_TYPE , l.EVENT_ID EVENT_ID , l.ledger_id LEDGER_ID , l.LINE_NUMBER LINE_NUMBER, vas.CONTRACT_CLG_DEF_ACCOUNT_CCID CONTRACT_REVENUE_CLEARING_CCID, splits.REVENUE_ACCOUNT_CCID REVENUE_SPLIT_REV_CCID, dists.TRANSFER_TO_GL_FLAG TRANSFER_TO_GL, vpo.DEVOLVE_PO_FLAG DEVOLVE_PO_FLAG, vpo.OBLIGATION_REFERENCE, vpo.PERF_OBLIG_CLASSIFICATION_CODE, NVL(vpo.RESIDUAL_APPROACH_FLAG, 'N') as PO_RESIDUAL_APPROACH_FLAG, NVL(vpol.RESIDUAL_APPROACH_FLAG, 'N') as POL_RESIDUAL_APPROACH_FLAG, vpo.FOREIGN_CURR_TREATMENT_CODE FOREIGN_CURR_TREATMENT_CODE, NULL PO_MEMO_LINE_NAME, NULL PO_CUST_PO_NUMBER, NULL PO_DOCUMENT_LINE_ID, NULL PO_ELEMENT_TYPE, NULL PO_ITEM_NUMBER, NULL PO_SRC_ATTRIBUTE_CHAR1, NULL PO_SRC_ATTRIBUTE_CHAR10, NULL PO_SRC_ATTRIBUTE_CHAR11, NULL PO_SRC_ATTRIBUTE_CHAR12, NULL PO_SRC_ATTRIBUTE_CHAR13, NULL PO_SRC_ATTRIBUTE_CHAR14, NULL PO_SRC_ATTRIBUTE_CHAR15, NULL PO_SRC_ATTRIBUTE_CHAR16, NULL PO_SRC_ATTRIBUTE_CHAR17, NULL PO_SRC_ATTRIBUTE_CHAR18, NULL PO_SRC_ATTRIBUTE_CHAR19, NULL PO_SRC_ATTRIBUTE_CHAR2, NULL PO_SRC_ATTRIBUTE_CHAR20, NULL PO_SRC_ATTRIBUTE_CHAR21, NULL PO_SRC_ATTRIBUTE_CHAR22, NULL PO_SRC_ATTRIBUTE_CHAR23, NULL PO_SRC_ATTRIBUTE_CHAR24, NULL PO_SRC_ATTRIBUTE_CHAR25, NULL PO_SRC_ATTRIBUTE_CHAR26, NULL PO_SRC_ATTRIBUTE_CHAR27, NULL PO_SRC_ATTRIBUTE_CHAR28, NULL PO_SRC_ATTRIBUTE_CHAR29, NULL PO_SRC_ATTRIBUTE_CHAR3, NULL PO_SRC_ATTRIBUTE_CHAR30, NULL PO_SRC_ATTRIBUTE_CHAR31, NULL PO_SRC_ATTRIBUTE_CHAR32, NULL PO_SRC_ATTRIBUTE_CHAR33, NULL PO_SRC_ATTRIBUTE_CHAR34, NULL PO_SRC_ATTRIBUTE_CHAR35, NULL PO_SRC_ATTRIBUTE_CHAR36, NULL PO_SRC_ATTRIBUTE_CHAR37, NULL PO_SRC_ATTRIBUTE_CHAR38, NULL PO_SRC_ATTRIBUTE_CHAR39, NULL PO_SRC_ATTRIBUTE_CHAR4, NULL PO_SRC_ATTRIBUTE_CHAR40, NULL PO_SRC_ATTRIBUTE_CHAR41, NULL PO_SRC_ATTRIBUTE_CHAR42, NULL PO_SRC_ATTRIBUTE_CHAR43, NULL PO_SRC_ATTRIBUTE_CHAR44, NULL PO_SRC_ATTRIBUTE_CHAR45, NULL PO_SRC_ATTRIBUTE_CHAR46, NULL PO_SRC_ATTRIBUTE_CHAR47, NULL PO_SRC_ATTRIBUTE_CHAR48, NULL PO_SRC_ATTRIBUTE_CHAR49, NULL PO_SRC_ATTRIBUTE_CHAR5, NULL PO_SRC_ATTRIBUTE_CHAR50, NULL PO_SRC_ATTRIBUTE_CHAR51, NULL PO_SRC_ATTRIBUTE_CHAR52, NULL PO_SRC_ATTRIBUTE_CHAR53, NULL PO_SRC_ATTRIBUTE_CHAR54, NULL PO_SRC_ATTRIBUTE_CHAR55, NULL PO_SRC_ATTRIBUTE_CHAR56, NULL PO_SRC_ATTRIBUTE_CHAR57, NULL PO_SRC_ATTRIBUTE_CHAR58, NULL PO_SRC_ATTRIBUTE_CHAR59, NULL PO_SRC_ATTRIBUTE_CHAR6, NULL PO_SRC_ATTRIBUTE_CHAR60, NULL PO_SRC_ATTRIBUTE_CHAR7, NULL PO_SRC_ATTRIBUTE_CHAR8, NULL PO_SRC_ATTRIBUTE_CHAR9, NULL PO_SRC_ATTRIBUTE_NUMBER1, NULL PO_SRC_ATTRIBUTE_NUMBER10, NULL PO_SRC_ATTRIBUTE_NUMBER11, NULL PO_SRC_ATTRIBUTE_NUMBER12, NULL PO_SRC_ATTRIBUTE_NUMBER13, NULL PO_SRC_ATTRIBUTE_NUMBER14, NULL PO_SRC_ATTRIBUTE_NUMBER15, NULL PO_SRC_ATTRIBUTE_NUMBER16, NULL PO_SRC_ATTRIBUTE_NUMBER17, NULL PO_SRC_ATTRIBUTE_NUMBER18, NULL PO_SRC_ATTRIBUTE_NUMBER19, NULL PO_SRC_ATTRIBUTE_NUMBER2, NULL PO_SRC_ATTRIBUTE_NUMBER20, NULL PO_SRC_ATTRIBUTE_NUMBER3, NULL PO_SRC_ATTRIBUTE_NUMBER4, NULL PO_SRC_ATTRIBUTE_NUMBER5, NULL PO_SRC_ATTRIBUTE_NUMBER6, NULL PO_SRC_ATTRIBUTE_NUMBER7, NULL PO_SRC_ATTRIBUTE_NUMBER8, NULL PO_SRC_ATTRIBUTE_NUMBER9, vpol.LINE_SATISFACTION_DATE POL_LINE_SATISFACTION_DATE, vpol.FIRST_SATISFACTION_EVENT_DATE POL_FIRST_SATIS_EVENT_DATE FROM VRM_XLA_IFRS15_EXTRACT_GT l, VRM_SOURCE_DOC_LINES vsdl, VRM_SOURCE_DOCUMENTS vsd, VRM_CUSTOMER_CONTRACT_HEADERS vcch, VRM_PERF_OBLIGATIONS vpo, VRM_PERF_OBLIGATION_LINES vpol, VRM_PERF_OBLIGATION_LIN_DISTS dists, fun_organizations_v funbu, RA_RULES ra_rules, VRM_SOURCE_DOC_TYPES_VL doc_type, XLE_ENTITY_PROFILES le , VRM_NEW_APP_SOURCES vas, VRM_PERF_OBLIGATION_LIN_SPLITS splits, VRM_LOOKUPS lkp WHERE l.LEVEL_CODE = 'L' AND l.EVENT_TYPE_CODE IN ('REV_PERF_OBL_SATISFIED','REV_PERF_OBL_BILLED') AND vsdl.document_line_id = l.document_line_id AND vsd.document_id = l.document_id AND vcch.CUSTOMER_CONTRACT_HEADER_ID = l.CUSTOMER_CONTRACT_HEADER_ID AND vpo.PERF_OBLIGATION_ID = l.PERF_OBLIGATION_ID AND vpol.PERF_OBLIGATION_LINE_ID = l.PERF_OBLIGATION_LINE_ID AND dists.PERF_OBLIGATION_LINE_DIST_ID = l.PERF_OBLIGATION_LINE_DIST_ID AND funbu.bu_id = l.bu_ID AND ra_rules.RULE_ID(+) = vpol.REVENUE_RULE_ID AND doc_type.document_type_id = vsd.document_type_id AND le.legal_entity_id = vsd.legal_entity_id AND vas.document_type_id = vsd.document_type_id AND vas.ledger_id = l.ledger_id AND splits.PERF_OBLIGATION_LINE_SPLIT_ID(+) = l.PERF_OBLIGATION_LINE_SPLIT_ID AND lkp.lookup_code = vpo.PERF_OBLIGATION_TYPE AND lkp.lookup_type = 'ORA_VRM_PERF_OBLIGATION_TYPE' UNION ALL SELECT /*+ cardinality(l 2) LEADING(l) INDEX(dists VRM_PERF_OBLIG_LIN_DIST_U1) INDEX(vpo VRM_PERF_OBLIGATIONS_U1) INDEX(vcch VRM_CUST_CONTRACT_HDRS_U1) INDEX(l VRM_XLA_IFRS15_EXTRACT_GT_N1) */ l.PERF_OBLIGATION_LINE_DIST_ID PERF_OBLIGATION_LINE_DIST_ID , NULL H_SRC_ATTRIBUTE_CATEGORY , NULL H_SRC_ATTRIBUTE_CHAR1 , NULL H_SRC_ATTRIBUTE_CHAR10 , NULL H_SRC_ATTRIBUTE_CHAR11 , NULL H_SRC_ATTRIBUTE_CHAR12 , NULL H_SRC_ATTRIBUTE_CHAR13 , NULL H_SRC_ATTRIBUTE_CHAR14 , NULL H_SRC_ATTRIBUTE_CHAR15 , NULL H_SRC_ATTRIBUTE_CHAR16 , NULL H_SRC_ATTRIBUTE_CHAR17 , NULL H_SRC_ATTRIBUTE_CHAR18 , NULL H_SRC_ATTRIBUTE_CHAR19 , NULL H_SRC_ATTRIBUTE_CHAR2 , NULL H_SRC_ATTRIBUTE_CHAR20 , NULL H_SRC_ATTRIBUTE_CHAR21 , NULL H_SRC_ATTRIBUTE_CHAR22 , NULL H_SRC_ATTRIBUTE_CHAR23 , NULL H_SRC_ATTRIBUTE_CHAR24 , NULL H_SRC_ATTRIBUTE_CHAR25 , NULL H_SRC_ATTRIBUTE_CHAR26 , NULL H_SRC_ATTRIBUTE_CHAR27 , NULL H_SRC_ATTRIBUTE_CHAR28 , NULL H_SRC_ATTRIBUTE_CHAR29 , NULL H_SRC_ATTRIBUTE_CHAR3 , NULL H_SRC_ATTRIBUTE_CHAR30 , NULL H_SRC_ATTRIBUTE_CHAR31 , NULL H_SRC_ATTRIBUTE_CHAR32 , NULL H_SRC_ATTRIBUTE_CHAR33 , NULL H_SRC_ATTRIBUTE_CHAR34 , NULL H_SRC_ATTRIBUTE_CHAR35 , NULL H_SRC_ATTRIBUTE_CHAR36 , NULL H_SRC_ATTRIBUTE_CHAR37 , NULL H_SRC_ATTRIBUTE_CHAR38 , NULL H_SRC_ATTRIBUTE_CHAR39 , NULL H_SRC_ATTRIBUTE_CHAR4 , NULL H_SRC_ATTRIBUTE_CHAR40 , NULL H_SRC_ATTRIBUTE_CHAR41 , NULL H_SRC_ATTRIBUTE_CHAR42 , NULL H_SRC_ATTRIBUTE_CHAR43 , NULL H_SRC_ATTRIBUTE_CHAR44 , NULL H_SRC_ATTRIBUTE_CHAR45 , NULL H_SRC_ATTRIBUTE_CHAR46 , NULL H_SRC_ATTRIBUTE_CHAR47 , NULL H_SRC_ATTRIBUTE_CHAR48 , NULL H_SRC_ATTRIBUTE_CHAR49 , NULL H_SRC_ATTRIBUTE_CHAR5 , NULL H_SRC_ATTRIBUTE_CHAR50 , NULL H_SRC_ATTRIBUTE_CHAR51 , NULL H_SRC_ATTRIBUTE_CHAR52 , NULL H_SRC_ATTRIBUTE_CHAR53 , NULL H_SRC_ATTRIBUTE_CHAR54 , NULL H_SRC_ATTRIBUTE_CHAR55 , NULL H_SRC_ATTRIBUTE_CHAR56 , NULL H_SRC_ATTRIBUTE_CHAR57 , NULL H_SRC_ATTRIBUTE_CHAR58 , NULL H_SRC_ATTRIBUTE_CHAR59 , NULL H_SRC_ATTRIBUTE_CHAR6 , NULL H_SRC_ATTRIBUTE_CHAR60 , NULL H_SRC_ATTRIBUTE_CHAR7 , NULL H_SRC_ATTRIBUTE_CHAR8 , NULL H_SRC_ATTRIBUTE_CHAR9 , vpo.ATTRIBUTE_CATEGORY PERF_OBLIG_ATTRIBUTE_CATEGORY , vpo.ATTRIBUTE1 PERF_OBLIG_ATTRIBUTE1 , vpo.ATTRIBUTE10 PERF_OBLIG_ATTRIBUTE10 , vpo.ATTRIBUTE11 PERF_OBLIG_ATTRIBUTE11 , vpo.ATTRIBUTE12 PERF_OBLIG_ATTRIBUTE12 , vpo.ATTRIBUTE13 PERF_OBLIG_ATTRIBUTE13 , vpo.ATTRIBUTE14 PERF_OBLIG_ATTRIBUTE14 , vpo.ATTRIBUTE15 PERF_OBLIG_ATTRIBUTE15 , vpo.ATTRIBUTE16 PERF_OBLIG_ATTRIBUTE16 , vpo.ATTRIBUTE17 PERF_OBLIG_ATTRIBUTE17 , vpo.ATTRIBUTE18 PERF_OBLIG_ATTRIBUTE18 , vpo.ATTRIBUTE19 PERF_OBLIG_ATTRIBUTE19 , vpo.ATTRIBUTE2 PERF_OBLIG_ATTRIBUTE2 , vpo.ATTRIBUTE20 PERF_OBLIG_ATTRIBUTE20 , vpo.ATTRIBUTE3 PERF_OBLIG_ATTRIBUTE3 , vpo.ATTRIBUTE4 PERF_OBLIG_ATTRIBUTE4 , vpo.ATTRIBUTE5 PERF_OBLIG_ATTRIBUTE5 , vpo.ATTRIBUTE6 PERF_OBLIG_ATTRIBUTE6 , vpo.ATTRIBUTE7 PERF_OBLIG_ATTRIBUTE7 , vpo.ATTRIBUTE8 PERF_OBLIG_ATTRIBUTE8 , vpo.ATTRIBUTE9 PERF_OBLIG_ATTRIBUTE9 , NULL SRC_DOC_HEADER_TYPE , NULL DOCUMENT_TYPE_NAME , /*vcch.CONTRACT_CURRENCY_CODE SRC_DOC_CURRENCY_CODE , Enh 28337021 */ vpo.OBLIG_CURRENCY_CODE SRC_DOC_CURRENCY_CODE , /*vsd.DOCUMENT_DATE C_DOCUMENT_DATE , Moved to header as contract date*/ vpo.PERF_OBLIGATION_NUMBER PERFORMANCE_OBLIGATION_NUMBER , vpo.LATEST_REVISION_INTENT_CODE REVISION_INTENT_OBLIGATION, dists.EXCHANGE_RATE DIST_EXCHANGE_RATE , dists.EXCHANGE_RATE_DATE DIST_EXCHANGE_RATE_DATE , dists.EXCHANGE_RATE_TYPE DIST_EXCHANGE_RATE_TYPE , NULL LEGAL_ENTITY_NAME , NULL SRC_DOC_DATE , NULL SRC_DOC_NUMBER , NULL BUSINESS_UNIT_NAME , dists.ACCOUNT_CLASS DIST_ACCOUNT_CLASS , dists.ACCOUNTING_DATE DIST_ACCOUNTING_DATE , ((CASE WHEN dists.ACCOUNT_CLASS = 'ORA_REV' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_REV_CLR' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_CL' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_CA' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_DISC_CLR' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_PRICE_VAR' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_REV_WRITE_OFF' THEN 1 ELSE 1 END ) * dists.ACCTD_AMOUNT) DIST_ACCTD_AMOUNT , (CASE WHEN (vcch.CONTRACT_CURRENCY_CODE = vpo.OBLIG_CURRENCY_CODE) AND ((CASE WHEN dists.ACCOUNT_CLASS = 'ORA_REV' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_REV_CLR' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_CL' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_CA' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_DISC_CLR' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_PRICE_VAR' THEN 1 ELSE 1 END ) * dists.ACCTD_AMOUNT) != ((CASE WHEN dists.ACCOUNT_CLASS = 'ORA_REV' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_REV_CLR' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_CL' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_CA' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_DISC_CLR' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_PRICE_VAR' THEN 1 ELSE 1 END ) * DECODE( NVL(vpo.DEVOLVE_PO_FLAG,'N'), 'Y', dists.ACCTD_AMOUNT, dists.AMOUNT)) THEN ((CASE WHEN dists.ACCOUNT_CLASS = 'ORA_REV' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_REV_CLR' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_CL' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_CA' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_DISC_CLR' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_PRICE_VAR' THEN 1 ELSE 1 END ) * dists.ACCTD_AMOUNT) ELSE ((CASE WHEN dists.ACCOUNT_CLASS = 'ORA_REV' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_REV_CLR' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_CL' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_CA' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_DISC_CLR' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_PRICE_VAR' THEN 1 ELSE 1 END ) * DECODE( NVL(vpo.DEVOLVE_PO_FLAG,'N'), 'Y', dists.ACCTD_AMOUNT, dists.AMOUNT)) END) DIST_AMOUNT , NULL PERF_OBLIG_LINE_ATTR_CATEGORY , NULL PERF_OBLIG_LINE_ATTRIBUTE1 , NULL PERF_OBLIG_LINE_ATTRIBUTE10 , NULL PERF_OBLIG_LINE_ATTRIBUTE11 , NULL PERF_OBLIG_LINE_ATTRIBUTE12 , NULL PERF_OBLIG_LINE_ATTRIBUTE13 , NULL PERF_OBLIG_LINE_ATTRIBUTE14 , NULL PERF_OBLIG_LINE_ATTRIBUTE15 , NULL PERF_OBLIG_LINE_ATTRIBUTE16 , NULL PERF_OBLIG_LINE_ATTRIBUTE17 , NULL PERF_OBLIG_LINE_ATTRIBUTE18 , NULL PERF_OBLIG_LINE_ATTRIBUTE19 , NULL PERF_OBLIG_LINE_ATTRIBUTE2 , NULL PERF_OBLIG_LINE_ATTRIBUTE20 , NULL PERF_OBLIG_LINE_ATTRIBUTE3 , NULL PERF_OBLIG_LINE_ATTRIBUTE4 , NULL PERF_OBLIG_LINE_ATTRIBUTE5 , NULL PERF_OBLIG_LINE_ATTRIBUTE6 , NULL PERF_OBLIG_LINE_ATTRIBUTE7 , NULL PERF_OBLIG_LINE_ATTRIBUTE8 , NULL PERF_OBLIG_LINE_ATTRIBUTE9 , NULL POL_REVENUE_RULE_NAME , NULL SOURCE_DOCUMENT_LINE_NUMBER , NULL L_SRC_ATTRIBUTE_CATEGORY , NULL L_SRC_ATTRIBUTE_CHAR1 , NULL L_SRC_ATTRIBUTE_CHAR10 , NULL L_SRC_ATTRIBUTE_CHAR11 , NULL L_SRC_ATTRIBUTE_CHAR12 , NULL L_SRC_ATTRIBUTE_CHAR13 , NULL L_SRC_ATTRIBUTE_CHAR14 , NULL L_SRC_ATTRIBUTE_CHAR15 , NULL L_SRC_ATTRIBUTE_CHAR16 , NULL L_SRC_ATTRIBUTE_CHAR17 , NULL L_SRC_ATTRIBUTE_CHAR18 , NULL L_SRC_ATTRIBUTE_CHAR19 , NULL L_SRC_ATTRIBUTE_CHAR2 , NULL L_SRC_ATTRIBUTE_CHAR20 , NULL L_SRC_ATTRIBUTE_CHAR21 , NULL L_SRC_ATTRIBUTE_CHAR22 , NULL L_SRC_ATTRIBUTE_CHAR23 , NULL L_SRC_ATTRIBUTE_CHAR24 , NULL L_SRC_ATTRIBUTE_CHAR25 , NULL L_SRC_ATTRIBUTE_CHAR26 , NULL L_SRC_ATTRIBUTE_CHAR27 , NULL L_SRC_ATTRIBUTE_CHAR28 , NULL L_SRC_ATTRIBUTE_CHAR29 , NULL L_SRC_ATTRIBUTE_CHAR3 , NULL L_SRC_ATTRIBUTE_CHAR30 , NULL L_SRC_ATTRIBUTE_CHAR31 , NULL L_SRC_ATTRIBUTE_CHAR32 , NULL L_SRC_ATTRIBUTE_CHAR33 , NULL L_SRC_ATTRIBUTE_CHAR34 , NULL L_SRC_ATTRIBUTE_CHAR35 , NULL L_SRC_ATTRIBUTE_CHAR36 , NULL L_SRC_ATTRIBUTE_CHAR37 , NULL L_SRC_ATTRIBUTE_CHAR38 , NULL L_SRC_ATTRIBUTE_CHAR39 , NULL L_SRC_ATTRIBUTE_CHAR4 , NULL L_SRC_ATTRIBUTE_CHAR40 , NULL L_SRC_ATTRIBUTE_CHAR41 , NULL L_SRC_ATTRIBUTE_CHAR42 , NULL L_SRC_ATTRIBUTE_CHAR43 , NULL L_SRC_ATTRIBUTE_CHAR44 , NULL L_SRC_ATTRIBUTE_CHAR45 , NULL L_SRC_ATTRIBUTE_CHAR46 , NULL L_SRC_ATTRIBUTE_CHAR47 , NULL L_SRC_ATTRIBUTE_CHAR48 , NULL L_SRC_ATTRIBUTE_CHAR49 , NULL L_SRC_ATTRIBUTE_CHAR5 , NULL L_SRC_ATTRIBUTE_CHAR50 , NULL L_SRC_ATTRIBUTE_CHAR51 , NULL L_SRC_ATTRIBUTE_CHAR52 , NULL L_SRC_ATTRIBUTE_CHAR53 , NULL L_SRC_ATTRIBUTE_CHAR54 , NULL L_SRC_ATTRIBUTE_CHAR55 , NULL L_SRC_ATTRIBUTE_CHAR56 , NULL L_SRC_ATTRIBUTE_CHAR57 , NULL L_SRC_ATTRIBUTE_CHAR58 , NULL L_SRC_ATTRIBUTE_CHAR59 , NULL L_SRC_ATTRIBUTE_CHAR6 , NULL L_SRC_ATTRIBUTE_CHAR60 , NULL L_SRC_ATTRIBUTE_CHAR7 , NULL L_SRC_ATTRIBUTE_CHAR8 , NULL L_SRC_ATTRIBUTE_CHAR9 , NULL PERF_OBLIG_LINE_NUMBER , NULL REVISION_INTENT_OBLIG_LINE, lkp.meaning PERFORMANCE_OBLIGATION_TYPE , NULL SRC_DOC_LINE_TYPE , l.EVENT_ID EVENT_ID , l.ledger_id LEDGER_ID , l.LINE_NUMBER LINE_NUMBER, NULL CONTRACT_REVENUE_CLEARING_CCID, NULL REVENUE_SPLIT_REV_CCID, dists.TRANSFER_TO_GL_FLAG TRANSFER_TO_GL, vpo.devolve_po_flag DEVOLVE_PO_FLAG, vpo.OBLIGATION_REFERENCE, vpo.PERF_OBLIG_CLASSIFICATION_CODE, NVL(vpo.RESIDUAL_APPROACH_FLAG, 'N') as PO_RESIDUAL_APPROACH_FLAG, NULL as POL_RESIDUAL_APPROACH_FLAG, vpo.FOREIGN_CURR_TREATMENT_CODE FOREIGN_CURR_TREATMENT_CODE, NULL PO_MEMO_LINE_NAME, NULL PO_CUST_PO_NUMBER, NULL PO_DOCUMENT_LINE_ID, NULL PO_ELEMENT_TYPE, NULL PO_ITEM_NUMBER, NULL PO_SRC_ATTRIBUTE_CHAR1, NULL PO_SRC_ATTRIBUTE_CHAR10, NULL PO_SRC_ATTRIBUTE_CHAR11, NULL PO_SRC_ATTRIBUTE_CHAR12, NULL PO_SRC_ATTRIBUTE_CHAR13, NULL PO_SRC_ATTRIBUTE_CHAR14, NULL PO_SRC_ATTRIBUTE_CHAR15, NULL PO_SRC_ATTRIBUTE_CHAR16, NULL PO_SRC_ATTRIBUTE_CHAR17, NULL PO_SRC_ATTRIBUTE_CHAR18, NULL PO_SRC_ATTRIBUTE_CHAR19, NULL PO_SRC_ATTRIBUTE_CHAR2, NULL PO_SRC_ATTRIBUTE_CHAR20, NULL PO_SRC_ATTRIBUTE_CHAR21, NULL PO_SRC_ATTRIBUTE_CHAR22, NULL PO_SRC_ATTRIBUTE_CHAR23, NULL PO_SRC_ATTRIBUTE_CHAR24, NULL PO_SRC_ATTRIBUTE_CHAR25, NULL PO_SRC_ATTRIBUTE_CHAR26, NULL PO_SRC_ATTRIBUTE_CHAR27, NULL PO_SRC_ATTRIBUTE_CHAR28, NULL PO_SRC_ATTRIBUTE_CHAR29, NULL PO_SRC_ATTRIBUTE_CHAR3, NULL PO_SRC_ATTRIBUTE_CHAR30, NULL PO_SRC_ATTRIBUTE_CHAR31, NULL PO_SRC_ATTRIBUTE_CHAR32, NULL PO_SRC_ATTRIBUTE_CHAR33, NULL PO_SRC_ATTRIBUTE_CHAR34, NULL PO_SRC_ATTRIBUTE_CHAR35, NULL PO_SRC_ATTRIBUTE_CHAR36, NULL PO_SRC_ATTRIBUTE_CHAR37, NULL PO_SRC_ATTRIBUTE_CHAR38, NULL PO_SRC_ATTRIBUTE_CHAR39, NULL PO_SRC_ATTRIBUTE_CHAR4, NULL PO_SRC_ATTRIBUTE_CHAR40, NULL PO_SRC_ATTRIBUTE_CHAR41, NULL PO_SRC_ATTRIBUTE_CHAR42, NULL PO_SRC_ATTRIBUTE_CHAR43, NULL PO_SRC_ATTRIBUTE_CHAR44, NULL PO_SRC_ATTRIBUTE_CHAR45, NULL PO_SRC_ATTRIBUTE_CHAR46, NULL PO_SRC_ATTRIBUTE_CHAR47, NULL PO_SRC_ATTRIBUTE_CHAR48, NULL PO_SRC_ATTRIBUTE_CHAR49, NULL PO_SRC_ATTRIBUTE_CHAR5, NULL PO_SRC_ATTRIBUTE_CHAR50, NULL PO_SRC_ATTRIBUTE_CHAR51, NULL PO_SRC_ATTRIBUTE_CHAR52, NULL PO_SRC_ATTRIBUTE_CHAR53, NULL PO_SRC_ATTRIBUTE_CHAR54, NULL PO_SRC_ATTRIBUTE_CHAR55, NULL PO_SRC_ATTRIBUTE_CHAR56, NULL PO_SRC_ATTRIBUTE_CHAR57, NULL PO_SRC_ATTRIBUTE_CHAR58, NULL PO_SRC_ATTRIBUTE_CHAR59, NULL PO_SRC_ATTRIBUTE_CHAR6, NULL PO_SRC_ATTRIBUTE_CHAR60, NULL PO_SRC_ATTRIBUTE_CHAR7, NULL PO_SRC_ATTRIBUTE_CHAR8, NULL PO_SRC_ATTRIBUTE_CHAR9, NULL PO_SRC_ATTRIBUTE_NUMBER1, NULL PO_SRC_ATTRIBUTE_NUMBER10, NULL PO_SRC_ATTRIBUTE_NUMBER11, NULL PO_SRC_ATTRIBUTE_NUMBER12, NULL PO_SRC_ATTRIBUTE_NUMBER13, NULL PO_SRC_ATTRIBUTE_NUMBER14, NULL PO_SRC_ATTRIBUTE_NUMBER15, NULL PO_SRC_ATTRIBUTE_NUMBER16, NULL PO_SRC_ATTRIBUTE_NUMBER17, NULL PO_SRC_ATTRIBUTE_NUMBER18, NULL PO_SRC_ATTRIBUTE_NUMBER19, NULL PO_SRC_ATTRIBUTE_NUMBER2, NULL PO_SRC_ATTRIBUTE_NUMBER20, NULL PO_SRC_ATTRIBUTE_NUMBER3, NULL PO_SRC_ATTRIBUTE_NUMBER4, NULL PO_SRC_ATTRIBUTE_NUMBER5, NULL PO_SRC_ATTRIBUTE_NUMBER6, NULL PO_SRC_ATTRIBUTE_NUMBER7, NULL PO_SRC_ATTRIBUTE_NUMBER8, NULL PO_SRC_ATTRIBUTE_NUMBER9, NULL POL_LINE_SATISFACTION_DATE, NULL POL_FIRST_SATIS_EVENT_DATE FROM VRM_XLA_IFRS15_EXTRACT_GT l, VRM_CUSTOMER_CONTRACT_HEADERS vcch, VRM_PERF_OBLIGATIONS vpo, VRM_PERF_OBLIGATION_LIN_DISTS dists, VRM_LOOKUPS lkp WHERE l.LEVEL_CODE = 'L' AND l.EVENT_TYPE_CODE IN ('REV_INITIAL_PERF', 'RESIDUAL_BAL_ADJ') AND vcch.CUSTOMER_CONTRACT_HEADER_ID = l.CUSTOMER_CONTRACT_HEADER_ID AND dists.PERF_OBLIGATION_LINE_DIST_ID = l.PERF_OBLIGATION_LINE_DIST_ID AND vpo.PERF_OBLIGATION_ID = l.PERF_OBLIGATION_ID AND lkp.lookup_code = vpo.PERF_OBLIGATION_TYPE AND lkp.lookup_type = 'ORA_VRM_PERF_OBLIGATION_TYPE' AND NOT EXISTS (SELECT 'X' FROM AR_LOOKUPS WHERE lookup_type= 'ORA_AR_FEATURES' AND lookup_code= 'VRM_IPE_ACCT_DERIVATION' AND enabled_flag = 'Y') UNION ALL SELECT /*+ cardinality(l 2) LEADING(l) INDEX(l VRM_XLA_IFRS15_EXTRACT_GT_N1) INDEX(dists VRM_PERF_OBLIG_LIN_DIST_U1) INDEX(vpol VRM_PERF_OBLIG_LINES_N4) INDEX(vpo VRM_PERF_OBLIGATIONS_U1) INDEX(vsdl VRM_SOURCE_DOC_LINES_U1) INDEX(vpl VRM_PRICING_LINES_U1) INDEX(vcch VRM_CUST_CONTRACT_HDRS_U1) */ l.PERF_OBLIGATION_LINE_DIST_ID PERF_OBLIGATION_LINE_DIST_ID , NULL H_SRC_ATTRIBUTE_CATEGORY , NULL H_SRC_ATTRIBUTE_CHAR1 , NULL H_SRC_ATTRIBUTE_CHAR10 , NULL H_SRC_ATTRIBUTE_CHAR11 , NULL H_SRC_ATTRIBUTE_CHAR12 , NULL H_SRC_ATTRIBUTE_CHAR13 , NULL H_SRC_ATTRIBUTE_CHAR14 , NULL H_SRC_ATTRIBUTE_CHAR15 , NULL H_SRC_ATTRIBUTE_CHAR16 , NULL H_SRC_ATTRIBUTE_CHAR17 , NULL H_SRC_ATTRIBUTE_CHAR18 , NULL H_SRC_ATTRIBUTE_CHAR19 , NULL H_SRC_ATTRIBUTE_CHAR2 , NULL H_SRC_ATTRIBUTE_CHAR20 , NULL H_SRC_ATTRIBUTE_CHAR21 , NULL H_SRC_ATTRIBUTE_CHAR22 , NULL H_SRC_ATTRIBUTE_CHAR23 , NULL H_SRC_ATTRIBUTE_CHAR24 , NULL H_SRC_ATTRIBUTE_CHAR25 , NULL H_SRC_ATTRIBUTE_CHAR26 , NULL H_SRC_ATTRIBUTE_CHAR27 , NULL H_SRC_ATTRIBUTE_CHAR28 , NULL H_SRC_ATTRIBUTE_CHAR29 , NULL H_SRC_ATTRIBUTE_CHAR3 , NULL H_SRC_ATTRIBUTE_CHAR30 , NULL H_SRC_ATTRIBUTE_CHAR31 , NULL H_SRC_ATTRIBUTE_CHAR32 , NULL H_SRC_ATTRIBUTE_CHAR33 , NULL H_SRC_ATTRIBUTE_CHAR34 , NULL H_SRC_ATTRIBUTE_CHAR35 , NULL H_SRC_ATTRIBUTE_CHAR36 , NULL H_SRC_ATTRIBUTE_CHAR37 , NULL H_SRC_ATTRIBUTE_CHAR38 , NULL H_SRC_ATTRIBUTE_CHAR39 , NULL H_SRC_ATTRIBUTE_CHAR4 , NULL H_SRC_ATTRIBUTE_CHAR40 , NULL H_SRC_ATTRIBUTE_CHAR41 , NULL H_SRC_ATTRIBUTE_CHAR42 , NULL H_SRC_ATTRIBUTE_CHAR43 , NULL H_SRC_ATTRIBUTE_CHAR44 , NULL H_SRC_ATTRIBUTE_CHAR45 , NULL H_SRC_ATTRIBUTE_CHAR46 , NULL H_SRC_ATTRIBUTE_CHAR47 , NULL H_SRC_ATTRIBUTE_CHAR48 , NULL H_SRC_ATTRIBUTE_CHAR49 , NULL H_SRC_ATTRIBUTE_CHAR5 , NULL H_SRC_ATTRIBUTE_CHAR50 , NULL H_SRC_ATTRIBUTE_CHAR51 , NULL H_SRC_ATTRIBUTE_CHAR52 , NULL H_SRC_ATTRIBUTE_CHAR53 , NULL H_SRC_ATTRIBUTE_CHAR54 , NULL H_SRC_ATTRIBUTE_CHAR55 , NULL H_SRC_ATTRIBUTE_CHAR56 , NULL H_SRC_ATTRIBUTE_CHAR57 , NULL H_SRC_ATTRIBUTE_CHAR58 , NULL H_SRC_ATTRIBUTE_CHAR59 , NULL H_SRC_ATTRIBUTE_CHAR6 , NULL H_SRC_ATTRIBUTE_CHAR60 , NULL H_SRC_ATTRIBUTE_CHAR7 , NULL H_SRC_ATTRIBUTE_CHAR8 , NULL H_SRC_ATTRIBUTE_CHAR9 , vpo.ATTRIBUTE_CATEGORY PERF_OBLIG_ATTRIBUTE_CATEGORY , vpo.ATTRIBUTE1 PERF_OBLIG_ATTRIBUTE1 , vpo.ATTRIBUTE10 PERF_OBLIG_ATTRIBUTE10 , vpo.ATTRIBUTE11 PERF_OBLIG_ATTRIBUTE11 , vpo.ATTRIBUTE12 PERF_OBLIG_ATTRIBUTE12 , vpo.ATTRIBUTE13 PERF_OBLIG_ATTRIBUTE13 , vpo.ATTRIBUTE14 PERF_OBLIG_ATTRIBUTE14 , vpo.ATTRIBUTE15 PERF_OBLIG_ATTRIBUTE15 , vpo.ATTRIBUTE16 PERF_OBLIG_ATTRIBUTE16 , vpo.ATTRIBUTE17 PERF_OBLIG_ATTRIBUTE17 , vpo.ATTRIBUTE18 PERF_OBLIG_ATTRIBUTE18 , vpo.ATTRIBUTE19 PERF_OBLIG_ATTRIBUTE19 , vpo.ATTRIBUTE2 PERF_OBLIG_ATTRIBUTE2 , vpo.ATTRIBUTE20 PERF_OBLIG_ATTRIBUTE20 , vpo.ATTRIBUTE3 PERF_OBLIG_ATTRIBUTE3 , vpo.ATTRIBUTE4 PERF_OBLIG_ATTRIBUTE4 , vpo.ATTRIBUTE5 PERF_OBLIG_ATTRIBUTE5 , vpo.ATTRIBUTE6 PERF_OBLIG_ATTRIBUTE6 , vpo.ATTRIBUTE7 PERF_OBLIG_ATTRIBUTE7 , vpo.ATTRIBUTE8 PERF_OBLIG_ATTRIBUTE8 , vpo.ATTRIBUTE9 PERF_OBLIG_ATTRIBUTE9 , NULL SRC_DOC_HEADER_TYPE , NULL DOCUMENT_TYPE_NAME , /*vcch.CONTRACT_CURRENCY_CODE SRC_DOC_CURRENCY_CODE ,Enh 28337021 */ vpo.OBLIG_CURRENCY_CODE SRC_DOC_CURRENCY_CODE , /*vsd.DOCUMENT_DATE C_DOCUMENT_DATE , Moved to header as contract date*/ vpo.PERF_OBLIGATION_NUMBER PERFORMANCE_OBLIGATION_NUMBER , vpo.LATEST_REVISION_INTENT_CODE REVISION_INTENT_OBLIGATION, dists.EXCHANGE_RATE DIST_EXCHANGE_RATE , dists.EXCHANGE_RATE_DATE DIST_EXCHANGE_RATE_DATE , dists.EXCHANGE_RATE_TYPE DIST_EXCHANGE_RATE_TYPE , NULL LEGAL_ENTITY_NAME , NULL SRC_DOC_DATE , NULL SRC_DOC_NUMBER , NULL BUSINESS_UNIT_NAME , dists.ACCOUNT_CLASS DIST_ACCOUNT_CLASS , dists.ACCOUNTING_DATE DIST_ACCOUNTING_DATE , ((CASE WHEN dists.ACCOUNT_CLASS = 'ORA_REV' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_REV_CLR' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_CL' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_CA' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_DISC_CLR' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_PRICE_VAR' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_REV_WRITE_OFF' THEN 1 ELSE 1 END ) * dists.ACCTD_AMOUNT) DIST_ACCTD_AMOUNT , (CASE WHEN (vcch.CONTRACT_CURRENCY_CODE = vpo.OBLIG_CURRENCY_CODE) AND ((CASE WHEN dists.ACCOUNT_CLASS = 'ORA_REV' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_REV_CLR' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_CL' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_CA' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_DISC_CLR' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_PRICE_VAR' THEN 1 ELSE 1 END ) * dists.ACCTD_AMOUNT) != ((CASE WHEN dists.ACCOUNT_CLASS = 'ORA_REV' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_REV_CLR' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_CL' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_CA' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_DISC_CLR' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_PRICE_VAR' THEN 1 ELSE 1 END ) * DECODE( NVL(vpo.DEVOLVE_PO_FLAG,'N'), 'Y', dists.ACCTD_AMOUNT, dists.AMOUNT)) THEN ((CASE WHEN dists.ACCOUNT_CLASS = 'ORA_REV' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_REV_CLR' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_CL' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_CA' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_DISC_CLR' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_PRICE_VAR' THEN 1 ELSE 1 END ) * dists.ACCTD_AMOUNT) ELSE ((CASE WHEN dists.ACCOUNT_CLASS = 'ORA_REV' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_REV_CLR' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_CL' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_CA' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_DISC_CLR' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_PRICE_VAR' THEN 1 ELSE 1 END ) * DECODE( NVL(vpo.DEVOLVE_PO_FLAG,'N'), 'Y', dists.ACCTD_AMOUNT, dists.AMOUNT)) END) DIST_AMOUNT , NULL PERF_OBLIG_LINE_ATTR_CATEGORY , NULL PERF_OBLIG_LINE_ATTRIBUTE1 , NULL PERF_OBLIG_LINE_ATTRIBUTE10 , NULL PERF_OBLIG_LINE_ATTRIBUTE11 , NULL PERF_OBLIG_LINE_ATTRIBUTE12 , NULL PERF_OBLIG_LINE_ATTRIBUTE13 , NULL PERF_OBLIG_LINE_ATTRIBUTE14 , NULL PERF_OBLIG_LINE_ATTRIBUTE15 , NULL PERF_OBLIG_LINE_ATTRIBUTE16 , NULL PERF_OBLIG_LINE_ATTRIBUTE17 , NULL PERF_OBLIG_LINE_ATTRIBUTE18 , NULL PERF_OBLIG_LINE_ATTRIBUTE19 , NULL PERF_OBLIG_LINE_ATTRIBUTE2 , NULL PERF_OBLIG_LINE_ATTRIBUTE20 , NULL PERF_OBLIG_LINE_ATTRIBUTE3 , NULL PERF_OBLIG_LINE_ATTRIBUTE4 , NULL PERF_OBLIG_LINE_ATTRIBUTE5 , NULL PERF_OBLIG_LINE_ATTRIBUTE6 , NULL PERF_OBLIG_LINE_ATTRIBUTE7 , NULL PERF_OBLIG_LINE_ATTRIBUTE8 , NULL PERF_OBLIG_LINE_ATTRIBUTE9 , NULL POL_REVENUE_RULE_NAME , NULL SOURCE_DOCUMENT_LINE_NUMBER , NULL L_SRC_ATTRIBUTE_CATEGORY , NULL L_SRC_ATTRIBUTE_CHAR1 , NULL L_SRC_ATTRIBUTE_CHAR10 , NULL L_SRC_ATTRIBUTE_CHAR11 , NULL L_SRC_ATTRIBUTE_CHAR12 , NULL L_SRC_ATTRIBUTE_CHAR13 , NULL L_SRC_ATTRIBUTE_CHAR14 , NULL L_SRC_ATTRIBUTE_CHAR15 , NULL L_SRC_ATTRIBUTE_CHAR16 , NULL L_SRC_ATTRIBUTE_CHAR17 , NULL L_SRC_ATTRIBUTE_CHAR18 , NULL L_SRC_ATTRIBUTE_CHAR19 , NULL L_SRC_ATTRIBUTE_CHAR2 , NULL L_SRC_ATTRIBUTE_CHAR20 , NULL L_SRC_ATTRIBUTE_CHAR21 , NULL L_SRC_ATTRIBUTE_CHAR22 , NULL L_SRC_ATTRIBUTE_CHAR23 , NULL L_SRC_ATTRIBUTE_CHAR24 , NULL L_SRC_ATTRIBUTE_CHAR25 , NULL L_SRC_ATTRIBUTE_CHAR26 , NULL L_SRC_ATTRIBUTE_CHAR27 , NULL L_SRC_ATTRIBUTE_CHAR28 , NULL L_SRC_ATTRIBUTE_CHAR29 , NULL L_SRC_ATTRIBUTE_CHAR3 , NULL L_SRC_ATTRIBUTE_CHAR30 , NULL L_SRC_ATTRIBUTE_CHAR31 , NULL L_SRC_ATTRIBUTE_CHAR32 , NULL L_SRC_ATTRIBUTE_CHAR33 , NULL L_SRC_ATTRIBUTE_CHAR34 , NULL L_SRC_ATTRIBUTE_CHAR35 , NULL L_SRC_ATTRIBUTE_CHAR36 , NULL L_SRC_ATTRIBUTE_CHAR37 , NULL L_SRC_ATTRIBUTE_CHAR38 , NULL L_SRC_ATTRIBUTE_CHAR39 , NULL L_SRC_ATTRIBUTE_CHAR4 , NULL L_SRC_ATTRIBUTE_CHAR40 , NULL L_SRC_ATTRIBUTE_CHAR41 , NULL L_SRC_ATTRIBUTE_CHAR42 , NULL L_SRC_ATTRIBUTE_CHAR43 , NULL L_SRC_ATTRIBUTE_CHAR44 , NULL L_SRC_ATTRIBUTE_CHAR45 , NULL L_SRC_ATTRIBUTE_CHAR46 , NULL L_SRC_ATTRIBUTE_CHAR47 , NULL L_SRC_ATTRIBUTE_CHAR48 , NULL L_SRC_ATTRIBUTE_CHAR49 , NULL L_SRC_ATTRIBUTE_CHAR5 , NULL L_SRC_ATTRIBUTE_CHAR50 , NULL L_SRC_ATTRIBUTE_CHAR51 , NULL L_SRC_ATTRIBUTE_CHAR52 , NULL L_SRC_ATTRIBUTE_CHAR53 , NULL L_SRC_ATTRIBUTE_CHAR54 , NULL L_SRC_ATTRIBUTE_CHAR55 , NULL L_SRC_ATTRIBUTE_CHAR56 , NULL L_SRC_ATTRIBUTE_CHAR57 , NULL L_SRC_ATTRIBUTE_CHAR58 , NULL L_SRC_ATTRIBUTE_CHAR59 , NULL L_SRC_ATTRIBUTE_CHAR6 , NULL L_SRC_ATTRIBUTE_CHAR60 , NULL L_SRC_ATTRIBUTE_CHAR7 , NULL L_SRC_ATTRIBUTE_CHAR8 , NULL L_SRC_ATTRIBUTE_CHAR9 , NULL PERF_OBLIG_LINE_NUMBER , NULL REVISION_INTENT_OBLIG_LINE, lkp.meaning PERFORMANCE_OBLIGATION_TYPE , NULL SRC_DOC_LINE_TYPE , l.EVENT_ID EVENT_ID , l.ledger_id LEDGER_ID , l.LINE_NUMBER LINE_NUMBER, NULL CONTRACT_REVENUE_CLEARING_CCID, NULL REVENUE_SPLIT_REV_CCID, dists.TRANSFER_TO_GL_FLAG TRANSFER_TO_GL, vpo.devolve_po_flag DEVOLVE_PO_FLAG, vpo.OBLIGATION_REFERENCE, vpo.PERF_OBLIG_CLASSIFICATION_CODE, NVL(vpo.RESIDUAL_APPROACH_FLAG, 'N') as PO_RESIDUAL_APPROACH_FLAG, NVL(vpol.RESIDUAL_APPROACH_FLAG, 'N') as POL_RESIDUAL_APPROACH_FLAG, vpo.FOREIGN_CURR_TREATMENT_CODE FOREIGN_CURR_TREATMENT_CODE, vsdl.MEMO_LINE_NAME PO_MEMO_LINE_NAME, vsdl.CUST_PO_NUMBER PO_CUST_PO_NUMBER, vsdl.DOCUMENT_LINE_ID PO_DOCUMENT_LINE_ID, vpl.ELEMENT_TYPE PO_ELEMENT_TYPE, vsdl.ITEM_NUMBER PO_ITEM_NUMBER, vsdl.SRC_ATTRIBUTE_CHAR1 PO_SRC_ATTRIBUTE_CHAR1, vsdl.SRC_ATTRIBUTE_CHAR10 PO_SRC_ATTRIBUTE_CHAR10, vsdl.SRC_ATTRIBUTE_CHAR11 PO_SRC_ATTRIBUTE_CHAR11, vsdl.SRC_ATTRIBUTE_CHAR12 PO_SRC_ATTRIBUTE_CHAR12, vsdl.SRC_ATTRIBUTE_CHAR13 PO_SRC_ATTRIBUTE_CHAR13, vsdl.SRC_ATTRIBUTE_CHAR14 PO_SRC_ATTRIBUTE_CHAR14, vsdl.SRC_ATTRIBUTE_CHAR15 PO_SRC_ATTRIBUTE_CHAR15, vsdl.SRC_ATTRIBUTE_CHAR16 PO_SRC_ATTRIBUTE_CHAR16, vsdl.SRC_ATTRIBUTE_CHAR17 PO_SRC_ATTRIBUTE_CHAR17, vsdl.SRC_ATTRIBUTE_CHAR18 PO_SRC_ATTRIBUTE_CHAR18, vsdl.SRC_ATTRIBUTE_CHAR19 PO_SRC_ATTRIBUTE_CHAR19, vsdl.SRC_ATTRIBUTE_CHAR2 PO_SRC_ATTRIBUTE_CHAR2, vsdl.SRC_ATTRIBUTE_CHAR20 PO_SRC_ATTRIBUTE_CHAR20, vsdl.SRC_ATTRIBUTE_CHAR21 PO_SRC_ATTRIBUTE_CHAR21, vsdl.SRC_ATTRIBUTE_CHAR22 PO_SRC_ATTRIBUTE_CHAR22, vsdl.SRC_ATTRIBUTE_CHAR23 PO_SRC_ATTRIBUTE_CHAR23, vsdl.SRC_ATTRIBUTE_CHAR24 PO_SRC_ATTRIBUTE_CHAR24, vsdl.SRC_ATTRIBUTE_CHAR25 PO_SRC_ATTRIBUTE_CHAR25, vsdl.SRC_ATTRIBUTE_CHAR26 PO_SRC_ATTRIBUTE_CHAR26, vsdl.SRC_ATTRIBUTE_CHAR27 PO_SRC_ATTRIBUTE_CHAR27, vsdl.SRC_ATTRIBUTE_CHAR28 PO_SRC_ATTRIBUTE_CHAR28, vsdl.SRC_ATTRIBUTE_CHAR29 PO_SRC_ATTRIBUTE_CHAR29, vsdl.SRC_ATTRIBUTE_CHAR3 PO_SRC_ATTRIBUTE_CHAR3, vsdl.SRC_ATTRIBUTE_CHAR30 PO_SRC_ATTRIBUTE_CHAR30, vsdl.SRC_ATTRIBUTE_CHAR31 PO_SRC_ATTRIBUTE_CHAR31, vsdl.SRC_ATTRIBUTE_CHAR32 PO_SRC_ATTRIBUTE_CHAR32, vsdl.SRC_ATTRIBUTE_CHAR33 PO_SRC_ATTRIBUTE_CHAR33, vsdl.SRC_ATTRIBUTE_CHAR34 PO_SRC_ATTRIBUTE_CHAR34, vsdl.SRC_ATTRIBUTE_CHAR35 PO_SRC_ATTRIBUTE_CHAR35, vsdl.SRC_ATTRIBUTE_CHAR36 PO_SRC_ATTRIBUTE_CHAR36, vsdl.SRC_ATTRIBUTE_CHAR37 PO_SRC_ATTRIBUTE_CHAR37, vsdl.SRC_ATTRIBUTE_CHAR38 PO_SRC_ATTRIBUTE_CHAR38, vsdl.SRC_ATTRIBUTE_CHAR39 PO_SRC_ATTRIBUTE_CHAR39, vsdl.SRC_ATTRIBUTE_CHAR4 PO_SRC_ATTRIBUTE_CHAR4, vsdl.SRC_ATTRIBUTE_CHAR40 PO_SRC_ATTRIBUTE_CHAR40, vsdl.SRC_ATTRIBUTE_CHAR41 PO_SRC_ATTRIBUTE_CHAR41, vsdl.SRC_ATTRIBUTE_CHAR42 PO_SRC_ATTRIBUTE_CHAR42, vsdl.SRC_ATTRIBUTE_CHAR43 PO_SRC_ATTRIBUTE_CHAR43, vsdl.SRC_ATTRIBUTE_CHAR44 PO_SRC_ATTRIBUTE_CHAR44, vsdl.SRC_ATTRIBUTE_CHAR45 PO_SRC_ATTRIBUTE_CHAR45, vsdl.SRC_ATTRIBUTE_CHAR46 PO_SRC_ATTRIBUTE_CHAR46, vsdl.SRC_ATTRIBUTE_CHAR47 PO_SRC_ATTRIBUTE_CHAR47, vsdl.SRC_ATTRIBUTE_CHAR48 PO_SRC_ATTRIBUTE_CHAR48, vsdl.SRC_ATTRIBUTE_CHAR49 PO_SRC_ATTRIBUTE_CHAR49, vsdl.SRC_ATTRIBUTE_CHAR5 PO_SRC_ATTRIBUTE_CHAR5, vsdl.SRC_ATTRIBUTE_CHAR50 PO_SRC_ATTRIBUTE_CHAR50, vsdl.SRC_ATTRIBUTE_CHAR51 PO_SRC_ATTRIBUTE_CHAR51, vsdl.SRC_ATTRIBUTE_CHAR52 PO_SRC_ATTRIBUTE_CHAR52, vsdl.SRC_ATTRIBUTE_CHAR53 PO_SRC_ATTRIBUTE_CHAR53, vsdl.SRC_ATTRIBUTE_CHAR54 PO_SRC_ATTRIBUTE_CHAR54, vsdl.SRC_ATTRIBUTE_CHAR55 PO_SRC_ATTRIBUTE_CHAR55, vsdl.SRC_ATTRIBUTE_CHAR56 PO_SRC_ATTRIBUTE_CHAR56, vsdl.SRC_ATTRIBUTE_CHAR57 PO_SRC_ATTRIBUTE_CHAR57, vsdl.SRC_ATTRIBUTE_CHAR58 PO_SRC_ATTRIBUTE_CHAR58, vsdl.SRC_ATTRIBUTE_CHAR59 PO_SRC_ATTRIBUTE_CHAR59, vsdl.SRC_ATTRIBUTE_CHAR6 PO_SRC_ATTRIBUTE_CHAR6, vsdl.SRC_ATTRIBUTE_CHAR60 PO_SRC_ATTRIBUTE_CHAR60, vsdl.SRC_ATTRIBUTE_CHAR7 PO_SRC_ATTRIBUTE_CHAR7, vsdl.SRC_ATTRIBUTE_CHAR8 PO_SRC_ATTRIBUTE_CHAR8, vsdl.SRC_ATTRIBUTE_CHAR9 PO_SRC_ATTRIBUTE_CHAR9, vsdl.SRC_ATTRIBUTE_NUMBER1 PO_SRC_ATTRIBUTE_NUMBER1, vsdl.SRC_ATTRIBUTE_NUMBER10 PO_SRC_ATTRIBUTE_NUMBER10, vsdl.SRC_ATTRIBUTE_NUMBER11 PO_SRC_ATTRIBUTE_NUMBER11, vsdl.SRC_ATTRIBUTE_NUMBER12 PO_SRC_ATTRIBUTE_NUMBER12, vsdl.SRC_ATTRIBUTE_NUMBER13 PO_SRC_ATTRIBUTE_NUMBER13, vsdl.SRC_ATTRIBUTE_NUMBER14 PO_SRC_ATTRIBUTE_NUMBER14, vsdl.SRC_ATTRIBUTE_NUMBER15 PO_SRC_ATTRIBUTE_NUMBER15, vsdl.SRC_ATTRIBUTE_NUMBER16 PO_SRC_ATTRIBUTE_NUMBER16, vsdl.SRC_ATTRIBUTE_NUMBER17 PO_SRC_ATTRIBUTE_NUMBER17, vsdl.SRC_ATTRIBUTE_NUMBER18 PO_SRC_ATTRIBUTE_NUMBER18, vsdl.SRC_ATTRIBUTE_NUMBER19 PO_SRC_ATTRIBUTE_NUMBER19, vsdl.SRC_ATTRIBUTE_NUMBER2 PO_SRC_ATTRIBUTE_NUMBER2, vsdl.SRC_ATTRIBUTE_NUMBER20 PO_SRC_ATTRIBUTE_NUMBER20, vsdl.SRC_ATTRIBUTE_NUMBER3 PO_SRC_ATTRIBUTE_NUMBER3, vsdl.SRC_ATTRIBUTE_NUMBER4 PO_SRC_ATTRIBUTE_NUMBER4, vsdl.SRC_ATTRIBUTE_NUMBER5 PO_SRC_ATTRIBUTE_NUMBER5, vsdl.SRC_ATTRIBUTE_NUMBER6 PO_SRC_ATTRIBUTE_NUMBER6, vsdl.SRC_ATTRIBUTE_NUMBER7 PO_SRC_ATTRIBUTE_NUMBER7, vsdl.SRC_ATTRIBUTE_NUMBER8 PO_SRC_ATTRIBUTE_NUMBER8, vsdl.SRC_ATTRIBUTE_NUMBER9 PO_SRC_ATTRIBUTE_NUMBER9, NULL POL_LINE_SATISFACTION_DATE, NULL POL_FIRST_SATIS_EVENT_DATE FROM VRM_XLA_IFRS15_EXTRACT_GT l, VRM_CUSTOMER_CONTRACT_HEADERS vcch, VRM_PERF_OBLIGATIONS vpo, VRM_PERF_OBLIGATION_LIN_DISTS dists, VRM_LOOKUPS lkp, VRM_PERF_OBLIGATION_LINES vpol, VRM_SOURCE_DOC_LINES vsdl, VRM_PRICING_LINES vpl/*, AR_LOOKUPS ar_lookups bug: 29368758*/ WHERE l.LEVEL_CODE = 'L' AND l.EVENT_TYPE_CODE IN ('REV_INITIAL_PERF', 'RESIDUAL_BAL_ADJ') AND vcch.CUSTOMER_CONTRACT_HEADER_ID = l.CUSTOMER_CONTRACT_HEADER_ID AND dists.PERF_OBLIGATION_LINE_DIST_ID = l.PERF_OBLIGATION_LINE_DIST_ID AND vpo.PERF_OBLIGATION_ID = l.PERF_OBLIGATION_ID AND lkp.lookup_code = vpo.PERF_OBLIGATION_TYPE AND lkp.lookup_type = 'ORA_VRM_PERF_OBLIGATION_TYPE' AND vpol.PERF_OBLIGATION_ID = vpo.PERF_OBLIGATION_ID AND vpol.PERF_OBLIGATION_LINE_NUMBER = 1 AND vsdl.DOCUMENT_LINE_ID = vpol.DOCUMENT_LINE_ID AND vsdl.DOCUMENT_LINE_ID = vpl.DOCUMENT_LINE_ID AND EXISTS (SELECT 'X' FROM AR_LOOKUPS ar_lookups WHERE 1=1 AND ar_lookups.lookup_type = 'ORA_AR_FEATURES' AND ar_lookups.lookup_code = 'VRM_IPE_ACCT_DERIVATION' AND ar_lookups.enabled_flag = 'Y') UNION ALL /*This SQL will be used when there is discount entry at contract level with oblig id as -9999 It has added as a part of CRAB feature and CRAB will be allowed only when there is IMM temormination to one of line in contract. As of now, DIST_AMOUNT and DIST_ACCTD_AMOUNT are getting populated with ledger currency values. */ SELECT /*+ cardinality(l 2) LEADING(l) INDEX(l VRM_XLA_IFRS15_EXTRACT_GT_N1) INDEX(dists VRM_PERF_OBLIG_LIN_DIST_U1) INDEX(vcch VRM_CUST_CONTRACT_HDRS_U1) */ l.PERF_OBLIGATION_LINE_DIST_ID PERF_OBLIGATION_LINE_DIST_ID , NULL H_SRC_ATTRIBUTE_CATEGORY , NULL H_SRC_ATTRIBUTE_CHAR1 , NULL H_SRC_ATTRIBUTE_CHAR10 , NULL H_SRC_ATTRIBUTE_CHAR11 , NULL H_SRC_ATTRIBUTE_CHAR12 , NULL H_SRC_ATTRIBUTE_CHAR13 , NULL H_SRC_ATTRIBUTE_CHAR14 , NULL H_SRC_ATTRIBUTE_CHAR15 , NULL H_SRC_ATTRIBUTE_CHAR16 , NULL H_SRC_ATTRIBUTE_CHAR17 , NULL H_SRC_ATTRIBUTE_CHAR18 , NULL H_SRC_ATTRIBUTE_CHAR19 , NULL H_SRC_ATTRIBUTE_CHAR2 , NULL H_SRC_ATTRIBUTE_CHAR20 , NULL H_SRC_ATTRIBUTE_CHAR21 , NULL H_SRC_ATTRIBUTE_CHAR22 , NULL H_SRC_ATTRIBUTE_CHAR23 , NULL H_SRC_ATTRIBUTE_CHAR24 , NULL H_SRC_ATTRIBUTE_CHAR25 , NULL H_SRC_ATTRIBUTE_CHAR26 , NULL H_SRC_ATTRIBUTE_CHAR27 , NULL H_SRC_ATTRIBUTE_CHAR28 , NULL H_SRC_ATTRIBUTE_CHAR29 , NULL H_SRC_ATTRIBUTE_CHAR3 , NULL H_SRC_ATTRIBUTE_CHAR30 , NULL H_SRC_ATTRIBUTE_CHAR31 , NULL H_SRC_ATTRIBUTE_CHAR32 , NULL H_SRC_ATTRIBUTE_CHAR33 , NULL H_SRC_ATTRIBUTE_CHAR34 , NULL H_SRC_ATTRIBUTE_CHAR35 , NULL H_SRC_ATTRIBUTE_CHAR36 , NULL H_SRC_ATTRIBUTE_CHAR37 , NULL H_SRC_ATTRIBUTE_CHAR38 , NULL H_SRC_ATTRIBUTE_CHAR39 , NULL H_SRC_ATTRIBUTE_CHAR4 , NULL H_SRC_ATTRIBUTE_CHAR40 , NULL H_SRC_ATTRIBUTE_CHAR41 , NULL H_SRC_ATTRIBUTE_CHAR42 , NULL H_SRC_ATTRIBUTE_CHAR43 , NULL H_SRC_ATTRIBUTE_CHAR44 , NULL H_SRC_ATTRIBUTE_CHAR45 , NULL H_SRC_ATTRIBUTE_CHAR46 , NULL H_SRC_ATTRIBUTE_CHAR47 , NULL H_SRC_ATTRIBUTE_CHAR48 , NULL H_SRC_ATTRIBUTE_CHAR49 , NULL H_SRC_ATTRIBUTE_CHAR5 , NULL H_SRC_ATTRIBUTE_CHAR50 , NULL H_SRC_ATTRIBUTE_CHAR51 , NULL H_SRC_ATTRIBUTE_CHAR52 , NULL H_SRC_ATTRIBUTE_CHAR53 , NULL H_SRC_ATTRIBUTE_CHAR54 , NULL H_SRC_ATTRIBUTE_CHAR55 , NULL H_SRC_ATTRIBUTE_CHAR56 , NULL H_SRC_ATTRIBUTE_CHAR57 , NULL H_SRC_ATTRIBUTE_CHAR58 , NULL H_SRC_ATTRIBUTE_CHAR59 , NULL H_SRC_ATTRIBUTE_CHAR6 , NULL H_SRC_ATTRIBUTE_CHAR60 , NULL H_SRC_ATTRIBUTE_CHAR7 , NULL H_SRC_ATTRIBUTE_CHAR8 , NULL H_SRC_ATTRIBUTE_CHAR9 , NULL PERF_OBLIG_ATTRIBUTE_CATEGORY , NULL PERF_OBLIG_ATTRIBUTE1 , NULL PERF_OBLIG_ATTRIBUTE10 , NULL PERF_OBLIG_ATTRIBUTE11 , NULL PERF_OBLIG_ATTRIBUTE12 , NULL PERF_OBLIG_ATTRIBUTE13 , NULL PERF_OBLIG_ATTRIBUTE14 , NULL PERF_OBLIG_ATTRIBUTE15 , NULL PERF_OBLIG_ATTRIBUTE16 , NULL PERF_OBLIG_ATTRIBUTE17 , NULL PERF_OBLIG_ATTRIBUTE18 , NULL PERF_OBLIG_ATTRIBUTE19 , NULL PERF_OBLIG_ATTRIBUTE2 , NULL PERF_OBLIG_ATTRIBUTE20 , NULL PERF_OBLIG_ATTRIBUTE3 , NULL PERF_OBLIG_ATTRIBUTE4 , NULL PERF_OBLIG_ATTRIBUTE5 , NULL PERF_OBLIG_ATTRIBUTE6 , NULL PERF_OBLIG_ATTRIBUTE7 , NULL PERF_OBLIG_ATTRIBUTE8 , NULL PERF_OBLIG_ATTRIBUTE9 , NULL SRC_DOC_HEADER_TYPE , NULL DOCUMENT_TYPE_NAME , vcch.CONTRACT_CURRENCY_CODE SRC_DOC_CURRENCY_CODE , /*Enh 28337021 : Currency needs to be corrected when we support foreign currency IMM changes. vpo.OBLIG_CURRENCY_CODE SRC_DOC_CURRENCY_CODE , vsd.DOCUMENT_DATE C_DOCUMENT_DATE , Moved to header as contract date*/ NUll PERFORMANCE_OBLIGATION_NUMBER , NUll REVISION_INTENT_OBLIGATION, dists.EXCHANGE_RATE DIST_EXCHANGE_RATE , dists.EXCHANGE_RATE_DATE DIST_EXCHANGE_RATE_DATE , dists.EXCHANGE_RATE_TYPE DIST_EXCHANGE_RATE_TYPE , NULL LEGAL_ENTITY_NAME , NULL SRC_DOC_DATE , NULL SRC_DOC_NUMBER , NULL BUSINESS_UNIT_NAME , dists.ACCOUNT_CLASS DIST_ACCOUNT_CLASS , dists.ACCOUNTING_DATE DIST_ACCOUNTING_DATE , ((CASE WHEN dists.ACCOUNT_CLASS = 'ORA_REV' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_REV_CLR' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_CL' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_CA' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_DISC_CLR' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_PRICE_VAR' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_REV_WRITE_OFF' THEN 1 ELSE 1 END ) * dists.ACCTD_AMOUNT) DIST_ACCTD_AMOUNT , ((CASE WHEN dists.ACCOUNT_CLASS = 'ORA_REV' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_REV_CLR' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_CL' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_CA' THEN -1 WHEN dists.ACCOUNT_CLASS = 'ORA_DISC_CLR' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_PRICE_VAR' THEN 1 WHEN dists.ACCOUNT_CLASS = 'ORA_REV_WRITE_OFF' THEN 1 ELSE 1 END ) * dists.ACCTD_AMOUNT) DIST_AMOUNT , NULL PERF_OBLIG_LINE_ATTR_CATEGORY , NULL PERF_OBLIG_LINE_ATTRIBUTE1 , NULL PERF_OBLIG_LINE_ATTRIBUTE10 , NULL PERF_OBLIG_LINE_ATTRIBUTE11 , NULL PERF_OBLIG_LINE_ATTRIBUTE12 , NULL PERF_OBLIG_LINE_ATTRIBUTE13 , NULL PERF_OBLIG_LINE_ATTRIBUTE14 , NULL PERF_OBLIG_LINE_ATTRIBUTE15 , NULL PERF_OBLIG_LINE_ATTRIBUTE16 , NULL PERF_OBLIG_LINE_ATTRIBUTE17 , NULL PERF_OBLIG_LINE_ATTRIBUTE18 , NULL PERF_OBLIG_LINE_ATTRIBUTE19 , NULL PERF_OBLIG_LINE_ATTRIBUTE2 , NULL PERF_OBLIG_LINE_ATTRIBUTE20 , NULL PERF_OBLIG_LINE_ATTRIBUTE3 , NULL PERF_OBLIG_LINE_ATTRIBUTE4 , NULL PERF_OBLIG_LINE_ATTRIBUTE5 , NULL PERF_OBLIG_LINE_ATTRIBUTE6 , NULL PERF_OBLIG_LINE_ATTRIBUTE7 , NULL PERF_OBLIG_LINE_ATTRIBUTE8 , NULL PERF_OBLIG_LINE_ATTRIBUTE9 , NULL POL_REVENUE_RULE_NAME , NULL SOURCE_DOCUMENT_LINE_NUMBER , NULL L_SRC_ATTRIBUTE_CATEGORY , NULL L_SRC_ATTRIBUTE_CHAR1 , NULL L_SRC_ATTRIBUTE_CHAR10 , NULL L_SRC_ATTRIBUTE_CHAR11 , NULL L_SRC_ATTRIBUTE_CHAR12 , NULL L_SRC_ATTRIBUTE_CHAR13 , NULL L_SRC_ATTRIBUTE_CHAR14 , NULL L_SRC_ATTRIBUTE_CHAR15 , NULL L_SRC_ATTRIBUTE_CHAR16 , NULL L_SRC_ATTRIBUTE_CHAR17 , NULL L_SRC_ATTRIBUTE_CHAR18 , NULL L_SRC_ATTRIBUTE_CHAR19 , NULL L_SRC_ATTRIBUTE_CHAR2 , NULL L_SRC_ATTRIBUTE_CHAR20 , NULL L_SRC_ATTRIBUTE_CHAR21 , NULL L_SRC_ATTRIBUTE_CHAR22 , NULL L_SRC_ATTRIBUTE_CHAR23 , NULL L_SRC_ATTRIBUTE_CHAR24 , NULL L_SRC_ATTRIBUTE_CHAR25 , NULL L_SRC_ATTRIBUTE_CHAR26 , NULL L_SRC_ATTRIBUTE_CHAR27 , NULL L_SRC_ATTRIBUTE_CHAR28 , NULL L_SRC_ATTRIBUTE_CHAR29 , NULL L_SRC_ATTRIBUTE_CHAR3 , NULL L_SRC_ATTRIBUTE_CHAR30 , NULL L_SRC_ATTRIBUTE_CHAR31 , NULL L_SRC_ATTRIBUTE_CHAR32 , NULL L_SRC_ATTRIBUTE_CHAR33 , NULL L_SRC_ATTRIBUTE_CHAR34 , NULL L_SRC_ATTRIBUTE_CHAR35 , NULL L_SRC_ATTRIBUTE_CHAR36 , NULL L_SRC_ATTRIBUTE_CHAR37 , NULL L_SRC_ATTRIBUTE_CHAR38 , NULL L_SRC_ATTRIBUTE_CHAR39 , NULL L_SRC_ATTRIBUTE_CHAR4 , NULL L_SRC_ATTRIBUTE_CHAR40 , NULL L_SRC_ATTRIBUTE_CHAR41 , NULL L_SRC_ATTRIBUTE_CHAR42 , NULL L_SRC_ATTRIBUTE_CHAR43 , NULL L_SRC_ATTRIBUTE_CHAR44 , NULL L_SRC_ATTRIBUTE_CHAR45 , NULL L_SRC_ATTRIBUTE_CHAR46 , NULL L_SRC_ATTRIBUTE_CHAR47 , NULL L_SRC_ATTRIBUTE_CHAR48 , NULL L_SRC_ATTRIBUTE_CHAR49 , NULL L_SRC_ATTRIBUTE_CHAR5 , NULL L_SRC_ATTRIBUTE_CHAR50 , NULL L_SRC_ATTRIBUTE_CHAR51 , NULL L_SRC_ATTRIBUTE_CHAR52 , NULL L_SRC_ATTRIBUTE_CHAR53 , NULL L_SRC_ATTRIBUTE_CHAR54 , NULL L_SRC_ATTRIBUTE_CHAR55 , NULL L_SRC_ATTRIBUTE_CHAR56 , NULL L_SRC_ATTRIBUTE_CHAR57 , NULL L_SRC_ATTRIBUTE_CHAR58 , NULL L_SRC_ATTRIBUTE_CHAR59 , NULL L_SRC_ATTRIBUTE_CHAR6 , NULL L_SRC_ATTRIBUTE_CHAR60 , NULL L_SRC_ATTRIBUTE_CHAR7 , NULL L_SRC_ATTRIBUTE_CHAR8 , NULL L_SRC_ATTRIBUTE_CHAR9 , NULL PERF_OBLIG_LINE_NUMBER , NULL REVISION_INTENT_OBLIG_LINE, NULL PERFORMANCE_OBLIGATION_TYPE , NULL SRC_DOC_LINE_TYPE , l.EVENT_ID EVENT_ID , l.ledger_id LEDGER_ID , l.LINE_NUMBER LINE_NUMBER, NULL CONTRACT_REVENUE_CLEARING_CCID, NULL REVENUE_SPLIT_REV_CCID, dists.TRANSFER_TO_GL_FLAG TRANSFER_TO_GL, NULL DEVOLVE_PO_FLAG, NULL OBLIGATION_REFERENCE, NULL PERF_OBLIG_CLASSIFICATION_CODE, NULL as PO_RESIDUAL_APPROACH_FLAG, NULL as POL_RESIDUAL_APPROACH_FLAG, NULL FOREIGN_CURR_TREATMENT_CODE, NULL PO_MEMO_LINE_NAME, NULL PO_CUST_PO_NUMBER, NULL PO_DOCUMENT_LINE_ID, NULL PO_ELEMENT_TYPE, NULL PO_ITEM_NUMBER, NULL PO_SRC_ATTRIBUTE_CHAR1, NULL PO_SRC_ATTRIBUTE_CHAR10, NULL PO_SRC_ATTRIBUTE_CHAR11, NULL PO_SRC_ATTRIBUTE_CHAR12, NULL PO_SRC_ATTRIBUTE_CHAR13, NULL PO_SRC_ATTRIBUTE_CHAR14, NULL PO_SRC_ATTRIBUTE_CHAR15, NULL PO_SRC_ATTRIBUTE_CHAR16, NULL PO_SRC_ATTRIBUTE_CHAR17, NULL PO_SRC_ATTRIBUTE_CHAR18, NULL PO_SRC_ATTRIBUTE_CHAR19, NULL PO_SRC_ATTRIBUTE_CHAR2, NULL PO_SRC_ATTRIBUTE_CHAR20, NULL PO_SRC_ATTRIBUTE_CHAR21, NULL PO_SRC_ATTRIBUTE_CHAR22, NULL PO_SRC_ATTRIBUTE_CHAR23, NULL PO_SRC_ATTRIBUTE_CHAR24, NULL PO_SRC_ATTRIBUTE_CHAR25, NULL PO_SRC_ATTRIBUTE_CHAR26, NULL PO_SRC_ATTRIBUTE_CHAR27, NULL PO_SRC_ATTRIBUTE_CHAR28, NULL PO_SRC_ATTRIBUTE_CHAR29, NULL PO_SRC_ATTRIBUTE_CHAR3, NULL PO_SRC_ATTRIBUTE_CHAR30, NULL PO_SRC_ATTRIBUTE_CHAR31, NULL PO_SRC_ATTRIBUTE_CHAR32, NULL PO_SRC_ATTRIBUTE_CHAR33, NULL PO_SRC_ATTRIBUTE_CHAR34, NULL PO_SRC_ATTRIBUTE_CHAR35, NULL PO_SRC_ATTRIBUTE_CHAR36, NULL PO_SRC_ATTRIBUTE_CHAR37, NULL PO_SRC_ATTRIBUTE_CHAR38, NULL PO_SRC_ATTRIBUTE_CHAR39, NULL PO_SRC_ATTRIBUTE_CHAR4, NULL PO_SRC_ATTRIBUTE_CHAR40, NULL PO_SRC_ATTRIBUTE_CHAR41, NULL PO_SRC_ATTRIBUTE_CHAR42, NULL PO_SRC_ATTRIBUTE_CHAR43, NULL PO_SRC_ATTRIBUTE_CHAR44, NULL PO_SRC_ATTRIBUTE_CHAR45, NULL PO_SRC_ATTRIBUTE_CHAR46, NULL PO_SRC_ATTRIBUTE_CHAR47, NULL PO_SRC_ATTRIBUTE_CHAR48, NULL PO_SRC_ATTRIBUTE_CHAR49, NULL PO_SRC_ATTRIBUTE_CHAR5, NULL PO_SRC_ATTRIBUTE_CHAR50, NULL PO_SRC_ATTRIBUTE_CHAR51, NULL PO_SRC_ATTRIBUTE_CHAR52, NULL PO_SRC_ATTRIBUTE_CHAR53, NULL PO_SRC_ATTRIBUTE_CHAR54, NULL PO_SRC_ATTRIBUTE_CHAR55, NULL PO_SRC_ATTRIBUTE_CHAR56, NULL PO_SRC_ATTRIBUTE_CHAR57, NULL PO_SRC_ATTRIBUTE_CHAR58, NULL PO_SRC_ATTRIBUTE_CHAR59, NULL PO_SRC_ATTRIBUTE_CHAR6, NULL PO_SRC_ATTRIBUTE_CHAR60, NULL PO_SRC_ATTRIBUTE_CHAR7, NULL PO_SRC_ATTRIBUTE_CHAR8, NULL PO_SRC_ATTRIBUTE_CHAR9, NULL PO_SRC_ATTRIBUTE_NUMBER1, NULL PO_SRC_ATTRIBUTE_NUMBER10, NULL PO_SRC_ATTRIBUTE_NUMBER11, NULL PO_SRC_ATTRIBUTE_NUMBER12, NULL PO_SRC_ATTRIBUTE_NUMBER13, NULL PO_SRC_ATTRIBUTE_NUMBER14, NULL PO_SRC_ATTRIBUTE_NUMBER15, NULL PO_SRC_ATTRIBUTE_NUMBER16, NULL PO_SRC_ATTRIBUTE_NUMBER17, NULL PO_SRC_ATTRIBUTE_NUMBER18, NULL PO_SRC_ATTRIBUTE_NUMBER19, NULL PO_SRC_ATTRIBUTE_NUMBER2, NULL PO_SRC_ATTRIBUTE_NUMBER20, NULL PO_SRC_ATTRIBUTE_NUMBER3, NULL PO_SRC_ATTRIBUTE_NUMBER4, NULL PO_SRC_ATTRIBUTE_NUMBER5, NULL PO_SRC_ATTRIBUTE_NUMBER6, NULL PO_SRC_ATTRIBUTE_NUMBER7, NULL PO_SRC_ATTRIBUTE_NUMBER8, NULL PO_SRC_ATTRIBUTE_NUMBER9, NULL POL_LINE_SATISFACTION_DATE, NULL POL_FIRST_SATIS_EVENT_DATE FROM VRM_XLA_IFRS15_EXTRACT_GT l, VRM_CUSTOMER_CONTRACT_HEADERS vcch, VRM_PERF_OBLIGATION_LIN_DISTS dists WHERE l.LEVEL_CODE = 'L' AND l.EVENT_TYPE_CODE = 'RESIDUAL_BAL_ADJ' AND vcch.CUSTOMER_CONTRACT_HEADER_ID = l.CUSTOMER_CONTRACT_HEADER_ID AND dists.PERF_OBLIGATION_LINE_DIST_ID = l.PERF_OBLIGATION_LINE_DIST_ID AND dists.PERF_OBLIGATION_ID = -9999