View: AR_RECEIVABLE_APPS_L_V

Product:	AR - Receivables
Description:	receivable application line extract
Implementation/DBA Data:	APPS.AR_RECEIVABLE_APPS_L_V

View Text

SELECT /*+ INDEX(LI AR_XLA_LINES_EXTRACT_N1) */ RAA.RECEIVABLE_APPLICATION_ID APP_APPLICATION_ID
, RAA.APPLICATION_REF_NUM APP_APPLICATION_REF_NUM
, RAA.APPLICATION_REF_TYPE APP_APPLICATION_REF_TYPE
, RAA.APPLICATION_TYPE APP_APPLICATION_TYPE
, RAA.APPLY_DATE APP_APPLY_DATE
, RAA.CODE_COMBINATION_ID APP_CODE_COMBINATION_ID
, RAA.COMMENTS APP_COMMENTS
, RAA.CONFIRMED_FLAG APP_CONFIRMED_FLAG
, RAA.EARNED_DISCOUNT_CCID APP_EARNED_DISCOUNT_CCID
, RAA.EDISC_TAX_ACCT_RULE APP_EDISC_TAX_ACCT_RULE
, RAA.GL_DATE APP_GL_DATE
, RAA.REVERSAL_GL_DATE APP_REVERSAL_GL_DATE
, RAA.STATUS APP_STATUS
, RAA.TAX_CODE APP_TAX_CODE
, RAA.TRANS_TO_RECEIPT_RATE APP_TRANS_TO_RECEIPT_RATE
, RAA.UNEARNED_DISCOUNT_CCID APP_UNEARNED_DISCOUNT_CCID
, RAA.UNEDISC_TAX_ACCT_RULE APP_UNEDISC_TAX_ACCT_RULE
, RAA.APPLICATION_REF_REASON APP_APPLICATION_REF_REASON
, RAA.ATTRIBUTE1 APP_ATTR1
, RAA.ATTRIBUTE10 APP_ATTR10
, RAA.ATTRIBUTE11 APP_ATTR11
, RAA.ATTRIBUTE12 APP_ATTR12
, RAA.ATTRIBUTE13 APP_ATTR13
, RAA.ATTRIBUTE14 APP_ATTR14
, RAA.ATTRIBUTE15 APP_ATTR15
, RAA.ATTRIBUTE2 APP_ATTR2
, RAA.ATTRIBUTE3 APP_ATTR3
, RAA.ATTRIBUTE4 APP_ATTR4
, RAA.ATTRIBUTE5 APP_ATTR5
, RAA.ATTRIBUTE6 APP_ATTR6
, RAA.ATTRIBUTE7 APP_ATTR7
, RAA.ATTRIBUTE8 APP_ATTR8
, RAA.ATTRIBUTE9 APP_ATTR9
, RAA.ATTRIBUTE_CATEGORY APP_ATTR_CAT
, RAA.GLOBAL_ATTRIBUTE1 APP_GLOBAL_ATTR1
, RAA.GLOBAL_ATTRIBUTE10 APP_GLOBAL_ATTR10
, RAA.GLOBAL_ATTRIBUTE11 APP_GLOBAL_ATTR11
, RAA.GLOBAL_ATTRIBUTE2 APP_GLOBAL_ATTR2
, RAA.GLOBAL_ATTRIBUTE3 APP_GLOBAL_ATTR3
, RAA.GLOBAL_ATTRIBUTE4 APP_GLOBAL_ATTR4
, RAA.GLOBAL_ATTRIBUTE5 APP_GLOBAL_ATTR5
, RAA.GLOBAL_ATTRIBUTE6 APP_GLOBAL_ATTR6
, RAA.GLOBAL_ATTRIBUTE7 APP_GLOBAL_ATTR7
, RAA.GLOBAL_ATTRIBUTE8 APP_GLOBAL_ATTR8
, RAA.GLOBAL_ATTRIBUTE9 APP_GLOBAL_ATTR9
, RAA.GLOBAL_ATTRIBUTE_CATEGORY APP_GLOBAL_ATTR_CAT
, RAA.USSGL_TRANSACTION_CODE APP_USSGL_TRX_CODE
, RAA.USSGL_TRANSACTION_CODE_CONTEXT APP_USSGL_TRX_CODE_CT
, LI.EVENT_ID EVENT_ID
, 'C' XLA_PARTY_TYPE
, LI.CRH_STATUS APP_CRH_STATUS
, LI.LINE_NUMBER LINE_NUMBER
, LI.LANGUAGE LANGUAGE
, LI.LEDGER_ID LEDGER_ID
FROM AR_XLA_LINES_EXTRACT LI
, AR_RECEIVABLE_APPLICATIONS_ALL RAA
WHERE LI.EVENT_ID = RAA.EVENT_ID
AND LI.SOURCE_ID = RAA.RECEIVABLE_APPLICATION_ID
AND LI.LEVEL_FLAG = 'L'
AND LI.POSTING_ENTITY = 'CRH'
AND LI.SOURCE_TABLE = 'RA'
AND LI.MFAR_ADDITIONAL_ENTRY = 'N' UNION /******************************************* * RA CLASSIFIED UNDER POSTING ENTITY APP * *******************************************/ SELECT /*+ INDEX(LICR AR_XLA_LINES_EXTRACT_N1) INDEX(LITRX AR_XLA_LINES_EXTRACT_N1)*/ RAA.RECEIVABLE_APPLICATION_ID APP_APPLICATION_ID
, RAA.APPLICATION_REF_NUM APP_APPLICATION_REF_NUM
, RAA.APPLICATION_REF_TYPE APP_APPLICATION_REF_TYPE
, RAA.APPLICATION_TYPE APP_APPLICATION_TYPE
, RAA.APPLY_DATE APP_APPLY_DATE
, RAA.CODE_COMBINATION_ID APP_CODE_COMBINATION_ID
, RAA.COMMENTS APP_COMMENTS
, RAA.CONFIRMED_FLAG APP_CONFIRMED_FLAG
, RAA.EARNED_DISCOUNT_CCID APP_EARNED_DISCOUNT_CCID
, RAA.EDISC_TAX_ACCT_RULE APP_EDISC_TAX_ACCT_RULE
, RAA.GL_DATE APP_GL_DATE
, RAA.REVERSAL_GL_DATE APP_REVERSAL_GL_DATE
, RAA.STATUS APP_STATUS
, RAA.TAX_CODE APP_TAX_CODE
, RAA.TRANS_TO_RECEIPT_RATE APP_TRANS_TO_RECEIPT_RATE
, RAA.UNEARNED_DISCOUNT_CCID APP_UNEARNED_DISCOUNT_CCID
, RAA.UNEDISC_TAX_ACCT_RULE APP_UNEDISC_TAX_ACCT_RULE
, RAA.APPLICATION_REF_REASON APP_APPLICATION_REF_REASON
, RAA.ATTRIBUTE1 APP_ATTR1
, RAA.ATTRIBUTE10 APP_ATTR10
, RAA.ATTRIBUTE11 APP_ATTR11
, RAA.ATTRIBUTE12 APP_ATTR12
, RAA.ATTRIBUTE13 APP_ATTR13
, RAA.ATTRIBUTE14 APP_ATTR14
, RAA.ATTRIBUTE15 APP_ATTR15
, RAA.ATTRIBUTE2 APP_ATTR2
, RAA.ATTRIBUTE3 APP_ATTR3
, RAA.ATTRIBUTE4 APP_ATTR4
, RAA.ATTRIBUTE5 APP_ATTR5
, RAA.ATTRIBUTE6 APP_ATTR6
, RAA.ATTRIBUTE7 APP_ATTR7
, RAA.ATTRIBUTE8 APP_ATTR8
, RAA.ATTRIBUTE9 APP_ATTR9
, RAA.ATTRIBUTE_CATEGORY APP_ATTR_CAT
, RAA.GLOBAL_ATTRIBUTE1 APP_GLOBAL_ATTR1
, RAA.GLOBAL_ATTRIBUTE10 APP_GLOBAL_ATTR10
, RAA.GLOBAL_ATTRIBUTE11 APP_GLOBAL_ATTR11
, RAA.GLOBAL_ATTRIBUTE2 APP_GLOBAL_ATTR2
, RAA.GLOBAL_ATTRIBUTE3 APP_GLOBAL_ATTR3
, RAA.GLOBAL_ATTRIBUTE4 APP_GLOBAL_ATTR4
, RAA.GLOBAL_ATTRIBUTE5 APP_GLOBAL_ATTR5
, RAA.GLOBAL_ATTRIBUTE6 APP_GLOBAL_ATTR6
, RAA.GLOBAL_ATTRIBUTE7 APP_GLOBAL_ATTR7
, RAA.GLOBAL_ATTRIBUTE8 APP_GLOBAL_ATTR8
, RAA.GLOBAL_ATTRIBUTE9 APP_GLOBAL_ATTR9
, RAA.GLOBAL_ATTRIBUTE_CATEGORY APP_GLOBAL_ATTR_CAT
, RAA.USSGL_TRANSACTION_CODE APP_USSGL_TRX_CODE
, RAA.USSGL_TRANSACTION_CODE_CONTEXT APP_USSGL_TRX_CODE_CT
, LICR.EVENT_ID EVENT_ID
, 'C' XLA_PARTY_TYPE
, LICR.CRH_STATUS APP_CRH_STATUS
, LICR.LINE_NUMBER LINE_NUMBER
, LICR.LANGUAGE LANGUAGE
, LICR.LEDGER_ID LEDGER_ID
FROM AR_XLA_LINES_EXTRACT LICR
, AR_XLA_LINES_EXTRACT LITRX
, AR_RECEIVABLE_APPLICATIONS_ALL RAA
WHERE LICR.EVENT_ID = RAA.EVENT_ID
AND LICR.SOURCE_ID = RAA.RECEIVABLE_APPLICATION_ID
AND LICR.POSTING_ENTITY = 'APP'
AND LICR.LEVEL_FLAG = 'L'
AND LICR.CASH_RECEIPT_ID IS NOT NULL
AND LICR.CUSTOMER_TRX_ID IS NULL
AND LICR.FROM_TO_FLAG = 'F'
AND LITRX.POSTING_ENTITY = 'APP'
AND LITRX.LEVEL_FLAG = 'L'
AND LITRX.CASH_RECEIPT_ID IS NULL
AND LITRX.CUSTOMER_TRX_ID IS NOT NULL
AND LITRX.FROM_TO_FLAG = 'T'
AND LICR.HEADER_TABLE_ID = LITRX.HEADER_TABLE_ID
AND LICR.EVENT_ID = LITRX.EVENT_ID
AND LICR.LINE_ID = LITRX.LINE_ID
AND LICR.EVENT_TYPE_CODE IN ('RECP_CREATE'
, 'RECP_UPDATE'
, 'RECP_RATE_ADJUST'
, 'RECP_REVERSE')
AND NVL(LICR.ADDITIONAL_CHAR1
, 'XX') <> 'R12_11ICASH_POST'
AND NVL(LITRX.ADDITIONAL_CHAR1
, 'XX') <> 'R12_11ICASH_POST'
AND LICR.MFAR_ADDITIONAL_ENTRY = 'N'
AND LITRX.MFAR_ADDITIONAL_ENTRY = 'N' UNION /******************** * CM APP DOC * ********************/ SELECT /*+ INDEX(LI AR_XLA_LINES_EXTRACT_N1) */ RAA.RECEIVABLE_APPLICATION_ID APP_APPLICATION_ID
, RAA.APPLICATION_REF_NUM APP_APPLICATION_REF_NUM
, RAA.APPLICATION_REF_TYPE APP_APPLICATION_REF_TYPE
, RAA.APPLICATION_TYPE APP_APPLICATION_TYPE
, RAA.APPLY_DATE APP_APPLY_DATE
, RAA.CODE_COMBINATION_ID APP_CODE_COMBINATION_ID
, RAA.COMMENTS APP_COMMENTS
, RAA.CONFIRMED_FLAG APP_CONFIRMED_FLAG
, RAA.EARNED_DISCOUNT_CCID APP_EARNED_DISCOUNT_CCID
, RAA.EDISC_TAX_ACCT_RULE APP_EDISC_TAX_ACCT_RULE
, RAA.GL_DATE APP_GL_DATE
, RAA.REVERSAL_GL_DATE APP_REVERSAL_GL_DATE
, RAA.STATUS APP_STATUS
, RAA.TAX_CODE APP_TAX_CODE
, RAA.TRANS_TO_RECEIPT_RATE APP_TRANS_TO_RECEIPT_RATE
, RAA.UNEARNED_DISCOUNT_CCID APP_UNEARNED_DISCOUNT_CCID
, RAA.UNEDISC_TAX_ACCT_RULE APP_UNEDISC_TAX_ACCT_RULE
, RAA.APPLICATION_REF_REASON APP_APPLICATION_REF_REASON
, RAA.ATTRIBUTE1 APP_ATTR1
, RAA.ATTRIBUTE10 APP_ATTR10
, RAA.ATTRIBUTE11 APP_ATTR11
, RAA.ATTRIBUTE12 APP_ATTR12
, RAA.ATTRIBUTE13 APP_ATTR13
, RAA.ATTRIBUTE14 APP_ATTR14
, RAA.ATTRIBUTE15 APP_ATTR15
, RAA.ATTRIBUTE2 APP_ATTR2
, RAA.ATTRIBUTE3 APP_ATTR3
, RAA.ATTRIBUTE4 APP_ATTR4
, RAA.ATTRIBUTE5 APP_ATTR5
, RAA.ATTRIBUTE6 APP_ATTR6
, RAA.ATTRIBUTE7 APP_ATTR7
, RAA.ATTRIBUTE8 APP_ATTR8
, RAA.ATTRIBUTE9 APP_ATTR9
, RAA.ATTRIBUTE_CATEGORY APP_ATTR_CAT
, RAA.GLOBAL_ATTRIBUTE1 APP_GLOBAL_ATTR1
, RAA.GLOBAL_ATTRIBUTE10 APP_GLOBAL_ATTR10
, RAA.GLOBAL_ATTRIBUTE11 APP_GLOBAL_ATTR11
, RAA.GLOBAL_ATTRIBUTE2 APP_GLOBAL_ATTR2
, RAA.GLOBAL_ATTRIBUTE3 APP_GLOBAL_ATTR3
, RAA.GLOBAL_ATTRIBUTE4 APP_GLOBAL_ATTR4
, RAA.GLOBAL_ATTRIBUTE5 APP_GLOBAL_ATTR5
, RAA.GLOBAL_ATTRIBUTE6 APP_GLOBAL_ATTR6
, RAA.GLOBAL_ATTRIBUTE7 APP_GLOBAL_ATTR7
, RAA.GLOBAL_ATTRIBUTE8 APP_GLOBAL_ATTR8
, RAA.GLOBAL_ATTRIBUTE9 APP_GLOBAL_ATTR9
, RAA.GLOBAL_ATTRIBUTE_CATEGORY APP_GLOBAL_ATTR_CAT
, RAA.USSGL_TRANSACTION_CODE APP_USSGL_TRX_CODE
, RAA.USSGL_TRANSACTION_CODE_CONTEXT APP_USSGL_TRX_CODE_CT
, LI.EVENT_ID EVENT_ID
, 'C' XLA_PARTY_TYPE
, LI.CRH_STATUS APP_CRH_STATUS
, LI.LINE_NUMBER LINE_NUMBER
, LI.LANGUAGE LANGUAGE
, LI.LEDGER_ID LEDGER_ID
FROM AR_XLA_LINES_EXTRACT LI
, AR_RECEIVABLE_APPLICATIONS_ALL RAA
WHERE LI.EVENT_ID = RAA.EVENT_ID
AND LI.SOURCE_ID = RAA.RECEIVABLE_APPLICATION_ID
AND LI.POSTING_ENTITY = 'APP'
AND LI.LEVEL_FLAG = 'L'
AND LI.CUSTOMER_TRX_ID IS NOT NULL
AND LI.FROM_TO_FLAG = 'F'
AND LI.EVENT_TYPE_CODE IN ('CM_CREATE'
, 'CM_UPDATE')
AND NVL(LI.ADDITIONAL_CHAR1
, 'XX') <> 'R12_11ICASH_POST'
AND LI.MFAR_ADDITIONAL_ENTRY = 'N' UNION SELECT /*+ INDEX(LI AR_XLA_LINES_EXTRACT_N1) */ RAA.RECEIVABLE_APPLICATION_ID APP_APPLICATION_ID
, RAA.APPLICATION_REF_NUM APP_APPLICATION_REF_NUM
, RAA.APPLICATION_REF_TYPE APP_APPLICATION_REF_TYPE
, RAA.APPLICATION_TYPE APP_APPLICATION_TYPE
, RAA.APPLY_DATE APP_APPLY_DATE
, RAA.CODE_COMBINATION_ID APP_CODE_COMBINATION_ID
, RAA.COMMENTS APP_COMMENTS
, RAA.CONFIRMED_FLAG APP_CONFIRMED_FLAG
, RAA.EARNED_DISCOUNT_CCID APP_EARNED_DISCOUNT_CCID
, RAA.EDISC_TAX_ACCT_RULE APP_EDISC_TAX_ACCT_RULE
, RAA.GL_DATE APP_GL_DATE
, RAA.REVERSAL_GL_DATE APP_REVERSAL_GL_DATE
, RAA.STATUS APP_STATUS
, RAA.TAX_CODE APP_TAX_CODE
, RAA.TRANS_TO_RECEIPT_RATE APP_TRANS_TO_RECEIPT_RATE
, RAA.UNEARNED_DISCOUNT_CCID APP_UNEARNED_DISCOUNT_CCID
, RAA.UNEDISC_TAX_ACCT_RULE APP_UNEDISC_TAX_ACCT_RULE
, RAA.APPLICATION_REF_REASON APP_APPLICATION_REF_REASON
, RAA.ATTRIBUTE1 APP_ATTR1
, RAA.ATTRIBUTE10 APP_ATTR10
, RAA.ATTRIBUTE11 APP_ATTR11
, RAA.ATTRIBUTE12 APP_ATTR12
, RAA.ATTRIBUTE13 APP_ATTR13
, RAA.ATTRIBUTE14 APP_ATTR14
, RAA.ATTRIBUTE15 APP_ATTR15
, RAA.ATTRIBUTE2 APP_ATTR2
, RAA.ATTRIBUTE3 APP_ATTR3
, RAA.ATTRIBUTE4 APP_ATTR4
, RAA.ATTRIBUTE5 APP_ATTR5
, RAA.ATTRIBUTE6 APP_ATTR6
, RAA.ATTRIBUTE7 APP_ATTR7
, RAA.ATTRIBUTE8 APP_ATTR8
, RAA.ATTRIBUTE9 APP_ATTR9
, RAA.ATTRIBUTE_CATEGORY APP_ATTR_CAT
, RAA.GLOBAL_ATTRIBUTE1 APP_GLOBAL_ATTR1
, RAA.GLOBAL_ATTRIBUTE10 APP_GLOBAL_ATTR10
, RAA.GLOBAL_ATTRIBUTE11 APP_GLOBAL_ATTR11
, RAA.GLOBAL_ATTRIBUTE2 APP_GLOBAL_ATTR2
, RAA.GLOBAL_ATTRIBUTE3 APP_GLOBAL_ATTR3
, RAA.GLOBAL_ATTRIBUTE4 APP_GLOBAL_ATTR4
, RAA.GLOBAL_ATTRIBUTE5 APP_GLOBAL_ATTR5
, RAA.GLOBAL_ATTRIBUTE6 APP_GLOBAL_ATTR6
, RAA.GLOBAL_ATTRIBUTE7 APP_GLOBAL_ATTR7
, RAA.GLOBAL_ATTRIBUTE8 APP_GLOBAL_ATTR8
, RAA.GLOBAL_ATTRIBUTE9 APP_GLOBAL_ATTR9
, RAA.GLOBAL_ATTRIBUTE_CATEGORY APP_GLOBAL_ATTR_CAT
, RAA.USSGL_TRANSACTION_CODE APP_USSGL_TRX_CODE
, RAA.USSGL_TRANSACTION_CODE_CONTEXT APP_USSGL_TRX_CODE_CT
, LI.EVENT_ID EVENT_ID
, 'C' XLA_PARTY_TYPE
, LI.CRH_STATUS APP_CRH_STATUS
, LI.LINE_NUMBER LINE_NUMBER
, LI.LANGUAGE LANGUAGE
, LI.LEDGER_ID LEDGER_ID
FROM AR_XLA_LINES_EXTRACT LI
, AR_RECEIVABLE_APPLICATIONS_ALL RAA
WHERE LI.EVENT_ID = RAA.EVENT_ID
AND LI.SOURCE_ID = RAA.RECEIVABLE_APPLICATION_ID
AND LI.POSTING_ENTITY = 'APP'
AND LI.LEVEL_FLAG = 'L'
AND LI.CUSTOMER_TRX_ID IS NOT NULL
AND LI.FROM_TO_FLAG = 'T'
AND LI.EVENT_TYPE_CODE IN ('CM_CREATE'
, 'CM_UPDATE')
AND NVL(LI.ADDITIONAL_CHAR1
, 'XX') <> 'R12_11ICASH_POST'
AND LI.MFAR_ADDITIONAL_ENTRY = 'N' UNION /******************************* * CASH BASIS UPGRADE RECP APP * *******************************/ SELECT /*+ INDEX(LICR AR_XLA_LINES_EXTRACT_N1) INDEX(LITRX AR_XLA_LINES_EXTRACT_N1)*/ RAA.RECEIVABLE_APPLICATION_ID APP_APPLICATION_ID
, RAA.APPLICATION_REF_NUM APP_APPLICATION_REF_NUM
, RAA.APPLICATION_REF_TYPE APP_APPLICATION_REF_TYPE
, RAA.APPLICATION_TYPE APP_APPLICATION_TYPE
, RAA.APPLY_DATE APP_APPLY_DATE
, RAA.CODE_COMBINATION_ID APP_CODE_COMBINATION_ID
, RAA.COMMENTS APP_COMMENTS
, RAA.CONFIRMED_FLAG APP_CONFIRMED_FLAG
, RAA.EARNED_DISCOUNT_CCID APP_EARNED_DISCOUNT_CCID
, RAA.EDISC_TAX_ACCT_RULE APP_EDISC_TAX_ACCT_RULE
, RAA.GL_DATE APP_GL_DATE
, RAA.REVERSAL_GL_DATE APP_REVERSAL_GL_DATE
, RAA.STATUS APP_STATUS
, RAA.TAX_CODE APP_TAX_CODE
, RAA.TRANS_TO_RECEIPT_RATE APP_TRANS_TO_RECEIPT_RATE
, RAA.UNEARNED_DISCOUNT_CCID APP_UNEARNED_DISCOUNT_CCID
, RAA.UNEDISC_TAX_ACCT_RULE APP_UNEDISC_TAX_ACCT_RULE
, RAA.APPLICATION_REF_REASON APP_APPLICATION_REF_REASON
, RAA.ATTRIBUTE1 APP_ATTR1
, RAA.ATTRIBUTE10 APP_ATTR10
, RAA.ATTRIBUTE11 APP_ATTR11
, RAA.ATTRIBUTE12 APP_ATTR12
, RAA.ATTRIBUTE13 APP_ATTR13
, RAA.ATTRIBUTE14 APP_ATTR14
, RAA.ATTRIBUTE15 APP_ATTR15
, RAA.ATTRIBUTE2 APP_ATTR2
, RAA.ATTRIBUTE3 APP_ATTR3
, RAA.ATTRIBUTE4 APP_ATTR4
, RAA.ATTRIBUTE5 APP_ATTR5
, RAA.ATTRIBUTE6 APP_ATTR6
, RAA.ATTRIBUTE7 APP_ATTR7
, RAA.ATTRIBUTE8 APP_ATTR8
, RAA.ATTRIBUTE9 APP_ATTR9
, RAA.ATTRIBUTE_CATEGORY APP_ATTR_CAT
, RAA.GLOBAL_ATTRIBUTE1 APP_GLOBAL_ATTR1
, RAA.GLOBAL_ATTRIBUTE10 APP_GLOBAL_ATTR10
, RAA.GLOBAL_ATTRIBUTE11 APP_GLOBAL_ATTR11
, RAA.GLOBAL_ATTRIBUTE2 APP_GLOBAL_ATTR2
, RAA.GLOBAL_ATTRIBUTE3 APP_GLOBAL_ATTR3
, RAA.GLOBAL_ATTRIBUTE4 APP_GLOBAL_ATTR4
, RAA.GLOBAL_ATTRIBUTE5 APP_GLOBAL_ATTR5
, RAA.GLOBAL_ATTRIBUTE6 APP_GLOBAL_ATTR6
, RAA.GLOBAL_ATTRIBUTE7 APP_GLOBAL_ATTR7
, RAA.GLOBAL_ATTRIBUTE8 APP_GLOBAL_ATTR8
, RAA.GLOBAL_ATTRIBUTE9 APP_GLOBAL_ATTR9
, RAA.GLOBAL_ATTRIBUTE_CATEGORY APP_GLOBAL_ATTR_CAT
, RAA.USSGL_TRANSACTION_CODE APP_USSGL_TRX_CODE
, RAA.USSGL_TRANSACTION_CODE_CONTEXT APP_USSGL_TRX_CODE_CT
, LICR.EVENT_ID EVENT_ID
, 'C' XLA_PARTY_TYPE
, LICR.CRH_STATUS APP_CRH_STATUS
, LICR.LINE_NUMBER LINE_NUMBER
, LICR.LANGUAGE LANGUAGE
, LICR.LEDGER_ID LEDGER_ID
FROM AR_XLA_LINES_EXTRACT LICR
, AR_XLA_LINES_EXTRACT LITRX
, AR_RECEIVABLE_APPLICATIONS_ALL RAA
, AR_CASH_BASIS_DISTS_ALL DIST
WHERE LICR.EVENT_ID = RAA.EVENT_ID
AND LICR.SOURCE_ID = RAA.RECEIVABLE_APPLICATION_ID
AND LICR.POSTING_ENTITY = 'APP'
AND LICR.LEVEL_FLAG = 'L'
AND LICR.CASH_RECEIPT_ID IS NOT NULL
AND LICR.CUSTOMER_TRX_ID IS NULL
AND LICR.FROM_TO_FLAG = 'F'
AND LITRX.POSTING_ENTITY = 'APP'
AND LITRX.LEVEL_FLAG = 'L'
AND LITRX.CASH_RECEIPT_ID IS NULL
AND LITRX.CUSTOMER_TRX_ID IS NOT NULL
AND LITRX.FROM_TO_FLAG = 'T'
AND LICR.HEADER_TABLE_ID = LITRX.HEADER_TABLE_ID
AND LICR.EVENT_ID = LITRX.EVENT_ID
AND DIST.RECEIVABLE_APPLICATION_ID = LITRX.HEADER_TABLE_ID
AND DIST.CASH_BASIS_DISTRIBUTION_ID = LICR.LINE_ID
AND DIST.CASH_BASIS_DISTRIBUTION_ID = LITRX.LINE_ID
AND LICR.EVENT_TYPE_CODE IN ('RECP_CREATE'
, 'RECP_UPDATE'
, 'RECP_RATE_ADJUST'
, 'RECP_REVERSE')
AND LICR.ADDITIONAL_CHAR1 = 'R12_11ICASH_POST'
AND LITRX.ADDITIONAL_CHAR1 = 'R12_11ICASH_POST'
AND LICR.MFAR_ADDITIONAL_ENTRY = 'N'
AND LITRX.MFAR_ADDITIONAL_ENTRY = 'N' UNION /******************************* * MFAR ADDITIONAL ENTRIES * *******************************/ SELECT /*+ INDEX(LI AR_XLA_LINES_EXTRACT_N1) */ RAA.RECEIVABLE_APPLICATION_ID APP_APPLICATION_ID
, RAA.APPLICATION_REF_NUM APP_APPLICATION_REF_NUM
, RAA.APPLICATION_REF_TYPE APP_APPLICATION_REF_TYPE
, RAA.APPLICATION_TYPE APP_APPLICATION_TYPE
, RAA.APPLY_DATE APP_APPLY_DATE
, RAA.CODE_COMBINATION_ID APP_CODE_COMBINATION_ID
, RAA.COMMENTS APP_COMMENTS
, RAA.CONFIRMED_FLAG APP_CONFIRMED_FLAG
, RAA.EARNED_DISCOUNT_CCID APP_EARNED_DISCOUNT_CCID
, RAA.EDISC_TAX_ACCT_RULE APP_EDISC_TAX_ACCT_RULE
, RAA.GL_DATE APP_GL_DATE
, RAA.REVERSAL_GL_DATE APP_REVERSAL_GL_DATE
, RAA.STATUS APP_STATUS
, RAA.TAX_CODE APP_TAX_CODE
, RAA.TRANS_TO_RECEIPT_RATE APP_TRANS_TO_RECEIPT_RATE
, RAA.UNEARNED_DISCOUNT_CCID APP_UNEARNED_DISCOUNT_CCID
, RAA.UNEDISC_TAX_ACCT_RULE APP_UNEDISC_TAX_ACCT_RULE
, RAA.APPLICATION_REF_REASON APP_APPLICATION_REF_REASON
, RAA.ATTRIBUTE1 APP_ATTR1
, RAA.ATTRIBUTE10 APP_ATTR10
, RAA.ATTRIBUTE11 APP_ATTR11
, RAA.ATTRIBUTE12 APP_ATTR12
, RAA.ATTRIBUTE13 APP_ATTR13
, RAA.ATTRIBUTE14 APP_ATTR14
, RAA.ATTRIBUTE15 APP_ATTR15
, RAA.ATTRIBUTE2 APP_ATTR2
, RAA.ATTRIBUTE3 APP_ATTR3
, RAA.ATTRIBUTE4 APP_ATTR4
, RAA.ATTRIBUTE5 APP_ATTR5
, RAA.ATTRIBUTE6 APP_ATTR6
, RAA.ATTRIBUTE7 APP_ATTR7
, RAA.ATTRIBUTE8 APP_ATTR8
, RAA.ATTRIBUTE9 APP_ATTR9
, RAA.ATTRIBUTE_CATEGORY APP_ATTR_CAT
, RAA.GLOBAL_ATTRIBUTE1 APP_GLOBAL_ATTR1
, RAA.GLOBAL_ATTRIBUTE10 APP_GLOBAL_ATTR10
, RAA.GLOBAL_ATTRIBUTE11 APP_GLOBAL_ATTR11
, RAA.GLOBAL_ATTRIBUTE2 APP_GLOBAL_ATTR2
, RAA.GLOBAL_ATTRIBUTE3 APP_GLOBAL_ATTR3
, RAA.GLOBAL_ATTRIBUTE4 APP_GLOBAL_ATTR4
, RAA.GLOBAL_ATTRIBUTE5 APP_GLOBAL_ATTR5
, RAA.GLOBAL_ATTRIBUTE6 APP_GLOBAL_ATTR6
, RAA.GLOBAL_ATTRIBUTE7 APP_GLOBAL_ATTR7
, RAA.GLOBAL_ATTRIBUTE8 APP_GLOBAL_ATTR8
, RAA.GLOBAL_ATTRIBUTE9 APP_GLOBAL_ATTR9
, RAA.GLOBAL_ATTRIBUTE_CATEGORY APP_GLOBAL_ATTR_CAT
, RAA.USSGL_TRANSACTION_CODE APP_USSGL_TRX_CODE
, RAA.USSGL_TRANSACTION_CODE_CONTEXT APP_USSGL_TRX_CODE_CT
, LI.EVENT_ID EVENT_ID
, 'C' XLA_PARTY_TYPE
, LI.CRH_STATUS APP_CRH_STATUS
, LI.LINE_NUMBER LINE_NUMBER
, LI.LANGUAGE LANGUAGE
, LI.LEDGER_ID LEDGER_ID
FROM AR_XLA_LINES_EXTRACT LI
, AR_RECEIVABLE_APPLICATIONS_ALL RAA
WHERE LI.EVENT_ID = RAA.EVENT_ID
AND LI.SOURCE_ID = RAA.RECEIVABLE_APPLICATION_ID
AND LI.SOURCE_TABLE = 'RA'
AND LI.LEVEL_FLAG = 'L'
AND LI.MFAR_ADDITIONAL_ENTRY = 'Y'

Columns