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_PARTY_SITES

Line 5832: hz_party_sites hzs,

5828: -- added filter for plan_id
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

Line 5849: hz_party_sites hzs,

5845:
5846: cursor carriers is
5847: select car.freight_code
5848: from hz_locations hzl,
5849: hz_party_sites hzs,
5850: hz_parties hzp,
5851: wsh_carriers car
5852: where hzl.location_id = p_location_id
5853: and hzl.location_id = hzs.location_id

Line 5891: FROM hz_locations hzl , hz_party_sites hzs,

5887: CURSOR customer_account IS
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

Line 5902: hz_party_sites hzs,

5898: /*
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

Line 5915: hz_party_sites hzs,

5911:
5912: cursor carriers is
5913: select car.freight_code
5914: from hz_locations hzl,
5915: hz_party_sites hzs,
5916: hz_parties hzp,
5917: wsh_carriers car
5918: where hzl.location_id = p_location_id
5919: and hzl.location_id = hzs.location_id