[Home] [Help]
921: FROM AHL_RA_CTR_ASSOCIATIONS))
922: OR ( CREATED_FROM_COUNTER_TMPL_ID IN (SELECT SINCE_OVERHAUL_COUNTER_ID
923: FROM AHL_RA_CTR_ASSOCIATIONS)
924: AND EXISTS (SELECT 1
925: FROM CSI_COUNTER_READINGS
926: WHERE COUNTER_ID = l_ctr_values_tbl(n).COUNTER_ID
927: AND NET_READING IS NOT NULL
928: AND DISABLED_FLAG = 'N')
929: )
1226: cv.net_reading,
1227: cv.VALUE_TIMESTAMP,
1228: cv.counter_id
1229: from csi_counter_associations assoc,
1230: csi_counter_readings cv,
1231: csi_counters_vl cb1,
1232: csi_counters_vl cb2
1233: where assoc.source_object_code = 'CP'
1234: and assoc.counter_id = cb2.counter_id
1244: and chg.removal_code in (Select Removal_Code from AHL_RA_SETUPS where setup_code = 'REMOVAL_CODE')
1245: and dis.condition_id in (Select Status_Id from AHL_RA_SETUPS where setup_code = 'ITEM_STATUS')
1246: and chg.mc_relationship_id = to_number(l_path_position_id_tbl(q))
1247: AND ctr.value_timestamp = (Select max(maxcv.value_timestamp)
1248: from csi_counter_readings maxcv
1249: where ctr.counter_id = maxcv.counter_id
1250: and trunc(maxcv.value_timestamp) <= trunc(chg.REMOVAL_DATE))
1251: AND cii.instance_id = chg.removed_instance_id
1252: AND cii.inventory_item_id = l_dtls_inv_item_id_tbl(j)
1294: (SELECT assoc.source_object_id,
1295: cv.net_reading,
1296: cv.VALUE_TIMESTAMP
1297: FROM csi_counter_associations assoc,
1298: csi_counter_readings cv,
1299: csi_counters_vl cb1,
1300: csi_counters_vl cb2
1301: WHERE assoc.source_object_code = 'CP'
1302: AND assoc.counter_id = cb2.counter_id
1303: AND cb1.counter_id = l_active_ctr_id_tbl(p)
1304: AND cb1.CREATED_FROM_COUNTER_TMPL_ID = cb2.CREATED_FROM_COUNTER_TMPL_ID
1305: AND cv.counter_id = cb2.counter_id
1306: AND cv.value_timestamp = (Select max(value_timestamp)
1307: from csi_counter_readings maxcv
1308: where cv.counter_id = maxcv.counter_id)
1309: AND cv.disabled_flag = 'N') ctr
1310: WHERE cii.instance_id = CIIR.subject_id
1311: AND CII.INVENTORY_ITEM_ID = l_dtls_inv_item_id_tbl(j)