DBA Data[Home] [Help]

APPS.AHL_COMPLEX_MX_PVT dependencies on CSI_COUNTERS_VL

Line 102: CSI_COUNTERS_VL ii,

98: (SELECT UMP.unit_effectivity_id,
99: UMP.due_date,
100: (SELECT ii.counter_id
101: FROM CSI_COUNTER_ASSOCIATIONS CCA,
102: CSI_COUNTERS_VL ii,
103: CSI_COUNTER_TEMPLATE_VL tmp
104: WHERE CCA.SOURCE_OBJECT_CODE = 'CP'
105: AND CCA.SOURCE_OBJECT_ID = UMP.CSI_ITEM_INSTANCE_ID
106: AND ii.counter_id = cca.counter_id

Line 150: CSI_COUNTERS_VL ii,

146: (SELECT UMP.unit_effectivity_id,
147: UMP.due_date,
148: (SELECT ii.counter_id
149: FROM CSI_COUNTER_ASSOCIATIONS CCA,
150: CSI_COUNTERS_VL ii,
151: CSI_COUNTER_TEMPLATE_VL tmp
152: WHERE CCA.SOURCE_OBJECT_CODE = 'CP'
153: AND CCA.SOURCE_OBJECT_ID = UMP.CSI_ITEM_INSTANCE_ID
154: AND ii.counter_id = cca.counter_id

Line 785: CSI_COUNTERS_VL CC

781: )
782: INTO l_ctr_uom,
783: l_ctr_reading
784: FROM CSI_COUNTER_ASSOCIATIONS CCA,
785: CSI_COUNTERS_VL CC
786: WHERE CCA.COUNTER_ID = CC.COUNTER_ID
787: AND CCA.SOURCE_OBJECT_ID = p_instance_id
788: AND CCA.SOURCE_OBJECT_CODE = 'CP'
789: AND CC.COUNTER_TEMPLATE_NAME = p_ctr_template_name;