APPS.OKS_ENTITLEMENTS_WEB dependencies on HZ_CUST_SITE_USES_ALL

Line 1303: FROM HZ_CUST_SITE_USES_ALL CS,

1299: CURSOR cntrct_hdr_addr_bill_to_cur(p_contract_id NUMBER)
1300: IS
1301:
1302: SELECT okxCountry.Name BillToCountry
1303: FROM HZ_CUST_SITE_USES_ALL CS,
1304: HZ_PARTY_SITES PS,
1305: HZ_LOCATIONS L,
1306: HZ_CUST_ACCT_SITES_ALL CA,
1307: OKX_CUSTOMER_ACCOUNTS_V cus_b,

Line 1323: FROM HZ_CUST_SITE_USES_ALL CS,

1319: CURSOR cntrct_hdr_addr_ship_to_cur(p_contract_id NUMBER)
1320: IS
1321:
1322: SELECT okxCountry.Name BillToCountry
1323: FROM HZ_CUST_SITE_USES_ALL CS,
1324: HZ_PARTY_SITES PS,
1325: HZ_LOCATIONS L,
1326: HZ_CUST_ACCT_SITES_ALL CA,
1327: OKX_CUSTOMER_ACCOUNTS_V cus_b,

Line 1358: HZ_CUST_SITE_USES_ALL CS,

1354: decode(L.STATE,NULL,NULL,' '||L.STATE)||
1355: decode(L.POSTAL_CODE,NULL,NULL,' '||L.POSTAL_CODE)
1356: BillToCityStateZip
1357: FROM
1358: HZ_CUST_SITE_USES_ALL CS,
1359: HZ_PARTY_SITES PS,
1360: HZ_LOCATIONS L,
1361: HZ_CUST_ACCT_SITES_ALL CA,
1362: OKX_CUSTOMER_ACCOUNTS_V cus_b,

Line 1390: HZ_CUST_SITE_USES_ALL CS,

1386: decode(L.POSTAL_CODE,NULL,NULL,' '||L.POSTAL_CODE)
1387: ShipToCityStateZip
1388: FROM
1389: OKX_CUSTOMER_ACCOUNTS_V cus_s,
1390: HZ_CUST_SITE_USES_ALL CS,
1391: HZ_PARTY_SITES PS,
1392: HZ_LOCATIONS L,
1393: HZ_CUST_ACCT_SITES_ALL CA,
1394: OKC_K_HEADERS_ALL_V hdr

Line 1549: HZ_CUST_SITE_USES_ALL CS,

1545: L.STATE State,
1546: L.POSTAL_CODE ZipCode,
1547: L.COUNTRY Country
1548: FROM
1549: HZ_CUST_SITE_USES_ALL CS,
1550: HZ_PARTY_SITES PS,
1551: HZ_LOCATIONS L,
1552: HZ_CUST_ACCT_SITES_ALL CA,
1553: OKC_K_LINES_B okcLn

Line 2225: HZ_CUST_SITE_USES_ALL CS,

2221: ,'N','N',300,1,1) Address
2222: From
2223: OKC_K_LINES_B okcLn,
2224: OKC_K_HEADERS_ALL_B hdr,
2225: HZ_CUST_SITE_USES_ALL CS,
2226: HZ_PARTY_SITES PS,
2227: HZ_LOCATIONS L,
2228: HZ_CUST_ACCT_SITES_ALL CA,
2229: OKX_CUSTOMER_ACCOUNTS_V cus