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_ITEMS

Line 213: okc_k_items itm,

209: IS
210: SELECT PSE.PARTY_SITE_ID ID1
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)

Line 234: okc_k_items itm,

230: IS
231: SELECT B.INVENTORY_ITEM_ID ID1
232: FROM OKC_K_PARTY_ROLES_B rle,
233: OKC_K_HEADERS_ALL_V hdr1,
234: okc_k_items itm,
235: MTL_SYSTEM_ITEMS_B_KFV B,
236: MTL_SYSTEM_ITEMS_TL T
237: WHERE rle.jtot_object1_code='OKX_PARTY'
238: and rle.object1_id1 =to_number(p_party_id)

Line 257: okc_k_items itm,

253: IS
254: SELECT B.SYSTEM_ID ID1
255: FROM OKC_K_PARTY_ROLES_B rle,
256: OKC_K_HEADERS_ALL_V hdr1,
257: okc_k_items itm,
258: CS_SYSTEMS_ALL_B B,
259: CS_SYSTEMS_ALL_TL T
260: WHERE rle.jtot_object1_code='OKX_PARTY'
261: and rle.object1_id1 =to_number(p_party_id)

Line 278: okc_k_items itm,

274: IS
275: SELECT CP.INSTANCE_ID ID1
276: FROM OKC_K_PARTY_ROLES_B rle,
277: OKC_K_HEADERS_ALL_B hdr1,
278: okc_k_items itm,
279: CSI_ITEM_INSTANCES CP,
280: MTL_SYSTEM_ITEMS_B_KFV BK
281: WHERE rle.jtot_object1_code = 'OKX_PARTY'
282: and rle.object1_id1 = p_party_id

Line 541: okc_k_items itm,

537: SUBSTR(arp_addr_label_pkg.format_address(NULL,LCN.ADDRESS1,LCN.ADDRESS2,LCN.ADDRESS3,LCN.ADDRESS4,
538: LCN.CITY,LCN.COUNTY,LCN.STATE,LCN.PROVINCE,LCN.POSTAL_CODE,NULL,LCN.COUNTRY,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',80,1,1),1,80) DESCRIPTION
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)

Line 644: okc_k_items itm,

640: T.DESCRIPTION NAME,
641: B.CONCATENATED_SEGMENTS DESCRIPTION
642: FROM OKC_K_PARTY_ROLES_B rle,
643: OKC_K_HEADERS_ALL_V hdr1,
644: okc_k_items itm,
645: MTL_SYSTEM_ITEMS_B_KFV B,
646: MTL_SYSTEM_ITEMS_TL T
647: WHERE rle.jtot_object1_code='OKX_PARTY'
648: and rle.object1_id1 =to_number(p_party_id)

Line 751: okc_k_items itm,

747: T.NAME NAME,
748: T.DESCRIPTION DESCRIPTION
749: FROM OKC_K_PARTY_ROLES_B rle,
750: OKC_K_HEADERS_ALL_V hdr1,
751: okc_k_items itm,
752: CS_SYSTEMS_ALL_B B,
753: CS_SYSTEMS_ALL_TL T
754: WHERE rle.jtot_object1_code='OKX_PARTY'
755: and rle.object1_id1 =to_number(p_party_id)

Line 856: OKC_K_ITEMS itm,

852: BK.DESCRIPTION NAME,
853: BK.CONCATENATED_SEGMENTS || '-' || CP.instance_number DESCRIPTION
854: FROM OKC_K_PARTY_ROLES_B rle,
855: OKC_K_HEADERS_ALL_B hdr1,
856: OKC_K_ITEMS itm,
857: CSI_ITEM_INSTANCES CP,
858: MTL_SYSTEM_ITEMS_B_KFV BK
859: WHERE rle.jtot_object1_code = 'OKX_PARTY'
860: and rle.object1_id1 = p_party_id

Line 1500: okc_k_items itm,

1496: ln.lse_id LseID,
1497: itm.number_of_items Quantity
1498: FROM
1499: MTL_SYSTEM_ITEMS_KFV sys,
1500: okc_k_items itm,
1501: okc_k_lines_v ln
1502: WHERE
1503: ln.DNZ_CHR_ID=p_contract_id
1504: AND ln.lse_id IN (1,12,14,19)

Line 2626: okc_k_items itm,

2622: itm.object1_id1 ObjId1,
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)

Line 2649: okc_k_items itm,

2645: itm.object1_id1 ObjId1,
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

Line 2960: OKC_K_ITEMS itm,

2956: Select
2957: ln.ID BusProcessID,
2958: bus.NAME Name
2959: From
2960: OKC_K_ITEMS itm,
2961: OKX_BUS_PROCESSES_V bus,
2962: OKC_K_LINES_V ln
2963: Where
2964: ln.CLE_ID = to_number(p_coverage_ID_arg)

Line 3387: OKC_K_ITEMS itm,

3383: From
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)

Line 3746: OKC_K_ITEMS okcItms,

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,
3747: MTL_UNITS_OF_MEASURE_TL mtl
3748: WHERE sub_line.cle_id = to_number(p_line_id_arg)
3749: AND rul.cle_id = sub_line.id
3750: AND okcLnV.cle_id = sub_line.cle_id

Line 3786: OKC_K_ITEMS_V itm,

3782: sys.DESCRIPTION Description
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

Line 3826: OKC_K_ITEMS itm,

3822: sys.DESCRIPTION Description
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

Line 4071: OKC_K_ITEMS KI,

4067: csi_counters_tl cct,
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