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_ACCT_SITES_ALL

Line 5833: hz_cust_acct_sites_all hzcas,

5829: cursor customer_account is
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

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 5903: hz_cust_acct_sites_all hzcas,

5899: cursor customer_account is
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