DBA Data[Home] [Help]

APPS.FV_APPLY_CASH_RECEIPT dependencies on HZ_CUST_ACCOUNTS

Line 94: customer_number hz_cust_accounts.account_number%TYPE,

90: maturity_date DATE,
91: postmark_date DATE,
92: customer_id hz_parties.party_id%TYPE,
93: customer_name hz_parties.party_name%TYPE,
94: customer_number hz_cust_accounts.account_number%TYPE,
95: customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE,
96: customer_bank_account_num ce_bank_accounts.bank_account_num%TYPE,
97: customer_bank_account_name ce_bank_accounts.bank_account_name%TYPE,
98: location hz_cust_site_uses.location%type,

Line 2738: hz_parties hzp, hz_cust_accounts hzca

2734: trunc(ficr.receipt_date) receipt_date,
2735: ficr.site_use_id,
2736: sum(ficr.amount) amount
2737: FROM fv_interim_cash_receipts ficr,
2738: hz_parties hzp, hz_cust_accounts hzca
2739: WHERE ficr.batch_id = c_batch_id
2740: AND hzp.party_id = hzca.party_id
2741: AND ficr.customer_id = hzca.cust_account_id
2742: GROUP BY ficr.receipt_number,

Line 2784: hz_parties hzp, hz_cust_accounts hzca

2780: rctl.extended_amount line_amount
2781: FROM fv_interim_cash_receipts ficr,
2782: ra_customer_trx rct,
2783: ra_customer_trx_lines rctl,
2784: hz_parties hzp, hz_cust_accounts hzca
2785: WHERE ficr.batch_id = c_batch_id
2786: AND hzp.party_id = hzca.party_id
2787: AND ficr.receipt_number = c_receipt_number
2788: AND ficr.customer_id = c_customer_id