[Home] [Help]
1159: select
1160: cc.counter_id
1161: from
1162: csi_counters_vl cc,
1163: csi_counter_associations cca,
1164: ahl_unit_effectivities_b ue
1165: where
1166: cc.counter_id (+) = cca.counter_id
1167: and cca.source_object_code = 'CP'
1227: select
1228: cc.counter_id
1229: from
1230: csi_counters_vl cc,
1231: csi_counter_associations cca,
1232: ahl_unit_effectivities_b ue
1233: where
1234: cc.counter_id (+) = cca.counter_id
1235: and cca.source_object_code = 'CP'
1772: */
1773:
1774: /*
1775: SELECT NVL(net_reading, 0)
1776: FROM csi_counter_values_v cv, csi_counter_associations cca, AHL_UNIT_EFFECTIVITIES_APP_V UE
1777: WHERE cca.source_object_code = 'CP'
1778: AND cca.source_object_id = ue.csi_item_instance_id
1779: AND cca.counter_id = cv.counter_id
1780: AND ue.unit_effectivity_id = p_ue_id
1784: -- Added for R12 IB Uptake. If counter does not have any reading,
1785: -- csi_counter_values_v does not retrieve any row.
1786: -- split above cursor into 2 cursors.
1787: SELECT 'x'
1788: FROM CSI_COUNTERS_VL CC, csi_counter_associations cca, AHL_UNIT_EFFECTIVITIES_APP_V UE
1789: WHERE cca.source_object_code = 'CP'
1790: AND cca.source_object_id = ue.csi_item_instance_id
1791: AND cca.counter_id = cc.counter_id
1792: AND ue.unit_effectivity_id = p_ue_id
1966: -- Added for R12 IB Uptake. If counter does not have any reading,
1967: -- csi_counter_values_v does not retrieve any row.
1968: -- split above cursor into 2 cursors.
1969: SELECT 'x'
1970: FROM CSI_COUNTERS_VL CC, csi_counter_associations cca, AHL_UNIT_EFFECTIVITIES_APP_V UE
1971: WHERE cca.source_object_code = 'CP'
1972: AND cca.source_object_id = ue.csi_item_instance_id
1973: AND cca.counter_id = cc.counter_id
1974: AND ue.unit_effectivity_id = p_ue_id
3646: AND CII.INSTANCE_ID = p_instance_id
3647: */
3648: SELECT cc.COUNTER_TEMPLATE_NAME counter_name
3649: FROM csi_counters_vl cc,
3650: csi_counter_associations cca --, CSI_ITEM_INSTANCES CII
3651: WHERE cc.counter_id = cca.counter_id
3652: and cca.source_object_code = 'CP'
3653: and cca.source_object_id = p_instance_id
3654: MINUS
3713: l_fmp_sql := l_fmp_sql || ' mr.mr_effectivity_id in ' || l_fmp_eff;
3714:
3715: -- Counters for the given item instance
3716: --l_inst_sql := ' select distinct counter_name from csi_cp_counters_v';
3717: l_inst_sql := ' select distinct counter_template_name counter_name from csi_counters_vl cc, csi_counter_associations cca ';
3718: 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';
3719:
3720: -- Counters for the Accomplishment
3721: --l_acc_sql := ' select distinct counter_name from csi_cp_counters_v co, ahl_unit_accomplishmnts ua';