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

Line 3296: l_phone_num Hz_Contact_Points.Phone_Number%TYPE;

3292: l_customer_name_phonetic HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3293: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
3294: l_alternate_name HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3295:
3296: l_phone_num Hz_Contact_Points.Phone_Number%TYPE;
3297: l_currency_code JMF_GTA_SYSTEM_PARAMETERS_ALL.Gt_Currency_Code%TYPE;
3298: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NAME%TYPE;
3299: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;
3300: l_address AR_ADDRESSES_V.concatenated_address%TYPE;

Line 3542: Hz_Contact_Points

3538: phone_number
3539: INTO
3540: l_phone_num
3541: FROM
3542: Hz_Contact_Points
3543: WHERE owner_table_name='HZ_PARTY_SITES'
3544: AND owner_table_id=l_party_site_id
3545: AND phone_line_type='GEN'
3546: AND primary_flag='Y'