[Home] [Help]
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
283: and rle.rle_code in ('CUSTOMER', 'SUBSCRIBER')
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
861: and rle.rle_code in ('CUSTOMER', 'SUBSCRIBER')
2283: )
2284: IS
2285: select MTL.concatenated_segments
2286: from MTL_SYSTEM_ITEMS_KFV MTL,
2287: CSI_ITEM_INSTANCES CSI
2288: where csi.instance_id = p_itm_obj1_arg
2289: and mtl.inventory_item_id = csi.inventory_item_id
2290: and mtl.organization_id =csi.inv_master_organization_id;
2291:
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
3810: Where ccb.COUNTER_ID = to_number(p_covered_prod_id)
3986: CT.VALUE_TIMESTAMP timestamp
3987: FROM
3988: OKX_COUNTER_GROUPS_V CG ,
3989: OKX_COUNTERS_V CT ,
3990: CSI_ITEM_INSTANCES CII ,
3991: OKX_SYSTEM_ITEMS_V IT
3992: WHERE
3993: CG.COUNTER_GROUP_ID = CT.COUNTER_GROUP_ID
3994: AND CT.USAGE_ITEM_ID IS NOT NULL
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,
4037: csi_counter_associations cca,