ARB_FUNDS_CAPTURE_ORDERS_V
Details
-
Schema: FUSION
-
Object owner: ARB
-
Object type: VIEW
Columns
Name |
---|
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 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 RECEIPT_METHOD_ID STRUCTURED_PAYMENT_REFERENCE |
Query
SQL_Statement |
---|
SELECT 'ARB_' || cr.cash_receipt_id AS call_app_service_req_code, cr.receipt_date AS settlement_date, ps.due_date AS settlement_due_date, NULL AS br_maturity_date, NULL AS order_description, cr.currency_code AS settlement_currency_code, cr.amount AS settlement_amount, cr.payment_trxn_extension_id AS payment_trxn_extension_id, bau.bank_account_id AS internal_bank_account_id, party.party_id AS payer_party_id, cr.pay_from_customer AS cust_account_id, cr.customer_site_use_id AS acct_site_use_id, cr.org_id, 'OPERATING_UNIT' AS org_type, cr.legal_entity_id, loc.location_id AS bill_to_address_id, NULL AS settlement_customer_reference, NULL AS br_drawee_issued_flag, NULL AS br_signed_flag, NULL AS 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 OBJECT_VERSION_NUMBER , cr.receipt_method_id, NULL 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_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 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 |