DBA Data[Home] [Help]

APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_PART_CHANGES_V

Line 4623: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_PART_CHANGES_V pc

4619: SELECT disp.status_code, disp.trackable_flag,
4620: pc.return_mtl_txn_id mtl_txn_id,
4621: pc.installed_part_change_id install_pc_id,
4622: AHL_PRD_DISP_MTL_TXN_PVT.calculate_txned_qty(disp.disposition_id) mtl_txn_qty
4623: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_PART_CHANGES_V pc
4624: WHERE disp.disposition_id = p_disposition_id
4625: AND disp.part_change_id = pc.part_change_id (+);
4626: */
4627: -- AnRaj: Changed query, Perf Bug#4908609,Issue#5

Line 4635: AHL_PART_CHANGES_V pc

4631: pc.installed_part_change_id install_pc_id,
4632: pc.part_change_type,
4633: AHL_PRD_DISP_MTL_TXN_PVT.calculate_txned_qty(disp.disposition_id) mtl_txn_qty
4634: FROM AHL_PRD_DISPOSITIONS_B disp,
4635: AHL_PART_CHANGES_V pc
4636: WHERE disp.disposition_id = p_disposition_id
4637: AND disp.part_change_id = pc.part_change_id (+);
4638:
4639: --