APPS.AR_GTA_ARTRX_PROC dependencies on HZ_PARTIES

Line 950: , Hz_Parties RAC_BILL_PARTY

946: ra_customer_trx_all h
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(+)

Line 2102: l_rac_bill_to_customer_name Hz_Parties.PARTY_NAME%TYPE;

2098: l_apba_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%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;

Line 2104: l_bill_to_taxpayer_id Hz_Parties.JGZZ_FISCAL_CODE%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;
2108: l_inventory_item_id ra_customer_trx_lines_all.inventory_item_id%TYPE;

Line 2491: Hz_Parties RAC_BILL_PARTY,

2487: FROM ra_customer_trx_all h,
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(+)

Line 2597: --,Hz_Parties RAC_BILL_PARTY

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
2601: --Yao add for bug#8769687

Line 2652: Hz_Parties rac_bill_party

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;
2656: