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_ARTRX_PROC dependencies on HZ_PARTIES

Line 913: , Hz_Parties RAC_BILL_PARTY

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

Line 2039: l_rac_bill_to_customer_name Hz_Parties.PARTY_NAME%TYPE;

2035: l_apb_bank_branch_name CE_Bank_Branches_V.Bank_Branch_Name%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;

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

Line 2395: Hz_Parties RAC_BILL_PARTY,

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

Line 2495: Hz_Parties RAC_BILL_PARTY,

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
2499: AND rac_bill.party_id = RAC_BILL_PARTY.Party_Id

Line 2501: AND p.owner_table_name(+) = 'HZ_PARTIES'

2497: WHERE -- h.bill_to_customer_id can find by customer trx id
2498: h.bill_to_customer_id = RAC_BILL.CUST_ACCOUNT_ID
2499: AND rac_bill.party_id = RAC_BILL_PARTY.Party_Id
2500: AND RAC_BILL_PARTY.Party_Id = p.owner_table_id(+)
2501: AND p.owner_table_name(+) = 'HZ_PARTIES'
2502: AND p.CONTACT_POINT_TYPE(+) = 'PHONE'
2503: AND p.primary_flag(+) = 'Y'
2504: AND h.customer_trx_id = l_customer_trx_id;
2505:

Line 2529: Hz_Parties rac_bill_party

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