DBA Data[Home] [Help]

APPS.OKL_SSC_WF dependencies on HZ_LOCATIONS

Line 2146: hz_locations l,

2142: NULL,NULL,NULL,NULL,NULL,NULL,'N','N',300,1,1) bill_to_address
2143: FROM hz_cust_site_uses_all cs,
2144: hz_cust_acct_sites_all ca,
2145: hz_party_sites ps,
2146: hz_locations l,
2147: okc_k_headers_all_b contract
2148: WHERE cs.cust_acct_site_id = ca.cust_acct_site_id
2149: AND ca.party_site_id = ps.party_site_id
2150: AND ps.location_id = l.location_id

Line 2191: HZ_LOCATIONS L

2187: NULL,NULL,NULL,NULL,NULL,NULL,'N','N',300,1,1) BILL_TO_ADDRESS
2188: FROM HZ_CUST_SITE_USES_ALL CS,
2189: HZ_CUST_ACCT_SITES_ALL CA,
2190: HZ_PARTY_SITES PS,
2191: HZ_LOCATIONS L
2192: WHERE CS.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID
2193: AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID
2194: AND PS.LOCATION_ID = L.LOCATION_ID
2195: AND L.CONTENT_SOURCE_TYPE = 'USER_ENTERED'