[Home] [Help]
1338: select
1339: cc.counter_id
1340: from
1341: csi_counters_vl cc,
1342: csi_counter_associations cca,
1343: ahl_unit_effectivities_b ue
1344: where
1345: cc.counter_id (+) = cca.counter_id
1346: and cca.source_object_code = 'CP'
1406: select
1407: cc.counter_id
1408: from
1409: csi_counters_vl cc,
1410: csi_counter_associations cca,
1411: ahl_unit_effectivities_b ue
1412: where
1413: cc.counter_id (+) = cca.counter_id
1414: and cca.source_object_code = 'CP'
2028: */
2029:
2030: /*
2031: SELECT NVL(net_reading, 0)
2032: FROM csi_counter_values_v cv, csi_counter_associations cca, AHL_UNIT_EFFECTIVITIES_APP_V UE
2033: WHERE cca.source_object_code = 'CP'
2034: AND cca.source_object_id = ue.csi_item_instance_id
2035: AND cca.counter_id = cv.counter_id
2036: AND ue.unit_effectivity_id = p_ue_id
2041: -- csi_counter_values_v does not retrieve any row.
2042: -- split above cursor into 2 cursors.
2043: -- SATRAJEN :: Changed for USAF Backporting :: Feb 2012 :: Changed to use only the base table.
2044: SELECT 'x'
2045: FROM CSI_COUNTERS_B CC, csi_counter_associations cca, AHL_UNIT_EFFECTIVITIES_APP_V UE
2046: WHERE cca.source_object_code = 'CP'
2047: AND cca.source_object_id = ue.csi_item_instance_id
2048: AND cca.counter_id = cc.counter_id
2049: AND ue.unit_effectivity_id = p_ue_id
2226: -- csi_counter_values_v does not retrieve any row.
2227: -- split above cursor into 2 cursors.
2228: -- SATRAJEN :: Changed for USAF Backporting :: Feb 2012
2229: SELECT 'x'
2230: FROM CSI_COUNTERS_B CC, csi_counter_associations cca, AHL_UNIT_EFFECTIVITIES_APP_V UE
2231: WHERE cca.source_object_code = 'CP'
2232: AND cca.source_object_id = ue.csi_item_instance_id
2233: AND cca.counter_id = cc.counter_id
2234: AND ue.unit_effectivity_id = p_ue_id
3959: AND CII.INSTANCE_ID = p_instance_id
3960: */
3961: SELECT cc.COUNTER_TEMPLATE_NAME counter_name
3962: FROM csi_counters_vl cc,
3963: csi_counter_associations cca --, CSI_ITEM_INSTANCES CII
3964: WHERE cc.counter_id = cca.counter_id
3965: and cca.source_object_code = 'CP'
3966: and cca.source_object_id = p_instance_id
3967: MINUS
4026: l_fmp_sql := l_fmp_sql || ' mr.mr_effectivity_id in ' || l_fmp_eff;
4027:
4028: -- Counters for the given item instance
4029: --l_inst_sql := ' select distinct counter_name from csi_cp_counters_v';
4030: l_inst_sql := ' select distinct counter_template_name counter_name from csi_counters_vl cc, csi_counter_associations cca ';
4031: l_inst_sql := l_inst_sql || ' where cc.counter_id = cca.counter_id and cca.source_object_code = ''CP'' and cca.source_object_id = :1';
4032:
4033: -- Counters for the Accomplishment
4034: --l_acc_sql := ' select distinct counter_name from csi_cp_counters_v co, ahl_unit_accomplishmnts ua';