APPS.AR_GTA_REPORTS_PKG dependencies on HZ_CUST_ACCOUNTS

Line 280: , Hz_Cust_Accounts RAC_BILL

276: --yao zhang modified for bug8766075
277: -- , ra_batches_all bat
278: ,RA_BATCH_SOURCES_ALL bas
279: , Ra_Cust_Trx_Types_all ctt
280: , Hz_Cust_Accounts RAC_BILL
281: , Hz_Parties RAC_BILL_PARTY
282: -- added by Allen Yang 24-Sep-2009 for bug 8920326
283: ----------------------------------------------------
284: , AR_LOOKUPS al

Line 335: , Hz_Cust_Accounts RAC_BILL

331: --yao zhang modified for bug8766075
332: -- , ra_batches_all bat
333: ,RA_BATCH_SOURCES_ALL bas
334: , Ra_Cust_Trx_Types_all ctt
335: , Hz_Cust_Accounts RAC_BILL
336: , Hz_Parties RAC_BILL_PARTY
337: -- added by Allen Yang 24-Sep-2009 for bug 8920326
338: -----------------------------------------------------
339: , AR_LOOKUPS al

Line 970: ,hz_cust_accounts rac_bill

966: RAA_BILL_LOC.Address_Lines_Phonetic)) customer_address
967: FROM
968: ra_customer_trx_all rct
969: ,hz_parties rac_bill_party
970: ,hz_cust_accounts rac_bill
971: --,ap_bank_accounts apba
972: --,ap_bank_branches apb
973: ,hz_cust_site_uses_all su_bill
974: ,hz_party_sites raa_bill_ps

Line 3836: l_customer_id hz_cust_accounts.cust_account_id%TYPE

3832: IS
3833: l_operating_unit hr_operating_units.name%TYPE;
3834: l_customer_name hz_parties.party_name%TYPE;
3835: l_primary_sales_name ra_salesreps_all.name%TYPE;
3836: l_customer_id hz_cust_accounts.cust_account_id%TYPE
3837: :=p_cust_name_id;
3838: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3839: l_gta_batch_num_from ar_gta_trx_headers_all.gta_batch_number%TYPE
3840: :=p_gta_batch_num_from;

Line 3844: l_cust_num_from hz_cust_accounts.account_number%TYPE

3840: :=p_gta_batch_num_from;
3841: l_gta_batch_num_to ar_gta_trx_headers_all.gta_batch_number%TYPE
3842: :=p_gta_batch_num_to;
3843: l_ar_transaction_type ra_cust_trx_types_all.name%TYPE;
3844: l_cust_num_from hz_cust_accounts.account_number%TYPE
3845: :=p_cust_num_from;
3846: l_cust_num_to hz_cust_accounts.account_number%TYPE
3847: :=p_cust_num_to;
3848: l_gl_period gl_periods.period_name%TYPE

Line 3846: l_cust_num_to hz_cust_accounts.account_number%TYPE

3842: :=p_gta_batch_num_to;
3843: l_ar_transaction_type ra_cust_trx_types_all.name%TYPE;
3844: l_cust_num_from hz_cust_accounts.account_number%TYPE
3845: :=p_cust_num_from;
3846: l_cust_num_to hz_cust_accounts.account_number%TYPE
3847: :=p_cust_num_to;
3848: l_gl_period gl_periods.period_name%TYPE
3849: :=p_gl_period;
3850: l_ar_trx_batch_from ra_batches_all.name%TYPE

Line 3933: hz_cust_accounts hca

3929: CURSOR c_customer_name IS
3930: SELECT
3931: hp.party_name
3932: FROM
3933: hz_cust_accounts hca
3934: ,hz_parties hp
3935: WHERE hca.cust_account_id=l_customer_id
3936: AND hp.party_id=hca.party_id;
3937:

Line 4720: ,hz_cust_accounts rac_bill

4716: ,ct.invoice_currency_code
4717: FROM
4718: ar_gta_trx_headers gta
4719: ,ra_customer_trx_all ct
4720: ,hz_cust_accounts rac_bill
4721: ,hz_parties rac_bill_party
4722: ,ra_cust_trx_line_gl_dist_all gd
4723: ,ra_batches_all rb
4724: WHERE gta.ra_trx_id=ct.customer_trx_id(+)