APPS.AR_GTA_ARTRX_PROC dependencies on HZ_CUST_ACCOUNTS

Line 951: , Hz_Cust_Accounts RAC_BILL

947: , ra_cust_trx_types_all ctt
948: , ra_batches_all b
949: , Ra_Cust_Trx_Line_Gl_Dist_All gd
950: , Hz_Parties RAC_BILL_PARTY
951: , Hz_Cust_Accounts RAC_BILL
952: , GL_PERIODS GP
953: WHERE h.complete_flag = ''Y''
954: AND h.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID(+)
955: AND ctt.TYPE IN (''INV'', ''CM'', ''DM'')

Line 2103: l_rac_bill_to_customer_num Hz_Cust_Accounts.ACCOUNT_NUMBER%TYPE;

2099: l_apba_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
2100: -- End bug 12589431
2101:
2102: l_rac_bill_to_customer_name Hz_Parties.PARTY_NAME%TYPE;
2103: l_rac_bill_to_customer_num Hz_Cust_Accounts.ACCOUNT_NUMBER%TYPE;
2104: l_bill_to_taxpayer_id Hz_Parties.JGZZ_FISCAL_CODE%TYPE;
2105:
2106: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2107: l_description ra_customer_trx_lines_all.description%TYPE;

Line 2492: Hz_Cust_Accounts RAC_BILL,

2488: ra_cust_trx_types_all ctt,
2489: ra_batches_all b,
2490: Ra_Cust_Trx_Line_Gl_Dist_All gd,
2491: Hz_Parties RAC_BILL_PARTY,
2492: Hz_Cust_Accounts RAC_BILL,
2493: GL_PERIODS GP -- period
2494: WHERE h.complete_flag = 'Y'
2495: AND h.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID(+)
2496: AND ctt.TYPE IN ('INV', 'CM', 'DM')

Line 2596: --,Hz_Cust_Accounts RAC_BILL

2592: SELECT p.phone_number
2593: INTO l_phone_number
2594: FROM Hz_Contact_Points p
2595: --Yao delete for bug#8769687 begin
2596: --,Hz_Cust_Accounts RAC_BILL
2597: --,Hz_Parties RAC_BILL_PARTY
2598: --Yao delete end for bug#8769687
2599: ,
2600: ra_customer_trx_all h

Line 2651: Hz_Cust_Accounts rac_bill,

2647: INTO l_rac_bill_to_customer_name,
2648: l_rac_bill_to_customer_num,
2649: l_bill_to_taxpayer_id
2650: FROM ra_customer_trx_all h,
2651: Hz_Cust_Accounts rac_bill,
2652: Hz_Parties rac_bill_party
2653: WHERE h.customer_trx_id = l_customer_trx_id
2654: AND h.bill_to_customer_id = RAC_BILL.CUST_ACCOUNT_ID
2655: AND rac_bill.party_id = RAC_BILL_PARTY.Party_Id;