View: AR_CASH_RECEIPTS_H_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_CASH_RECEIPTS_H_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
, CRA.COMMENTS 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
, 'C' XLA_PARTY_TYPE
, CRA.ORG_ID RCT_OPER_UNIT
, CRA.STATUS RCT_APP_STATUS
, 222 RCT_XLA_APPLIED_TO_APP_ID
, 'RECEIPTS' RCT_ENTITY_CODE
, L.REVERSAL_CODE RCT_TRX_ACCT_REVERSAL
, CRA.PREV_PAY_FROM_CUSTOMER RCT_PREV_PAY_FROM_CUSTOMER
, CRA.PREV_CUSTOMER_SITE_USE_ID RCT_PREV_CUSTOMER_SITE_USE_ID
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 = 'H'
AND CRA.RECEIPT_METHOD_ID = RM.RECEIPT_METHOD_ID GROUP BY CRA.ACTUAL_VALUE_DATE
, CRA.CASH_RECEIPT_ID
, CRA.COMMENTS
, CRA.CUSTOMER_RECEIPT_REFERENCE
, CRA.DEPOSIT_DATE
, CRA.DOC_SEQUENCE_ID
, CRA.DOC_SEQUENCE_VALUE
, RM.NAME
, CRA.ISSUER_NAME
, CRA.ISSUE_DATE
, CRA.MISC_PAYMENT_SOURCE
, CRA.PAY_FROM_CUSTOMER
, CRA.POSTMARK_DATE
, CRA.RECEIPT_DATE
, CRA.RECEIPT_NUMBER
, CRA.REFERENCE_TYPE
, CRA.REVERSAL_COMMENTS
, CRA.REVERSAL_DATE
, CRA.REVERSAL_REASON_CODE
, CRA.TAX_RATE
, CRA.TYPE
, CRA.ATTRIBUTE1
, CRA.ATTRIBUTE10
, CRA.ATTRIBUTE11
, CRA.ATTRIBUTE12
, CRA.ATTRIBUTE13
, CRA.ATTRIBUTE14
, CRA.ATTRIBUTE15
, CRA.ATTRIBUTE2
, CRA.ATTRIBUTE3
, CRA.ATTRIBUTE4
, CRA.ATTRIBUTE5
, CRA.ATTRIBUTE6
, CRA.ATTRIBUTE7
, CRA.ATTRIBUTE8
, CRA.ATTRIBUTE9
, CRA.ATTRIBUTE_CATEGORY
, CRA.GLOBAL_ATTRIBUTE1
, CRA.GLOBAL_ATTRIBUTE2
, CRA.GLOBAL_ATTRIBUTE3
, CRA.GLOBAL_ATTRIBUTE4
, CRA.GLOBAL_ATTRIBUTE5
, CRA.GLOBAL_ATTRIBUTE6
, CRA.GLOBAL_ATTRIBUTE_CATEGORY
, CRA.REVERSAL_CATEGORY
, CRA.USSGL_TRANSACTION_CODE
, CRA.USSGL_TRANSACTION_CODE_CONTEXT
, L.EVENT_ID
, L.LEDGER_ID
, 'C'
, CRA.ORG_ID
, CRA.STATUS
, 222
, 'RECEIPTS'
, L.REVERSAL_CODE
, CRA.PREV_PAY_FROM_CUSTOMER
, CRA.PREV_CUSTOMER_SITE_USE_ID

Columns