AR_CASH_RECEIPTS_H_V
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: VIEW
Columns
Name |
---|
RCT_ACTUAL_VALUE_DATE RCT_CASH_RECEIPT_ID RCT_COMMENTS RCT_CUSTOMER_RECEIPT_REF RCT_DEPOSIT_DATE RCT_DOC_SEQUENCE_ID RCT_DOC_SEQUENCE_VALUE RCT_DOC_SEQUENCE_CATEGORY RCT_ISSUER_NAME RCT_ISSUE_DATE RCT_MISC_PAYMENT_SOURCE RCT_PAY_FROM_CUSTOMER RCT_POSTMARK_DATE RCT_RECEIPT_DATE RCT_RECEIPT_NUMBER RCT_REFERENCE_TYPE RCT_REVERSAL_COMMENTS RCT_REVERSAL_DATE RCT_REVERSAL_REASON_CODE RCT_TAX_RATE RCT_TYPE RCT_ATTR1 RCT_ATTR10 RCT_ATTR11 RCT_ATTR12 RCT_ATTR13 RCT_ATTR14 RCT_ATTR15 RCT_ATTR2 RCT_ATTR3 RCT_ATTR4 RCT_ATTR5 RCT_ATTR6 RCT_ATTR7 RCT_ATTR8 RCT_ATTR9 RCT_ATTR_CAT RCT_GLOBAL_ATTR1 RCT_GLOBAL_ATTR2 RCT_GLOBAL_ATTR3 RCT_GLOBAL_ATTR4 RCT_GLOBAL_ATTR5 RCT_GLOBAL_ATTR6 RCT_GLOBAL_ATTR_CAT RCT_REVERSAL_CAT RCT_USSGL_TRX_CODE RCT_USSGL_TRX_CODE_CT EVENT_ID LEDGER_ID XLA_PARTY_TYPE RCT_OPER_UNIT RCT_APP_STATUS RCT_XLA_APPLIED_TO_APP_ID RCT_ENTITY_CODE RCT_TRX_ACCT_REVERSAL RCT_PREV_PAY_FROM_CUSTOMER RCT_PREV_CUSTOMER_SITE_USE_ID RCT_CREATION_DATE RCT_CREATED_BY RCT_LAST_UPDATE_DATE RCT_LAST_UPDATED_BY |
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 , '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, cast(cra.creation_date as DATE) rct_creation_date, cra.created_by rct_created_by, cast(cra.last_update_date as DATE) rct_last_update_date, cra.last_updated_by rct_last_updated_by 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, cra.creation_date , cra.created_by , cra.last_update_date , cra.last_updated_by |