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.CSTPMRGL dependencies on HZ_CUST_SITE_USES_ALL

Line 1618: FROM hz_cust_site_uses_all hcsua

1614:
1615: UPDATE CST_MARGIN_SUMMARY temp
1616: SET territory_id =
1617: (SELECT territory_id
1618: FROM hz_cust_site_uses_all hcsua
1619: WHERE NVL(hcsua.org_id, -999) = NVL(l_ou_id, NVL(hcsua.org_id, -999))
1620: AND hcsua.site_use_id = temp.ship_to_site_use_id )
1621: WHERE
1622: ship_to_site_use_id is not null

Line 1675: hz_cust_site_uses_all hcsua,

1671: UPDATE CST_MARGIN_SUMMARY temp
1672: SET bill_to_customer_name =
1673: (SELECT SUBSTRB(hp.party_name,1,50)
1674: FROM hz_cust_accounts hca,
1675: hz_cust_site_uses_all hcsua,
1676: hz_cust_acct_sites_all hcasa,
1677: hz_parties hp
1678: WHERE
1679: NVL(hca.org_id, -999) = NVL(l_ou_id,NVL(hca.org_id, -999))

Line 1701: hz_cust_site_uses_all hcsua,

1697: UPDATE CST_MARGIN_SUMMARY temp
1698: SET ship_to_customer_name =
1699: (SELECT SUBSTRB(hp.party_name,1,50)
1700: FROM hz_cust_accounts hca,
1701: hz_cust_site_uses_all hcsua,
1702: hz_cust_acct_sites_all hcasa,
1703: hz_parties hp
1704: WHERE
1705: NVL(hca.org_id, -999) = NVL(l_ou_id,NVL(hca.org_id, -999))