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_PARTY_SITES

Line 3303: l_party_site_id hz_party_sites.party_site_id%TYPE;

3299: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;
3300: l_address AR_ADDRESSES_V.concatenated_address%TYPE;
3301: l_address_phonenumber AR_ADDRESSES_V.concatenated_address%TYPE;
3302:
3303: l_party_site_id hz_party_sites.party_site_id%TYPE;
3304: l_customer_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
3305: l_customer_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;
3306:
3307: l_bank_account VARCHAR2(110);

Line 3511: , hz_party_sites party_site

3507: , l_party_site_id
3508: FROM
3509: hz_cust_site_uses_all hcsua
3510: , hz_cust_acct_sites_all addr
3511: , hz_party_sites party_site
3512: , hz_locations loc
3513: , fnd_territories_tl terr
3514: WHERE addr.party_site_id = party_site.party_site_id
3515: AND loc.location_id = party_site.location_id

Line 3543: WHERE owner_table_name='HZ_PARTY_SITES'

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'
3547: AND status = 'A'