APPS.OKS_ENTITLEMENTS_WEB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1306: HZ_CUST_ACCT_SITES_ALL CA,

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,
1308: OKC_K_HEADERS_ALL_B hdr,
1309: OKX_COUNTRIES_V okxCountry
1310: WHERE hdr.ID=p_contract_id

Line 1326: HZ_CUST_ACCT_SITES_ALL CA,

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,
1328: OKC_K_HEADERS_ALL_B hdr,
1329: OKX_COUNTRIES_V okxCountry
1330: WHERE

Line 1361: HZ_CUST_ACCT_SITES_ALL CA,

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,
1363: OKC_K_HEADERS_ALL_V hdr
1364: WHERE hdr.ID= p_contract_id
1365: AND CS.SITE_USE_ID = hdr.BILL_TO_SITE_USE_ID

Line 1393: HZ_CUST_ACCT_SITES_ALL CA,

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
1395: WHERE
1396: hdr.ID=p_contract_id
1397: AND CS.SITE_USE_ID = hdr.SHIP_TO_SITE_USE_ID

Line 1552: HZ_CUST_ACCT_SITES_ALL CA,

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
1554: WHERE okcLn.id = p_line_id
1555: AND CA.CUST_ACCT_SITE_ID = CS.CUST_ACCT_SITE_ID
1556: AND PS.PARTY_SITE_ID = CA.PARTY_SITE_ID

Line 2228: HZ_CUST_ACCT_SITES_ALL CA,

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
2230: Where
2231: okcLn.id = p_party_roles_cle_id
2232: AND hdr.id = okcLn.dnz_chr_id