APPS.JMF_GTA_ARTRX_PROC dependencies on HZ_CUST_ACCOUNTS

Line 914: , Hz_Cust_Accounts RAC_BILL

910: , ra_cust_trx_types_all ctt
911: , ra_batches_all b
912: , Ra_Cust_Trx_Line_Gl_Dist_All gd
913: , Hz_Parties RAC_BILL_PARTY
914: , Hz_Cust_Accounts RAC_BILL
915: , GL_PERIODS GP
916: WHERE h.complete_flag = ''Y''
917: AND h.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID(+)
918: AND ctt.TYPE IN (''INV'', ''CM'', ''DM'')

Line 2040: l_rac_bill_to_customer_num Hz_Cust_Accounts.ACCOUNT_NUMBER%TYPE;

2036: l_apba_bank_account_num CE_Bank_Accounts.Bank_Account_num%TYPE;
2037: l_apba_bank_account_name CE_Bank_Accounts.Bank_Account_Name%TYPE;
2038:
2039: l_rac_bill_to_customer_name Hz_Parties.PARTY_NAME%TYPE;
2040: l_rac_bill_to_customer_num Hz_Cust_Accounts.ACCOUNT_NUMBER%TYPE;
2041: l_bill_to_taxpayer_id Hz_Parties.JGZZ_FISCAL_CODE%TYPE;
2042:
2043: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2044: l_description ra_customer_trx_lines_all.description%TYPE;

Line 2396: Hz_Cust_Accounts RAC_BILL,

2392: ra_cust_trx_types_all ctt,
2393: ra_batches_all b,
2394: Ra_Cust_Trx_Line_Gl_Dist_All gd,
2395: Hz_Parties RAC_BILL_PARTY,
2396: Hz_Cust_Accounts RAC_BILL,
2397: GL_PERIODS GP -- period
2398: WHERE h.complete_flag = 'Y'
2399: AND h.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID(+)
2400: AND ctt.TYPE IN ('INV', 'CM', 'DM')

Line 2494: Hz_Cust_Accounts RAC_BILL,

2490: BEGIN
2491: SELECT p.phone_number
2492: INTO l_phone_number
2493: FROM Hz_Contact_Points p,
2494: Hz_Cust_Accounts RAC_BILL,
2495: Hz_Parties RAC_BILL_PARTY,
2496: ra_customer_trx_all h
2497: WHERE -- h.bill_to_customer_id can find by customer trx id
2498: h.bill_to_customer_id = RAC_BILL.CUST_ACCOUNT_ID

Line 2528: Hz_Cust_Accounts rac_bill,

2524: INTO l_rac_bill_to_customer_name,
2525: l_rac_bill_to_customer_num,
2526: l_bill_to_taxpayer_id
2527: FROM ra_customer_trx_all h,
2528: Hz_Cust_Accounts rac_bill,
2529: Hz_Parties rac_bill_party
2530: WHERE h.customer_trx_id = l_customer_trx_id
2531: AND h.bill_to_customer_id = RAC_BILL.CUST_ACCOUNT_ID
2532: AND rac_bill.party_id = RAC_BILL_PARTY.Party_Id;