eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_APPLY_CASH_RECEIPT dependencies on HZ_PARTIES

Line 54: customer_name hz_parties.party_name%TYPE,

50:
51: TYPE CashReceiptRec IS RECORD
52: (
53: receipt_number fv_interim_cash_receipts.receipt_number%TYPE,
54: customer_name hz_parties.party_name%TYPE,
55: receipt_amount fv_interim_cash_receipts.amount%TYPE,
56: applied_currency fnd_currencies_vl.name%TYPE,
57: actual_amount NUMBER,
58: actual_currency fnd_currencies_vl.name%TYPE,

Line 92: customer_id hz_parties.party_id%TYPE,

88: receipt_date ar_cash_receipts.receipt_date%type,
89: gl_date DATE,
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,

Line 93: customer_name hz_parties.party_name%TYPE,

89: gl_date DATE,
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,

Line 2717: l_CustomerNumber hz_parties.party_id%TYPE;

2713: ) IS
2714: l_module_name VARCHAR2(30) := 'process_receipts';
2715:
2716: l_SiteUseId ra_customer_trx.bill_to_site_use_id%TYPE;
2717: l_CustomerNumber hz_parties.party_id%TYPE;
2718: l_RemainingReceiptAmount fv_interim_cash_receipts.amount%TYPE;
2719: l_CashReceiptId ar_cash_receipts.cash_receipt_id%TYPE;
2720:
2721: l_CreateCashRec CreateCashRecType;

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