APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_PART_CHANGES_V

Line 4163: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_PART_CHANGES_V pc

4159: SELECT disp.status_code, disp.trackable_flag,
4160: pc.return_mtl_txn_id mtl_txn_id,
4161: pc.installed_part_change_id install_pc_id,
4162: AHL_PRD_DISP_MTL_TXN_PVT.calculate_txned_qty(disp.disposition_id) mtl_txn_qty
4163: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_PART_CHANGES_V pc
4164: WHERE disp.disposition_id = p_disposition_id
4165: AND disp.part_change_id = pc.part_change_id (+);
4166: */
4167: -- AnRaj: Changed query, Perf Bug#4908609,Issue#5

Line 4175: AHL_PART_CHANGES_V pc

4171: pc.installed_part_change_id install_pc_id,
4172: pc.part_change_type,
4173: AHL_PRD_DISP_MTL_TXN_PVT.calculate_txned_qty(disp.disposition_id) mtl_txn_qty
4174: FROM AHL_PRD_DISPOSITIONS_B disp,
4175: AHL_PART_CHANGES_V pc
4176: WHERE disp.disposition_id = p_disposition_id
4177: AND disp.part_change_id = pc.part_change_id (+);
4178:
4179: --