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 IBY_EXT_BANK_ACCOUNTS

Line 3563: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NAME%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;
3564: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;
3565: l_address AR_ADDRESSES_V.concatenated_address%TYPE;
3566: l_address_phonenumber AR_ADDRESSES_V.concatenated_address%TYPE;
3567:

Line 3564: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%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;
3564: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;
3565: l_address AR_ADDRESSES_V.concatenated_address%TYPE;
3566: l_address_phonenumber AR_ADDRESSES_V.concatenated_address%TYPE;
3567:
3568: l_party_site_id hz_party_sites.party_site_id%TYPE;

Line 3692: , IBY_EXT_BANK_ACCOUNTS ibybanks

3688: ,br.party_name
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'

Line 3723: , IBY_EXT_BANK_ACCOUNTS ibybanks

3719: ,br.party_name
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'

Line 4092: , IBY_EXT_BANK_ACCOUNTS ibybanks

4088: , ibybanks.bank_account_num
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'