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 OKC_K_LINES_B

Line 1553: OKC_K_LINES_B okcLn

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
1557: AND PS.LOCATION_ID = L.LOCATION_ID

Line 2223: OKC_K_LINES_B okcLn,

2219: ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL,L.ADDRESS1,L.ADDRESS2,L.ADDRESS3, L.ADDRESS4,L.CITY
2220: ,L.COUNTY,L.STATE,L.PROVINCE,L.POSTAL_CODE,NULL,L.COUNTRY,NULL, NULL,NULL,NULL,NULL,NULL,NULL
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,

Line 2418: OKC_K_LINES_B okcLn,

2414: IS
2415: Select
2416: Fnd.Meaning RenewalType
2417: From
2418: OKC_K_LINES_B okcLn,
2419: FND_LOOKUPS Fnd
2420: Where
2421: okcLn.ID = to_number(p_line_id_arg)
2422: And Fnd.Lookup_Code = okcLn.LINE_RENEWAL_TYPE_CODE

Line 2428: From OKC_K_LINES_B line

2424:
2425: CURSOR line_amount_cur(p_line_id_arg VARCHAR2)
2426: IS
2427: Select nvl(sum(line.PRICE_NEGOTIATED),0) LineAmount, line.currency_code Denomination
2428: From OKC_K_LINES_B line
2429: Where line.CLE_ID = to_number(p_line_id_arg)
2430: Group By line.currency_code;
2431:
2432: CURSOR line_invoice_cur(p_line_id_arg VARCHAR2)

Line 2512: OKC_K_LINES_b ln,

2508: ln.START_DATE CoverageStartDate,
2509: ln.END_DATE CoverageEndDate,
2510: decode(cov.lse_id,15,'Y','N') Warranty_YN
2511: From
2512: OKC_K_LINES_b ln,
2513: OKS_K_LINES_b oks,
2514: OKC_K_LINES_V cov
2515: Where
2516: ln.ID = to_number(p_line_id_arg)

Line 2543: OKC_K_LINES_B ln_c,

2539: ln.END_DATE EndDate,
2540: decode(ln.lse_id,15,'Y','N') Warranty_YN
2541: From
2542: OKC_K_LINES_V ln,
2543: OKC_K_LINES_B ln_c,
2544: OKS_K_LINES_B oksLn
2545: Where
2546: ln_c.CLE_ID = to_number(p_line_id_arg) and
2547: ln.LSE_ID in (2,15,20)

Line 2563: okc_k_lines_b srv,

2559: expcov.START_DATE StartDate,
2560: expcov.END_DATE EndDate,
2561: decode(expcov.lse_id,15,'Y','N') Warranty_YN
2562: from
2563: okc_k_lines_b srv,
2564: oks_k_lines_b oksrv,
2565: oks_k_lines_b okscov,
2566: okc_k_lines_v expcov
2567: Where srv.id = to_number(p_line_id_arg)

Line 2627: okc_k_lines_b ln,

2623: itm.object1_id2 ObjId2,
2624: itm.JTOT_OBJECT1_CODE JtotObj
2625: From
2626: okc_k_items itm,
2627: okc_k_lines_b ln,
2628: okc_k_lines_b lnp
2629: where
2630: lnp.ID = to_number(p_line_id_arg)
2631: and ln.cle_id = lnp.ID

Line 2628: okc_k_lines_b lnp

2624: itm.JTOT_OBJECT1_CODE JtotObj
2625: From
2626: okc_k_items itm,
2627: okc_k_lines_b ln,
2628: okc_k_lines_b lnp
2629: where
2630: lnp.ID = to_number(p_line_id_arg)
2631: and ln.cle_id = lnp.ID
2632: and ln.lse_id in (7,8,9,10,11,18,25,35)

Line 2650: okc_k_lines_b ln,

2646: itm.object1_id2 ObjId2,
2647: itm.JTOT_OBJECT1_CODE JtotObj
2648: From
2649: okc_k_items itm,
2650: okc_k_lines_b ln,
2651: okc_k_lines_b lnp,
2652: okc_line_styles_tl style
2653: where
2654: lnp.ID = to_number(p_line_id_arg)

Line 2651: okc_k_lines_b lnp,

2647: itm.JTOT_OBJECT1_CODE JtotObj
2648: From
2649: okc_k_items itm,
2650: okc_k_lines_b ln,
2651: okc_k_lines_b lnp,
2652: okc_line_styles_tl style
2653: where
2654: lnp.ID = to_number(p_line_id_arg)
2655: and ln.cle_id = lnp.ID

Line 2666: OKC_K_LINES_B okcLn,

2662: IS
2663: Select
2664: Fnd.Meaning RenewalType
2665: From
2666: OKC_K_LINES_B okcLn,
2667: FND_LOOKUPS Fnd
2668: Where
2669: okcLn.Id = p_covered_level_id
2670: AND Fnd.Lookup_Code = okcLn.LINE_RENEWAL_TYPE_CODE

Line 2685: OKC_K_LINES_B ln

2681: OKC_UTIL.GET_NAME_FROM_JTFV(con.jtot_object1_code,con.object1_id1,con.object1_id2) ContactName
2682: from
2683: OKC_CONTACTS_V con,
2684: OKC_K_PARTY_ROLES_B rol,
2685: OKC_K_LINES_B ln
2686: where
2687: ln.ID = to_number(p_line_id_arg)
2688: and rol.cle_id = ln.ID
2689: and rol.dnz_chr_id = ln.dnz_chr_id

Line 2698: FROM OKC_K_LINES_B LINE,

2694: HZP.PARTY_NAME ContactName,
2695: CONT.START_DATE StartDate,
2696: CONT.END_DATE EndDate,
2697: PR.CLE_ID ContractLineID
2698: FROM OKC_K_LINES_B LINE,
2699: OKC_K_PARTY_ROLES_B PR,
2700: FND_LOOKUPS FNDCONT,
2701: OKC_CONTACTS CONT,
2702: HZ_PARTIES HZP,

Line 3329: FROM OKC_K_LINES_B okcline,

3325: ,'PARTNER', hz_party.party_name
3326: ,'PARTY', hz_party.party_name
3327: ) name2
3328:
3329: FROM OKC_K_LINES_B okcline,
3330: JTF_RS_RESOURCE_EXTNS RSC,
3331: OKC_CONTACTS Contacts,
3332: FND_LOOKUPS RoleLookup,
3333: OKC_K_PARTY_ROLES_B PartyRoles,

Line 3357: FROM OKC_K_LINES_B okcline,

3353: SELECT PartyRoles.cle_id businessprocessid
3354: ,PartyRoles.rle_code rlecode
3355: ,RoleLookup.meaning resourcetype
3356: ,resource_group.group_name name2
3357: FROM OKC_K_LINES_B okcline,
3358: JTF_RS_GROUPS_TL resource_group,
3359: OKC_CONTACTS Contacts,
3360: FND_LOOKUPS RoleLookup,
3361: OKC_K_PARTY_ROLES_B PartyRoles

Line 3388: OKC_K_LINES_B ln,

3384: CS_LOOKUPS csl,
3385: OKX_TRANSACTION_TYPES_V trn,
3386: OKX_TXN_BILLING_TYPES_V bil,
3387: OKC_K_ITEMS itm,
3388: OKC_K_LINES_B ln,
3389: OKS_K_LINES_B oksLn
3390: Where
3391: ln.CLE_ID = to_number(p_bus_proc_ID_arg)
3392: AND ln.LSE_ID in (5,23,59) -- Fix #4238239

Line 3410: okc_k_lines_b lines,

3406: bsh.FLAT_RATE,
3407: bsh.PERCENT_OVER_LIST_PRICE
3408:
3409: FROM oks_billrate_schedules bsh ,
3410: okc_k_lines_b lines,
3411: mtl_units_of_measure_tl mtl,
3412: fnd_lookups fnd
3413: WHERE bsh.cle_id = lines.id
3414: and lines.lse_id in (6,24,60)

Line 3665: From OKC_K_LINES_B line

3661:
3662: CURSOR usage_amount_cur(p_line_id_arg VARCHAR2)
3663: IS
3664: Select nvl(sum(line.PRICE_NEGOTIATED),0) LineAmount
3665: From OKC_K_LINES_B line
3666: Where line.CLE_ID = to_number(p_line_id_arg);
3667:
3668: CURSOR get_orgId(p_line_id VARCHAR2)
3669: IS

Line 3671: FROM okc_k_lines_b ln,

3667:
3668: CURSOR get_orgId(p_line_id VARCHAR2)
3669: IS
3670: Select hdr.org_id
3671: FROM okc_k_lines_b ln,
3672: okc_k_headers_All_b hdr
3673: WHERE ln.id = to_number(p_line_id)
3674: AND hdr.id = ln.dnz_chr_id;
3675:

Line 3742: FROM OKC_K_LINES_B sub_line,

3738: to_char(rul.base_reading) NetReading,
3739: '#' Reading,
3740: sub_line.price_negotiated Price,
3741: okcItms.object1_id1 ItemObject1_Id1
3742: FROM OKC_K_LINES_B sub_line,
3743: OKS_K_LINES_B rul,
3744: OKC_K_LINES_V okcLnV,
3745: OKS_K_LINES_V oksLnV,
3746: OKC_K_ITEMS okcItms,

Line 3787: OKC_K_LINES_B ln,

3783: From
3784: OKX_SYSTEM_ITEMS_V sys,
3785: OKC_K_HEADERS_ALL_B hdr,
3786: OKC_K_ITEMS_V itm,
3787: OKC_K_LINES_B ln,
3788: OKX_COUNTER_GROUPS_V cgrp,
3789: OKX_COUNTERS_V ct
3790: Where
3791: ct.ID1 = to_number(p_covered_prod_id)

Line 3827: OKC_K_LINES_B ln,

3823: From
3824: MTL_SYSTEM_ITEMS_B_KFV sys,
3825: OKC_K_HEADERS_ALL_B hdr,
3826: OKC_K_ITEMS itm,
3827: OKC_K_LINES_B ln,
3828: CS_CSI_COUNTER_GROUPS CCG,
3829: csi_counters_b ccb,
3830: csi_counter_associations cca
3831: Where

Line 4013: OKC_K_LINES_B KL ,

4009: CT.VALUE_TIMESTAMP timestamp
4010: FROM
4011: OKX_COUNTER_GROUPS_V CG ,
4012: OKX_COUNTERS_V CT ,
4013: OKC_K_LINES_B KL ,
4014: OKC_K_HEADERS_ALL_B KH
4015: WHERE
4016: CG.COUNTER_GROUP_ID = CT.COUNTER_GROUP_ID
4017: AND CT.USAGE_ITEM_ID IS NOT NULL

Line 4072: OKC_K_LINES_B KL ,

4068: csi_counter_associations cca,
4069: CSI_COUNTER_READINGS CV,
4070: csi_lookups lkup,
4071: OKC_K_ITEMS KI,
4072: OKC_K_LINES_B KL ,
4073: OKC_K_HEADERS_ALL_B KH
4074: WHERE sys.INVENTORY_ITEM_ID = KI.OBJECT1_ID1
4075: and sys.ORGANIZATION_ID = KI.OBJECT1_ID2
4076: AND ccg.template_flag = 'N'