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.AR_GTA_TRX_UTIL dependencies on HZ_PARTIES

Line 240: Hz_Parties RAC_BILL_PARTY,

236: BEGIN
237: SELECT HCA.CLASS_CODE
238: INTO l_class_code
239: FROM ra_customer_trx_all h,
240: Hz_Parties RAC_BILL_PARTY,
241: Hz_Cust_Accounts RAC_BILL,
242: zx_party_tax_profile ZPTP,
243: hz_code_assignments HCA
244: WHERE h.bill_to_customer_id = RAC_BILL.CUST_ACCOUNT_ID

Line 1642: l_customer_id hz_parties.party_id%TYPE := p_customer_id;

1638: (p_customer_id IN NUMBER
1639: )
1640: RETURN VARCHAR2
1641: IS
1642: l_customer_id hz_parties.party_id%TYPE := p_customer_id;
1643: l_phone_number hz_contact_points.phone_number%TYPE;
1644:
1645: --Fix bug 5263009, Donghai Wang
1646: --Add the sub query to get party id by customer id

Line 1654: AND hcp.owner_table_name = 'HZ_PARTIES'

1650: hcp.phone_number
1651: FROM
1652: hz_contact_points hcp
1653: WHERE hcp.contact_point_type = 'PHONE'
1654: AND hcp.owner_table_name = 'HZ_PARTIES'
1655: AND hcp.owner_table_id = (SELECT
1656: party_id
1657: FROM
1658: hz_cust_accounts_all

Line 1785: l_customer_name hz_parties.party_name%TYPE;

1781: l_procedure_name VARCHAR2(30) := 'Get_Customer_Name';
1782: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1783: l_proc_level NUMBER := fnd_log.level_procedure;
1784:
1785: l_customer_name hz_parties.party_name%TYPE;
1786: CURSOR c_customer_name IS
1787: SELECT
1788: p.party_name
1789: FROM

Line 1790: hz_parties p

1786: CURSOR c_customer_name IS
1787: SELECT
1788: p.party_name
1789: FROM
1790: hz_parties p
1791: ,hz_cust_accounts a
1792: WHERE a.cust_account_id = p_customer_id
1793: AND p.party_id = a.party_id;
1794:

Line 2220: l_bank_name HZ_PARTIES.party_name%TYPE;

2216: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
2217: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
2218: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;
2219: l_bank_branch_id IBY_EXT_BANK_ACCOUNTS.branch_id%TYPE;
2220: l_bank_name HZ_PARTIES.party_name%TYPE;
2221: l_bank_branch_name HZ_PARTIES.party_name%TYPE;
2222: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;
2223:
2224: l_instrument_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE;

Line 2221: l_bank_branch_name HZ_PARTIES.party_name%TYPE;

2217: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
2218: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;
2219: l_bank_branch_id IBY_EXT_BANK_ACCOUNTS.branch_id%TYPE;
2220: l_bank_name HZ_PARTIES.party_name%TYPE;
2221: l_bank_branch_name HZ_PARTIES.party_name%TYPE;
2222: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;
2223:
2224: l_instrument_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE;
2225:

Line 2329: HZ_PARTIES HZP,

2325: IBY_FNDCPT_PMT_CHNNLS_VL P,
2326: IBY_FNDCPT_TX_EXTENSIONS X,
2327: IBY_FNDCPT_TX_OPERATIONS OP,
2328: IBY_PMT_INSTR_USES_ALL U,
2329: HZ_PARTIES HZP,
2330: FND_APPLICATION A,
2331: --Add by Yao for bug#8605196 to support bank name in Chinese
2332: HZ_PARTIES bhp,
2333: HZ_PARTIES brhp

Line 2332: HZ_PARTIES bhp,

2328: IBY_PMT_INSTR_USES_ALL U,
2329: HZ_PARTIES HZP,
2330: FND_APPLICATION A,
2331: --Add by Yao for bug#8605196 to support bank name in Chinese
2332: HZ_PARTIES bhp,
2333: HZ_PARTIES brhp
2334: WHERE (x.instr_assignment_id = u.instrument_payment_use_id(+))
2335: AND (DECODE(u.instrument_type, 'CREDITCARD', u.instrument_id, NULL) =
2336: c.instrid(+))

Line 2333: HZ_PARTIES brhp

2329: HZ_PARTIES HZP,
2330: FND_APPLICATION A,
2331: --Add by Yao for bug#8605196 to support bank name in Chinese
2332: HZ_PARTIES bhp,
2333: HZ_PARTIES brhp
2334: WHERE (x.instr_assignment_id = u.instrument_payment_use_id(+))
2335: AND (DECODE(u.instrument_type, 'CREDITCARD', u.instrument_id, NULL) =
2336: c.instrid(+))
2337: AND (DECODE(u.instrument_type, 'BANKACCOUNT', u.instrument_id, NULL) =

Line 2460: HZ_PARTIES

2456: --Modified end by Yao for bug#8605196 to support bank name in Chinese
2457: INTO
2458: l_bank_name
2459: FROM
2460: HZ_PARTIES
2461: WHERE
2462: party_id = l_bank_id;
2463:
2464: -- get bank branch name

Line 2474: HZ_PARTIES

2470: --Modified end by Yao for bug#8605196 to support bank name in Chinese
2471: INTO
2472: l_bank_branch_name
2473: FROM
2474: HZ_PARTIES
2475: WHERE party_id = l_bank_branch_id;
2476:
2477:
2478: EXCEPTION

Line 2574: l_bank_name HZ_PARTIES.party_name%TYPE;

2570: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
2571: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
2572: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;
2573: l_bank_branch_id IBY_EXT_BANK_ACCOUNTS.branch_id%TYPE;
2574: l_bank_name HZ_PARTIES.party_name%TYPE;
2575: l_bank_branch_name HZ_PARTIES.party_name%TYPE;
2576: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;
2577: l_instrument_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE;
2578:

Line 2575: l_bank_branch_name HZ_PARTIES.party_name%TYPE;

2571: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
2572: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;
2573: l_bank_branch_id IBY_EXT_BANK_ACCOUNTS.branch_id%TYPE;
2574: l_bank_name HZ_PARTIES.party_name%TYPE;
2575: l_bank_branch_name HZ_PARTIES.party_name%TYPE;
2576: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;
2577: l_instrument_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE;
2578:
2579: l_ori_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;

Line 2684: HZ_PARTIES HZP,

2680: IBY_FNDCPT_PMT_CHNNLS_VL P,
2681: IBY_FNDCPT_TX_EXTENSIONS X,
2682: IBY_FNDCPT_TX_OPERATIONS OP,
2683: IBY_PMT_INSTR_USES_ALL U,
2684: HZ_PARTIES HZP,
2685: FND_APPLICATION A,
2686: --Add by Yao for bug#8605196 to support bank name in Chinese
2687: HZ_PARTIES bhp,
2688: HZ_PARTIES brhp

Line 2687: HZ_PARTIES bhp,

2683: IBY_PMT_INSTR_USES_ALL U,
2684: HZ_PARTIES HZP,
2685: FND_APPLICATION A,
2686: --Add by Yao for bug#8605196 to support bank name in Chinese
2687: HZ_PARTIES bhp,
2688: HZ_PARTIES brhp
2689: WHERE (x.instr_assignment_id = u.instrument_payment_use_id(+))
2690: AND (DECODE(u.instrument_type, 'CREDITCARD', u.instrument_id, NULL) =
2691: c.instrid(+))

Line 2688: HZ_PARTIES brhp

2684: HZ_PARTIES HZP,
2685: FND_APPLICATION A,
2686: --Add by Yao for bug#8605196 to support bank name in Chinese
2687: HZ_PARTIES bhp,
2688: HZ_PARTIES brhp
2689: WHERE (x.instr_assignment_id = u.instrument_payment_use_id(+))
2690: AND (DECODE(u.instrument_type, 'CREDITCARD', u.instrument_id, NULL) =
2691: c.instrid(+))
2692: AND (DECODE(u.instrument_type, 'BANKACCOUNT', u.instrument_id, NULL) =

Line 2790: HZ_PARTIES HZP,

2786: IBY_FNDCPT_PMT_CHNNLS_VL P,
2787: IBY_FNDCPT_TX_EXTENSIONS X,
2788: IBY_FNDCPT_TX_OPERATIONS OP,
2789: IBY_PMT_INSTR_USES_ALL U,
2790: HZ_PARTIES HZP,
2791: FND_APPLICATION A,
2792: --Add by Yao for bug#8605196 to support bank name in Chinese
2793: HZ_PARTIES bhp,
2794: HZ_PARTIES brhp

Line 2793: HZ_PARTIES bhp,

2789: IBY_PMT_INSTR_USES_ALL U,
2790: HZ_PARTIES HZP,
2791: FND_APPLICATION A,
2792: --Add by Yao for bug#8605196 to support bank name in Chinese
2793: HZ_PARTIES bhp,
2794: HZ_PARTIES brhp
2795: WHERE (x.instr_assignment_id = u.instrument_payment_use_id(+))
2796: AND (DECODE(u.instrument_type, 'CREDITCARD', u.instrument_id, NULL) =
2797: c.instrid(+))

Line 2794: HZ_PARTIES brhp

2790: HZ_PARTIES HZP,
2791: FND_APPLICATION A,
2792: --Add by Yao for bug#8605196 to support bank name in Chinese
2793: HZ_PARTIES bhp,
2794: HZ_PARTIES brhp
2795: WHERE (x.instr_assignment_id = u.instrument_payment_use_id(+))
2796: AND (DECODE(u.instrument_type, 'CREDITCARD', u.instrument_id, NULL) =
2797: c.instrid(+))
2798: AND (DECODE(u.instrument_type, 'BANKACCOUNT', u.instrument_id, NULL) =

Line 2923: HZ_PARTIES

2919: --Modified end by Yao for bug#8605196 to support bank name in Chinese
2920: INTO
2921: l_bank_name
2922: FROM
2923: HZ_PARTIES
2924: WHERE
2925: party_id = l_bank_id;
2926:
2927: -- get bank branch name

Line 2937: HZ_PARTIES

2933: --Modified end by Yao for bug#8605196 to support bank name in Chinese
2934: INTO
2935: l_bank_branch_name
2936: FROM
2937: HZ_PARTIES
2938: WHERE party_id = l_bank_branch_id;
2939: EXCEPTION
2940: WHEN no_data_found THEN
2941: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)