View: AR_CASH_RECEIPTS_L_V

Product:	AR - Receivables
Description:	AR XLA Extract
Implementation/DBA Data:	APPS.AR_CASH_RECEIPTS_L_V

View Text

SELECT /*+INDEX (L AR_XLA_LINES_EXTRACT_N1)*/ CRA.ACTUAL_VALUE_DATE RCT_ACTUAL_VALUE_DATE
, CRA.CASH_RECEIPT_ID RCT_CASH_RECEIPT_ID
, SUBSTRB(CRA.COMMENTS
, 1
, 240) RCT_COMMENTS
, CRA.CUSTOMER_RECEIPT_REFERENCE RCT_CUSTOMER_RECEIPT_REF
, CRA.DEPOSIT_DATE RCT_DEPOSIT_DATE
, CRA.DOC_SEQUENCE_ID RCT_DOC_SEQUENCE_ID
, CRA.DOC_SEQUENCE_VALUE RCT_DOC_SEQUENCE_VALUE
, DECODE(CRA.DOC_SEQUENCE_VALUE
, NULL
, NULL
, RM.NAME) RCT_DOC_SEQUENCE_CATEGORY
, CRA.ISSUER_NAME RCT_ISSUER_NAME
, CRA.ISSUE_DATE RCT_ISSUE_DATE
, CRA.MISC_PAYMENT_SOURCE RCT_MISC_PAYMENT_SOURCE
, CRA.PAY_FROM_CUSTOMER RCT_PAY_FROM_CUSTOMER
, CRA.POSTMARK_DATE RCT_POSTMARK_DATE
, CRA.RECEIPT_DATE RCT_RECEIPT_DATE
, CRA.RECEIPT_NUMBER RCT_RECEIPT_NUMBER
, CRA.REFERENCE_TYPE RCT_REFERENCE_TYPE
, CRA.REVERSAL_COMMENTS RCT_REVERSAL_COMMENTS
, CRA.REVERSAL_DATE RCT_REVERSAL_DATE
, CRA.REVERSAL_REASON_CODE RCT_REVERSAL_REASON_CODE
, CRA.TAX_RATE RCT_TAX_RATE
, CRA.TYPE RCT_TYPE
, CRA.ATTRIBUTE1 RCT_ATTR1
, CRA.ATTRIBUTE10 RCT_ATTR10
, CRA.ATTRIBUTE11 RCT_ATTR11
, CRA.ATTRIBUTE12 RCT_ATTR12
, CRA.ATTRIBUTE13 RCT_ATTR13
, CRA.ATTRIBUTE14 RCT_ATTR14
, CRA.ATTRIBUTE15 RCT_ATTR15
, CRA.ATTRIBUTE2 RCT_ATTR2
, CRA.ATTRIBUTE3 RCT_ATTR3
, CRA.ATTRIBUTE4 RCT_ATTR4
, CRA.ATTRIBUTE5 RCT_ATTR5
, CRA.ATTRIBUTE6 RCT_ATTR6
, CRA.ATTRIBUTE7 RCT_ATTR7
, CRA.ATTRIBUTE8 RCT_ATTR8
, CRA.ATTRIBUTE9 RCT_ATTR9
, CRA.ATTRIBUTE_CATEGORY RCT_ATTR_CAT
, CRA.GLOBAL_ATTRIBUTE1 RCT_GLOBAL_ATTR1
, CRA.GLOBAL_ATTRIBUTE2 RCT_GLOBAL_ATTR2
, CRA.GLOBAL_ATTRIBUTE3 RCT_GLOBAL_ATTR3
, CRA.GLOBAL_ATTRIBUTE4 RCT_GLOBAL_ATTR4
, CRA.GLOBAL_ATTRIBUTE5 RCT_GLOBAL_ATTR5
, CRA.GLOBAL_ATTRIBUTE6 RCT_GLOBAL_ATTR6
, CRA.GLOBAL_ATTRIBUTE_CATEGORY RCT_GLOBAL_ATTR_CAT
, CRA.REVERSAL_CATEGORY RCT_REVERSAL_CAT
, CRA.USSGL_TRANSACTION_CODE RCT_USSGL_TRX_CODE
, CRA.USSGL_TRANSACTION_CODE_CONTEXT RCT_USSGL_TRX_CODE_CT
, L.EVENT_ID EVENT_ID
, L.LEDGER_ID LEDGER_ID
, L.LINE_NUMBER LINE_NUMBER
, 'C' XLA_PARTY_TYPE
, CRA.ORG_ID RCT_OPER_UNIT
, CRA.STATUS RCT_APP_STATUS
FROM AR_CASH_RECEIPTS_ALL CRA
, AR_XLA_LINES_EXTRACT L
, AR_RECEIPT_METHODS RM
WHERE CRA.CASH_RECEIPT_ID = L.CASH_RECEIPT_ID
AND L.LEVEL_FLAG = 'L'
AND CRA.RECEIPT_METHOD_ID = RM.RECEIPT_METHOD_ID
AND DECODE(L.POSTING_ENTITY
, 'APP'
, DECODE(L.CRH_STATUS
, NULL
, 'Y'
, 'N')
, 'Y') = 'Y'

Columns