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 MTL_SYSTEM_ITEMS_B_KFV

Line 235: MTL_SYSTEM_ITEMS_B_KFV B,

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)
239: and rle.rle_code in ('CUSTOMER', 'SUBSCRIBER')

Line 280: MTL_SYSTEM_ITEMS_B_KFV BK

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
283: and rle.rle_code in ('CUSTOMER', 'SUBSCRIBER')
284: AND RLE.CLE_ID IS NULL

Line 645: MTL_SYSTEM_ITEMS_B_KFV B,

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)
649: and rle.rle_code in ('CUSTOMER', 'SUBSCRIBER')

Line 858: MTL_SYSTEM_ITEMS_B_KFV BK

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
861: and rle.rle_code in ('CUSTOMER', 'SUBSCRIBER')
862: AND RLE.CLE_ID IS NULL

Line 3805: MTL_SYSTEM_ITEMS_B_KFV sys,

3801: sys.concatenated_segments Name,
3802: cca.SOURCE_OBJECT_CODE||';'||cp.SERIAL_NUMBER||';'||cp.INSTANCE_NUMBER SourceDetails,
3803: sys.DESCRIPTION Description
3804: From
3805: MTL_SYSTEM_ITEMS_B_KFV sys,
3806: CSI_ITEM_INSTANCES cp,
3807: CS_CSI_COUNTER_GROUPS CCG,
3808: csi_counters_b ccb,
3809: csi_counter_associations cca

Line 3824: MTL_SYSTEM_ITEMS_B_KFV sys,

3820: sys.concatenated_segments Name,
3821: cca.SOURCE_OBJECT_CODE||';'||hdr.CONTRACT_NUMBER||';'||hdr.CONTRACT_NUMBER_MODIFIER SourceDetails,
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,

Line 4032: FROM MTL_SYSTEM_ITEMS_B_KFV sys,

4028: CII.INSTANCE_NUMBER referencenumber,
4029: CCB.UOM_CODE uom ,
4030: CV.NET_READING netreading ,
4031: CV.VALUE_TIMESTAMP timestamp
4032: FROM MTL_SYSTEM_ITEMS_B_KFV sys,
4033: CSI_ITEM_INSTANCES CII,
4034: CS_CSI_COUNTER_GROUPS CCG,
4035: csi_counters_b ccb,
4036: csi_counters_tl cct,

Line 4064: FROM MTL_SYSTEM_ITEMS_B_KFV sys,

4060: NULL referencenumber,
4061: CCB.UOM_CODE uom ,
4062: CV.NET_READING netreading ,
4063: CV.VALUE_TIMESTAMP timestamp
4064: FROM MTL_SYSTEM_ITEMS_B_KFV sys,
4065: CS_CSI_COUNTER_GROUPS CCG,
4066: csi_counters_b ccb,
4067: csi_counters_tl cct,
4068: csi_counter_associations cca,