DBA Data[Home] [Help]

APPS.AHL_RA_ANALYSER_PVT dependencies on AHL_PART_CHANGES

Line 1199: from ahl_part_changes chg,

1195: -- For deriving l_prob_attrib_c_tmp
1196: Select count(*)
1197: into l_prob_attrib_c_tmp
1198: from (Select chg.removed_instance_id
1199: from ahl_part_changes chg,
1200: csi_item_instances cii,
1201: ahl_prd_dispositions_b dis
1202: where chg.part_change_type IN ('R','S')
1203: and chg.part_change_id = dis.part_change_id

Line 1225: from ahl_part_changes chg,(Select assoc.source_object_id,

1221: Select count(*)
1222: into l_prob_attrib_b_tmp
1223: from (Select chg.removed_instance_id
1224: ,ctr.net_reading
1225: from ahl_part_changes chg,(Select assoc.source_object_id,
1226: cv.net_reading,
1227: cv.VALUE_TIMESTAMP,
1228: cv.counter_id
1229: from csi_counter_associations assoc,