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.

APPS.OKS_ENTITLEMENTS_WEB dependencies on HZ_LOCATIONS

Line 215: HZ_LOCATIONS LCN

211: FROM OKC_K_PARTY_ROLES_B rle,
212: OKC_K_HEADERS_ALL_V hdr1,
213: okc_k_items itm,
214: HZ_PARTY_SITES PSE,
215: HZ_LOCATIONS LCN
216: WHERE rle.jtot_object1_code ='OKX_PARTY'
217: and rle.object1_id1 =to_number(p_party_id)
218: and rle.rle_code in ('CUSTOMER', 'SUBSCRIBER')
219: AND RLE.CLE_ID IS NULL

Line 543: HZ_LOCATIONS LCN

539: FROM OKC_K_PARTY_ROLES_B rle,
540: OKC_K_HEADERS_ALL_V hdr1,
541: okc_k_items itm,
542: HZ_PARTY_SITES PSE,
543: HZ_LOCATIONS LCN
544: WHERE rle.jtot_object1_code = 'OKX_PARTY'
545: and rle.object1_id1 = to_number(p_party_id)
546: and rle.rle_code in ('CUSTOMER', 'SUBSCRIBER')
547: AND RLE.CLE_ID IS NULL

Line 1305: HZ_LOCATIONS L,

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,
1308: OKC_K_HEADERS_ALL_B hdr,
1309: OKX_COUNTRIES_V okxCountry

Line 1325: HZ_LOCATIONS L,

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

Line 1360: HZ_LOCATIONS L,

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,
1363: OKC_K_HEADERS_ALL_V hdr
1364: WHERE hdr.ID= p_contract_id

Line 1392: HZ_LOCATIONS L,

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
1395: WHERE
1396: hdr.ID=p_contract_id

Line 1551: HZ_LOCATIONS L,

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

Line 2227: HZ_LOCATIONS L,

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