eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_MC_PATH_POSITIONS

Line 2816: SELECT 'X' FROM ahl_mc_path_positions pos

2812: PROCEDURE validate_for_create(p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type)
2813: IS
2814:
2815: CURSOR exist_position_csr(p_path_position_id IN NUMBER, p_workorder_id IN NUMBER) IS
2816: SELECT 'X' FROM ahl_mc_path_positions pos
2817: WHERE pos.path_position_id = p_path_position_id
2818: AND EXISTS
2819: (SELECT pos2.path_pos_common_id FROM ahl_prd_dispositions_b dis, ahl_mc_path_positions pos2
2820: WHERE dis.path_position_id IS NOT NULL

Line 2819: (SELECT pos2.path_pos_common_id FROM ahl_prd_dispositions_b dis, ahl_mc_path_positions pos2

2815: CURSOR exist_position_csr(p_path_position_id IN NUMBER, p_workorder_id IN NUMBER) IS
2816: SELECT 'X' FROM ahl_mc_path_positions pos
2817: WHERE pos.path_position_id = p_path_position_id
2818: AND EXISTS
2819: (SELECT pos2.path_pos_common_id FROM ahl_prd_dispositions_b dis, ahl_mc_path_positions pos2
2820: WHERE dis.path_position_id IS NOT NULL
2821: AND dis.path_position_id = pos2.path_position_id
2822: AND dis.workorder_id = p_workorder_id
2823: AND nvl(dis.status_code, 'dummy') NOT IN ('COMPLETE', 'TERMINATED')

Line 3719: SELECT 'x' FROM ahl_mc_path_positions

3715:
3716: --Validate_Path_Position---------------------------------------------
3717: PROCEDURE validate_path_position(p_path_position_id IN NUMBER) IS
3718: CURSOR path_position_csr(p_path_position_id IN NUMBER) IS
3719: SELECT 'x' FROM ahl_mc_path_positions
3720: WHERE path_position_id = p_path_position_id;
3721:
3722: l_exist VARCHAR(1);
3723: