APPS.AHL_UMP_UNITMAINT_PVT dependencies on CSI_COUNTERS_VL

Line 1341: csi_counters_vl cc,

1337:
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

Line 1409: csi_counters_vl cc,

1405:
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

Line 3949: /* Fix for bug# 6956784. Replace CS_COUNTERS with CSI_COUNTERS_VL.

3945: select distinct name counter_name from csi_counter_template_vl co, ahl_mr_intervals mr
3946: where co.counter_id = mr.counter_id
3947: and mr.mr_effectivity_id = p_mr_effectivity_id
3948: intersect
3949: /* Fix for bug# 6956784. Replace CS_COUNTERS with CSI_COUNTERS_VL.
3950: * Use COUNTER_TEMPLATE_NAME for counter name
3951: * Uptake R12 Counters Changes.
3952: SELECT c.name
3953: FROM CS_COUNTERS C, CS_COUNTER_GROUPS CTRGRP, CSI_ITEM_INSTANCES CII--, MTL_SYSTEM_ITEMS_KFV MSITEM

Line 3962: FROM csi_counters_vl cc,

3958: --AND MSITEM.ORGANIZATION_ID = CII.INV_MASTER_ORGANIZATION_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

Line 3971: FROM csi_counters_vl C, ahl_unit_accomplishmnts ua

3967: MINUS
3968: --SELECT c.name counter_name
3969: SELECt c.COUNTER_TEMPLATE_NAME counter_name
3970: --FROM CS_COUNTERS C, ahl_unit_accomplishmnts ua
3971: FROM csi_counters_vl C, ahl_unit_accomplishmnts ua
3972: WHERE c.COUNTER_ID = UA.COUNTER_ID
3973: AND UA.unit_effectivity_id = p_unit_effectivity_id;
3974:
3975: BEGIN

Line 4030: l_inst_sql := ' select distinct counter_template_name counter_name from csi_counters_vl cc, csi_counter_associations cca ';

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';

Line 4035: l_acc_sql := ' select distinct counter_template_name counter_name from csi_counters_vl cc, ahl_unit_accomplishmnts ua';

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';
4035: l_acc_sql := ' select distinct counter_template_name counter_name from csi_counters_vl cc, ahl_unit_accomplishmnts ua';
4036: l_acc_sql := l_acc_sql || ' where ua.unit_effectivity_id = :2';
4037: l_acc_sql := l_acc_sql || ' and ua.counter_id = cc.counter_id';
4038: l_acc_sql := l_acc_sql || ' order by counter_name ';
4039: