VIEW: APPS.AR_CASH_RECEIPTS_L_V

Source

View Text - Preformatted

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 ,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

View Text - HTML Formatted

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
, 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