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

Line 3547: l_CUSTOMER_NAME_FROM HZ_PARTIES.Party_Name%TYPE;

3543: l_procedure_name VARCHAR2(30) := 'export_customers';
3544:
3545: l_CUSTOMER_NUM_FROM HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3546: l_CUSTOMER_NUM_TO HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3547: l_CUSTOMER_NAME_FROM HZ_PARTIES.Party_Name%TYPE;
3548: l_CUSTOMER_NAME_TO HZ_PARTIES.Party_Name%TYPE;
3549:
3550: l_CREATION_DATE_FROM HZ_CUST_ACCOUNTS.Creation_Date%TYPE;
3551: l_CREATION_DATE_TO HZ_CUST_ACCOUNTS.Creation_Date%TYPE;

Line 3548: l_CUSTOMER_NAME_TO HZ_PARTIES.Party_Name%TYPE;

3544:
3545: l_CUSTOMER_NUM_FROM HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3546: l_CUSTOMER_NUM_TO HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3547: l_CUSTOMER_NAME_FROM HZ_PARTIES.Party_Name%TYPE;
3548: l_CUSTOMER_NAME_TO HZ_PARTIES.Party_Name%TYPE;
3549:
3550: l_CREATION_DATE_FROM HZ_CUST_ACCOUNTS.Creation_Date%TYPE;
3551: l_CREATION_DATE_TO HZ_CUST_ACCOUNTS.Creation_Date%TYPE;
3552:

Line 3555: l_customer_name HZ_PARTIES.Party_Name%TYPE;

3551: l_CREATION_DATE_TO HZ_CUST_ACCOUNTS.Creation_Date%TYPE;
3552:
3553: l_customer_id HZ_CUST_ACCOUNTS.Cust_Account_Id%TYPE;
3554: l_customer_number HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3555: l_customer_name HZ_PARTIES.Party_Name%TYPE;
3556: --l_taxpayer_id HZ_PARTIES.JGZZ_FISCAL_CODE%TYPE;
3557: l_customer_name_phonetic HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3558: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
3559: l_alternate_name HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;

Line 3556: --l_taxpayer_id HZ_PARTIES.JGZZ_FISCAL_CODE%TYPE;

3552:
3553: l_customer_id HZ_CUST_ACCOUNTS.Cust_Account_Id%TYPE;
3554: l_customer_number HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3555: l_customer_name HZ_PARTIES.Party_Name%TYPE;
3556: --l_taxpayer_id HZ_PARTIES.JGZZ_FISCAL_CODE%TYPE;
3557: l_customer_name_phonetic HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3558: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
3559: l_alternate_name HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3560:

Line 3557: l_customer_name_phonetic HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;

3553: l_customer_id HZ_CUST_ACCOUNTS.Cust_Account_Id%TYPE;
3554: l_customer_number HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3555: l_customer_name HZ_PARTIES.Party_Name%TYPE;
3556: --l_taxpayer_id HZ_PARTIES.JGZZ_FISCAL_CODE%TYPE;
3557: l_customer_name_phonetic HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3558: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
3559: l_alternate_name HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3560:
3561: l_phone_num Hz_Contact_Points.Phone_Number%TYPE;

Line 3558: l_party_id HZ_PARTIES.PARTY_ID%TYPE;

3554: l_customer_number HZ_CUST_ACCOUNTS.Account_Number%TYPE;
3555: l_customer_name HZ_PARTIES.Party_Name%TYPE;
3556: --l_taxpayer_id HZ_PARTIES.JGZZ_FISCAL_CODE%TYPE;
3557: l_customer_name_phonetic HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3558: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
3559: l_alternate_name HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3560:
3561: l_phone_num Hz_Contact_Points.Phone_Number%TYPE;
3562: l_currency_code AR_GTA_SYSTEM_PARAMETERS_ALL.Gt_Currency_Code%TYPE;

Line 3559: l_alternate_name HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;

3555: l_customer_name HZ_PARTIES.Party_Name%TYPE;
3556: --l_taxpayer_id HZ_PARTIES.JGZZ_FISCAL_CODE%TYPE;
3557: l_customer_name_phonetic HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3558: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
3559: l_alternate_name HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3560:
3561: l_phone_num Hz_Contact_Points.Phone_Number%TYPE;
3562: l_currency_code AR_GTA_SYSTEM_PARAMETERS_ALL.Gt_Currency_Code%TYPE;
3563: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NAME%TYPE;

Line 3617: l_bank_name HZ_PARTIES.party_name%TYPE;

3613: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3614:
3615: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
3616: --Yao Zhang fix bug 7670710 add begin
3617: l_bank_name HZ_PARTIES.party_name%TYPE;
3618: l_bank_branch_name HZ_PARTIES.party_name%TYPE;
3619: --Yao Zhang fix bug#7670710 add end
3620:
3621:

Line 3618: l_bank_branch_name HZ_PARTIES.party_name%TYPE;

3614:
3615: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
3616: --Yao Zhang fix bug 7670710 add begin
3617: l_bank_name HZ_PARTIES.party_name%TYPE;
3618: l_bank_branch_name HZ_PARTIES.party_name%TYPE;
3619: --Yao Zhang fix bug#7670710 add end
3620:
3621:
3622: TYPE l_string_tbl IS TABLE OF VARCHAR2(1000);

Line 3659: , HZ_PARTIES CUST_PARTY

3655: , CUST_PARTY.ORGANIZATION_NAME_PHONETIC
3656: , CUST_PARTY.PARTY_ID
3657: FROM
3658: HZ_CUST_ACCOUNTS CUST
3659: , HZ_PARTIES CUST_PARTY
3660: WHERE cust.party_id = cust_party.party_id
3661: AND cust.account_number BETWEEN p_num_from AND p_num_to
3662: --AND cust_party.party_name BETWEEN p_name_from AND p_name_to--yao zhang delete for bug 8230998
3663: AND cust_party.party_name BETWEEN p_name_from

Line 3693: , HZ_PARTIES BR

3689: ,br.organization_name_phonetic) bank_branch_name
3690: FROM
3691: IBY_PMT_INSTR_USES_ALL ExtPartyInstrumentsEO
3692: , IBY_EXT_BANK_ACCOUNTS ibybanks
3693: , HZ_PARTIES BR
3694: , HZ_PARTIES BP
3695: WHERE ibybanks.EXT_BANK_ACCOUNT_ID = ExtPartyInstrumentsEO.instrument_id
3696: AND ExtPartyInstrumentsEO.INSTRUMENT_TYPE = 'BANKACCOUNT'
3697: AND ExtPartyInstrumentsEO.EXT_PMT_PARTY_ID = p_ext_payer_id

Line 3694: , HZ_PARTIES BP

3690: FROM
3691: IBY_PMT_INSTR_USES_ALL ExtPartyInstrumentsEO
3692: , IBY_EXT_BANK_ACCOUNTS ibybanks
3693: , HZ_PARTIES BR
3694: , HZ_PARTIES BP
3695: WHERE ibybanks.EXT_BANK_ACCOUNT_ID = ExtPartyInstrumentsEO.instrument_id
3696: AND ExtPartyInstrumentsEO.INSTRUMENT_TYPE = 'BANKACCOUNT'
3697: AND ExtPartyInstrumentsEO.EXT_PMT_PARTY_ID = p_ext_payer_id
3698: AND ExtPartyInstrumentsEO.PAYMENT_FUNCTION = 'CUSTOMER_PAYMENT'

Line 3724: , HZ_PARTIES BR

3720: ,br.organization_name_phonetic) bank_branch_name
3721: FROM
3722: IBY_PMT_INSTR_USES_ALL ExtPartyInstrumentsEO
3723: , IBY_EXT_BANK_ACCOUNTS ibybanks
3724: , HZ_PARTIES BR
3725: , HZ_PARTIES BP
3726: WHERE ibybanks.EXT_BANK_ACCOUNT_ID = ExtPartyInstrumentsEO.instrument_id
3727: AND ExtPartyInstrumentsEO.INSTRUMENT_TYPE = 'BANKACCOUNT'
3728: AND ExtPartyInstrumentsEO.EXT_PMT_PARTY_ID = p_ext_payer_id

Line 3725: , HZ_PARTIES BP

3721: FROM
3722: IBY_PMT_INSTR_USES_ALL ExtPartyInstrumentsEO
3723: , IBY_EXT_BANK_ACCOUNTS ibybanks
3724: , HZ_PARTIES BR
3725: , HZ_PARTIES BP
3726: WHERE ibybanks.EXT_BANK_ACCOUNT_ID = ExtPartyInstrumentsEO.instrument_id
3727: AND ExtPartyInstrumentsEO.INSTRUMENT_TYPE = 'BANKACCOUNT'
3728: AND ExtPartyInstrumentsEO.EXT_PMT_PARTY_ID = p_ext_payer_id
3729: AND ExtPartyInstrumentsEO.PAYMENT_FUNCTION = 'CUSTOMER_PAYMENT'

Line 3808: , HZ_PARTIES CUST_PARTY

3804: INTO
3805: l_count
3806: FROM
3807: HZ_CUST_ACCOUNTS CUST
3808: , HZ_PARTIES CUST_PARTY
3809: WHERE cust.party_id = cust_party.party_id
3810: AND cust.account_number BETWEEN l_customer_num_from AND l_customer_num_to
3811: -- AND cust_party.party_name BETWEEN l_customer_name_from AND l_customer_name_to--yao zhang delete for bug 8230998
3812: AND cust_party.party_name BETWEEN l_customer_name_from

Line 4093: ,HZ_PARTIES BR

4089: , bp.party_name bank_name --add by Yao Zhang for bug#7670710
4090: , br.party_name bank_branch_name --add by Yao Zhang for bug#7670710
4091: FROM IBY_PMT_INSTR_USES_ALL ExtPartyInstrumentsEO
4092: , IBY_EXT_BANK_ACCOUNTS ibybanks
4093: ,HZ_PARTIES BR
4094: ,HZ_PARTIES BP
4095: WHERE ibybanks.EXT_BANK_ACCOUNT_ID = ExtPartyInstrumentsEO.instrument_id
4096: AND ExtPartyInstrumentsEO.INSTRUMENT_TYPE = 'BANKACCOUNT'
4097: AND ExtPartyInstrumentsEO.EXT_PMT_PARTY_ID = l_ext_payer_id

Line 4094: ,HZ_PARTIES BP

4090: , br.party_name bank_branch_name --add by Yao Zhang for bug#7670710
4091: FROM IBY_PMT_INSTR_USES_ALL ExtPartyInstrumentsEO
4092: , IBY_EXT_BANK_ACCOUNTS ibybanks
4093: ,HZ_PARTIES BR
4094: ,HZ_PARTIES BP
4095: WHERE ibybanks.EXT_BANK_ACCOUNT_ID = ExtPartyInstrumentsEO.instrument_id
4096: AND ExtPartyInstrumentsEO.INSTRUMENT_TYPE = 'BANKACCOUNT'
4097: AND ExtPartyInstrumentsEO.EXT_PMT_PARTY_ID = l_ext_payer_id
4098: AND ExtPartyInstrumentsEO.PAYMENT_FUNCTION = 'CUSTOMER_PAYMENT'