AR_CASH_RECEIPTS_L_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

LN_RCT_ACTUAL_VALUE_DATE LN_RCT_CASH_RECEIPT_ID LN_RCT_COMMENTS LN_RCT_CUSTOMER_RECEIPT_REF LN_RCT_DEPOSIT_DATE LN_RCT_DOC_SEQUENCE_ID LN_RCT_DOC_SEQUENCE_VALUE LN_RCT_DOC_SEQUENCE_CATEGORY LN_RCT_ISSUER_NAME LN_RCT_ISSUE_DATE LN_RCT_MISC_PAYMENT_SOURCE LN_RCT_PAY_FROM_CUSTOMER LN_RCT_POSTMARK_DATE LN_RCT_RECEIPT_DATE LN_RCT_RECEIPT_NUMBER LN_RCT_REFERENCE_TYPE LN_RCT_REVERSAL_COMMENTS LN_RCT_REVERSAL_DATE LN_RCT_REVERSAL_REASON_CODE LN_RCT_TAX_RATE LN_RCT_TYPE LN_RCT_ATTR1 LN_RCT_ATTR10 LN_RCT_ATTR11 LN_RCT_ATTR12 LN_RCT_ATTR13 LN_RCT_ATTR14 LN_RCT_ATTR15 LN_RCT_ATTR2 LN_RCT_ATTR3 LN_RCT_ATTR4 LN_RCT_ATTR5 LN_RCT_ATTR6 LN_RCT_ATTR7 LN_RCT_ATTR8 LN_RCT_ATTR9 LN_RCT_ATTR_CAT LN_RCT_GLOBAL_ATTR1 LN_RCT_GLOBAL_ATTR2 LN_RCT_GLOBAL_ATTR3 LN_RCT_GLOBAL_ATTR4 LN_RCT_GLOBAL_ATTR5 LN_RCT_GLOBAL_ATTR6 LN_RCT_GLOBAL_ATTR_CAT LN_RCT_REVERSAL_CAT LN_RCT_USSGL_TRX_CODE LN_RCT_USSGL_TRX_CODE_CT EVENT_ID LEDGER_ID LINE_NUMBER XLA_PARTY_TYPE LN_RCT_OPER_UNIT LN_RCT_APP_STATUS

Query

SQL_Statement

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 AND DECODE(l.posting_entity, 'APP', DECODE(l.crh_status, NULL, 'Y', 'N'), 'Y') = 'Y'