AR_FUNDS_CAPTURE_ORDERS

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

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

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