APPS.AHL_COMPLEX_MX_PVT dependencies on CSI_COUNTERS_B

Line 93: FROM csi_counters_b

89: SELECT unit_effectivity_id,
90: due_date,
91: NVL(AMI_II_COUNTER_ID, UMPCounter_ID) counter_id,
92: (SELECT uom_code
93: FROM csi_counters_b
94: WHERE counter_id = NVL(AMI_II_COUNTER_ID, UMPCounter_ID)
95: ) uom_code,
96: NVL(due_counter_value,0) due_counter_value
97: FROM

Line 141: FROM csi_counters_b

137: SELECT unit_effectivity_id,
138: due_date,
139: NVL(AMI_II_COUNTER_ID, UMPCounter_ID) counter_id,
140: (SELECT uom_code
141: FROM csi_counters_b
142: WHERE counter_id = NVL(AMI_II_COUNTER_ID, UMPCounter_ID)
143: ) uom_code,
144: NVL(due_counter_value,0) due_counter_value
145: FROM

Line 189: FROM CSI_COUNTERS_B CC

185: FROM csi_counter_readings ccr
186: WHERE ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
187: AND NVL(ccr.disabled_flag,'N') = 'N'
188: ),0) net_reading
189: FROM CSI_COUNTERS_B CC
190: WHERE CC.COUNTER_ID = c_counter_id;
191:
192: --Record types
193: c_bg_ue_rec c_get_mindue_BG_UE%ROWTYPE;