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.JMF_GTA_REPORTS_PKG dependencies on HZ_CUST_ACCOUNTS

Line 250: , Hz_Cust_Accounts RAC_BILL

246: FROM
247: Ra_Customer_Trx_all ract
248: , ra_batches_all bat
249: , Ra_Cust_Trx_Types_all ctt
250: , Hz_Cust_Accounts RAC_BILL
251: , Hz_Parties RAC_BILL_PARTY
252:
253: WHERE Customer_Trx_Id = P_Ar_Trx_Header_Id
254: AND ract.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID

Line 284: , Hz_Cust_Accounts RAC_BILL

280: FROM
281: Ra_Customer_Trx_all ract
282: , ra_batches_all bat
283: , Ra_Cust_Trx_Types_all ctt
284: , Hz_Cust_Accounts RAC_BILL
285: , Hz_Parties RAC_BILL_PARTY
286:
287: WHERE Customer_Trx_Id = P_Ar_Trx_Header_Id
288: AND ract.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID

Line 898: ,hz_cust_accounts rac_bill

894: ) customer_address
895: FROM
896: ra_customer_trx_all rct
897: ,hz_parties rac_bill_party
898: ,hz_cust_accounts rac_bill
899: --,ap_bank_accounts apba
900: --,ap_bank_branches apb
901: ,hz_cust_site_uses_all su_bill
902: ,hz_party_sites raa_bill_ps

Line 3657: l_customer_id hz_cust_accounts.cust_account_id%TYPE

3653: IS
3654: l_operating_unit hr_operating_units.name%TYPE;
3655: l_customer_name hz_parties.party_name%TYPE;
3656: l_primary_sales_name ra_salesreps_all.name%TYPE;
3657: l_customer_id hz_cust_accounts.cust_account_id%TYPE
3658: :=p_cust_name_id;
3659: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3660: l_gta_batch_num_from jmf_gta_trx_headers_all.gta_batch_number%TYPE
3661: :=p_gta_batch_num_from;

Line 3665: l_cust_num_from hz_cust_accounts.account_number%TYPE

3661: :=p_gta_batch_num_from;
3662: l_gta_batch_num_to jmf_gta_trx_headers_all.gta_batch_number%TYPE
3663: :=p_gta_batch_num_to;
3664: l_ar_transaction_type ra_cust_trx_types_all.name%TYPE;
3665: l_cust_num_from hz_cust_accounts.account_number%TYPE
3666: :=p_cust_num_from;
3667: l_cust_num_to hz_cust_accounts.account_number%TYPE
3668: :=p_cust_num_to;
3669: l_gl_period gl_periods.period_name%TYPE

Line 3667: l_cust_num_to hz_cust_accounts.account_number%TYPE

3663: :=p_gta_batch_num_to;
3664: l_ar_transaction_type ra_cust_trx_types_all.name%TYPE;
3665: l_cust_num_from hz_cust_accounts.account_number%TYPE
3666: :=p_cust_num_from;
3667: l_cust_num_to hz_cust_accounts.account_number%TYPE
3668: :=p_cust_num_to;
3669: l_gl_period gl_periods.period_name%TYPE
3670: :=p_gl_period;
3671: l_ar_trx_batch_from ra_batches_all.name%TYPE

Line 3750: hz_cust_accounts hca

3746: CURSOR c_customer_name IS
3747: SELECT
3748: hp.party_name
3749: FROM
3750: hz_cust_accounts hca
3751: ,hz_parties hp
3752: WHERE hca.cust_account_id=l_customer_id
3753: AND hp.party_id=hca.party_id;
3754:

Line 4515: ,hz_cust_accounts rac_bill

4511: ,ct.invoice_currency_code
4512: FROM
4513: jmf_gta_trx_headers gta
4514: ,ra_customer_trx_all ct
4515: ,hz_cust_accounts rac_bill
4516: ,hz_parties rac_bill_party
4517: ,ra_cust_trx_line_gl_dist_all gd
4518: ,ra_batches_all rb
4519: WHERE gta.ra_trx_id=ct.customer_trx_id(+)