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 OKX_CUSTOMER_ACCOUNTS_V

Line 1307: OKX_CUSTOMER_ACCOUNTS_V cus_b,

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
1311: AND CS.SITE_USE_ID = hdr.BILL_TO_SITE_USE_ID

Line 1327: OKX_CUSTOMER_ACCOUNTS_V cus_b,

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
1331: hdr.ID=p_contract_id

Line 1362: OKX_CUSTOMER_ACCOUNTS_V cus_b,

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
1366: AND CS.SITE_USE_CODE = 'BILL_TO'

Line 1389: OKX_CUSTOMER_ACCOUNTS_V cus_s,

1385: decode(L.STATE,NULL,NULL,' '||L.STATE)||
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,

Line 1519: okx_customer_accounts_v cus,

1515: cus.name AccountName,
1516: cus.description AccountDesc,
1517: cus.party_id Account
1518: FROM
1519: okx_customer_accounts_v cus,
1520: okc_k_lines_v ln
1521: WHERE
1522: ln.DNZ_CHR_ID = p_contract_id
1523: AND ln.id=p_line_id

Line 2229: OKX_CUSTOMER_ACCOUNTS_V cus

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
2233: and cus.ID1 = okcLn.CUST_ACCT_ID

Line 2278: from OKX_CUSTOMER_ACCOUNTS_V

2274: p_itm_obj2_arg VARCHAR2
2275: )
2276: IS
2277: select name
2278: from OKX_CUSTOMER_ACCOUNTS_V
2279: where id1 = to_number(p_itm_obj1_arg) and id2 = p_itm_obj2_arg;
2280: CURSOR cust_prod_cur(
2281: p_itm_obj1_arg VARCHAR2,
2282: p_itm_obj2_arg VARCHAR2