AR_FUNDS_CAPTURE_ORDERS_V
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: VIEW
Columns
Name |
---|
SELECTED_REMITTANCE_BATCH_ID CALL_APP_SERVICE_REQ_CODE SETTLEMENT_DATE SETTLEMENT_DUE_DATE BR_MATURITY_DATE ORDER_DESCRIPTION SETTLEMENT_CURRENCY_CODE SETTLEMENT_AMOUNT PAYMENT_TRXN_EXTENSION_ID INTERNAL_BANK_ACCOUNT_ID PAYER_PARTY_ID CUST_ACCOUNT_ID ACCT_SITE_USE_ID ORG_ID ORG_TYPE LEGAL_ENTITY_ID BILL_TO_ADDRESS_ID SETTLEMENT_CUSTOMER_REFERENCE TANGIBLE_ID BR_DRAWEE_ISSUED_FLAG BR_SIGNED_FLAG BR_DISPUTED_FLAG ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER AR_RECEIPT_METHOD_ID REMIT_METHOD_CODE STRUCTURED_PAYMENT_REFERENCE |
Query
SQL_Statement |
---|
SELECT cr.SELECTED_REMITTANCE_BATCH_ID SELECTED_REMITTANCE_BATCH_ID, 'AR_'||cr.SELECTED_REMITTANCE_BATCH_ID CALL_APP_SERVICE_REQ_CODE, cr.receipt_date SETTLEMENT_DATE, ps.due_date SETTLEMENT_DUE_DATE , null BR_MATURITY_DATE , null ORDER_DESCRIPTION , cr.currency_code SETTLEMENT_CURRENCY_CODE, cr.amount SETTLEMENT_AMOUNT, cr.payment_trxn_extension_id PAYMENT_TRXN_EXTENSION_ID, bau.bank_account_id INTERNAL_BANK_ACCOUNT_ID, party.party_id PAYER_PARTY_ID, cr.pay_from_customer CUST_ACCOUNT_ID, cr.customer_site_use_id ACCT_SITE_USE_ID, cr.org_id, 'OPERATING_UNIT' ORG_TYPE, cr.legal_entity_id, loc.location_id BILL_TO_ADDRESS_ID, null SETTLEMENT_CUSTOMER_REFERENCE, cr.payment_server_order_num TANGIBLE_ID, null BR_DRAWEE_ISSUED_FLAG, null BR_SIGNED_FLAG, null BR_DISPUTED_FLAG, cr.ATTRIBUTE_CATEGORY, cr.ATTRIBUTE1, cr.ATTRIBUTE2, cr.ATTRIBUTE3, cr.ATTRIBUTE4, cr.ATTRIBUTE5, cr.ATTRIBUTE6, cr.ATTRIBUTE7, cr.ATTRIBUTE8, cr.ATTRIBUTE9, cr.ATTRIBUTE10, cr.ATTRIBUTE11, cr.ATTRIBUTE12, cr.ATTRIBUTE13, cr.ATTRIBUTE14, cr.ATTRIBUTE15, cr.created_by, cr.creation_date, cr.last_updated_by, cr.last_update_date, cr.last_update_login, 1, cr.receipt_method_id ar_receipt_method_id, rc.remit_method_code REMIT_METHOD_CODE, cr.STRUCTURED_PAYMENT_REFERENCE STRUCTURED_PAYMENT_REFERENCE from ar_cash_receipts cr, hz_parties party, hz_cust_accounts hca, hz_locations loc, hz_cust_acct_sites_all acct_site, hz_party_sites party_site, hz_cust_site_uses_all su, ar_receipt_classes rc, ar_receipt_methods rm, ar_payment_schedules ps, ce_bank_acct_uses_ou_v bau WHERE hca.party_id = party.party_id AND hca.cust_account_id = cr.pay_from_customer AND su.site_use_id(+) = cr.customer_site_use_id AND (su.set_id = FND_SetID_Utility.getSetID('HZ_CUSTOMER_ACCOUNT_SITE', 'BU', mo_global.get_current_org_id) OR nvl(su.set_id, 0) = 0) AND (su.set_id = acct_site.set_id OR nvl(acct_site.set_id, 0) = 0) AND acct_site.cust_acct_site_id(+) = su.cust_acct_site_id AND acct_site.party_site_id = party_site.party_site_id(+) AND loc.location_id(+) = party_site.location_id AND cr.receipt_method_id = rm.receipt_method_id and rm.receipt_class_id = rc.receipt_class_id and rc.creation_method_code = 'AUTOMATIC' and cr.payment_trxn_extension_id is not null and cr.type = 'CASH' and ps.cash_receipt_id = cr.cash_receipt_id and bau.bank_acct_use_id = cr.remit_bank_acct_use_id |