APPS.AHL_MM_MTL_MGT_PVT dependencies on CSI_COUNTERS_VL

Line 5523: CSI_COUNTERS_VL CC,

5519: FROM CSI_COUNTER_READINGS CCR
5520: WHERE CCR.COUNTER_VALUE_ID = CC.CTR_VAL_MAX_SEQ_NO
5521: AND NVL(CCR.DISABLED_FLAG,'N') = 'N'), 0) NET_READING
5522: FROM CSI_COUNTER_ASSOCIATIONS CCA,
5523: CSI_COUNTERS_VL CC,
5524: AHL_APPLICABLE_INSTANCES APPL_INST
5525: WHERE CCA.COUNTER_ID = CC.COUNTER_ID
5526: AND CCA.SOURCE_OBJECT_CODE = 'CP'
5527: AND CCA.SOURCE_OBJECT_ID = APPL_INST.CSI_ITEM_INSTANCE_ID;

Line 6174: CSI_COUNTERS_VL CS

6170: ELSE
6171: SELECT NVL(MAX(UA.COUNTER_VALUE), 0) COUNTER_VALUE
6172: INTO last_acc_value
6173: FROM AHL_UNIT_ACCOMPLISHMNTS UA,
6174: CSI_COUNTERS_VL CS
6175: WHERE UA.COUNTER_ID = CS.COUNTER_ID
6176: AND UA.UNIT_EFFECTIVITY_ID = l_unit_effectivity_id
6177: AND CS.UOM_CODE = l_eff_mr_tbl(i).UOM_CODE;
6178: END IF;