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.MST_AGG_PKG dependencies on HZ_CUST_ACCOUNTS

Line 5803: from hz_cust_accounts hzc,

5799: -- including both customer and carrier, don't care it's customer/carrier
5800: if l_location_source_code = 'HZ' then
5801: select hzp.party_name
5802: into l_owner_name
5803: from hz_cust_accounts hzc,
5804: hz_parties hzp
5805: where hzc.cust_account_id = p_customer_id
5806: and hzc.party_id = hzp.party_id;
5807:

Line 5834: hz_cust_accounts hzca,

5830: select party_name
5831: from hz_locations hzl,
5832: hz_party_sites hzs,
5833: hz_cust_acct_sites_all hzcas,
5834: hz_cust_accounts hzca,
5835: hz_parties hzp,
5836: mst_deliveries md
5837: where md.plan_id = p_plan_id
5838: AND md.delivery_id = p_delivery_id

Line 5892: hz_cust_acct_sites_all hzcas, hz_cust_accounts hzca

5888: SELECT hzp.party_name
5889: FROM hz_parties hzp
5890: WHERE hzp.party_id IN (SELECT hzca.party_id
5891: FROM hz_locations hzl , hz_party_sites hzs,
5892: hz_cust_acct_sites_all hzcas, hz_cust_accounts hzca
5893: WHERE hzl.location_id = p_location_id
5894: AND hzl.location_id = hzs.location_id
5895: AND hzs.party_site_id = hzcas.party_site_id
5896: AND hzcas.cust_account_id = hzca.cust_account_id);

Line 5904: hz_cust_accounts hzca,

5900: select distinct party_name
5901: from hz_locations hzl,
5902: hz_party_sites hzs,
5903: hz_cust_acct_sites_all hzcas,
5904: hz_cust_accounts hzca,
5905: hz_parties hzp
5906: where hzl.location_id = p_location_id
5907: and hzl.location_id = hzs.location_id
5908: and hzs.party_site_id = hzcas.party_site_id