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.

[Home] [Help]

APPS.OKL_SSC_WF dependencies on HZ_LOCATIONS

Line 2232: hz_locations l,

2228: NULL,NULL,NULL,NULL,NULL,NULL,'N','N',300,1,1) bill_to_address
2229: FROM hz_cust_site_uses_all cs,
2230: hz_cust_acct_sites_all ca,
2231: hz_party_sites ps,
2232: hz_locations l,
2233: okc_k_headers_all_b contract
2234: WHERE cs.cust_acct_site_id = ca.cust_acct_site_id
2235: AND ca.party_site_id = ps.party_site_id
2236: AND ps.location_id = l.location_id

Line 2277: HZ_LOCATIONS L

2273: NULL,NULL,NULL,NULL,NULL,NULL,'N','N',300,1,1) BILL_TO_ADDRESS
2274: FROM HZ_CUST_SITE_USES_ALL CS,
2275: HZ_CUST_ACCT_SITES_ALL CA,
2276: HZ_PARTY_SITES PS,
2277: HZ_LOCATIONS L
2278: WHERE CS.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID
2279: AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID
2280: AND PS.LOCATION_ID = L.LOCATION_ID
2281: AND L.CONTENT_SOURCE_TYPE = 'USER_ENTERED'