DBA Data[Home] [Help]

APPS.OKL_SSC_WF dependencies on HZ_CUST_SITE_USES_ALL

Line 2229: FROM hz_cust_site_uses_all cs,

2225: cs.location bill_to_site,
2226: ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL,L.ADDRESS1,L.ADDRESS2,L.ADDRESS3,
2227: L.ADDRESS4,L.CITY,L.COUNTY,L.STATE,L.PROVINCE,L.POSTAL_CODE,NULL,L.COUNTRY,NULL,
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

Line 2274: FROM HZ_CUST_SITE_USES_ALL CS,

2270: SELECT CS.LOCATION BILL_TO_SITE,
2271: ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL,L.ADDRESS1,L.ADDRESS2,L.ADDRESS3,
2272: L.ADDRESS4,L.CITY,L.COUNTY,L.STATE,L.PROVINCE,L.POSTAL_CODE,NULL,L.COUNTRY,NULL,
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