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 3239: SELECT 'X' FROM ahl_mc_path_positions pos

3235: PROCEDURE validate_for_create(p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type)
3236: IS
3237:
3238: CURSOR exist_position_csr(p_path_position_id IN NUMBER, p_workorder_id IN NUMBER) IS
3239: SELECT 'X' FROM ahl_mc_path_positions pos
3240: WHERE pos.path_position_id = p_path_position_id
3241: AND EXISTS
3242: (SELECT pos2.path_pos_common_id FROM ahl_prd_dispositions_b dis, ahl_mc_path_positions pos2
3243: WHERE dis.path_position_id IS NOT NULL

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

3238: CURSOR exist_position_csr(p_path_position_id IN NUMBER, p_workorder_id IN NUMBER) IS
3239: SELECT 'X' FROM ahl_mc_path_positions pos
3240: WHERE pos.path_position_id = p_path_position_id
3241: AND EXISTS
3242: (SELECT pos2.path_pos_common_id FROM ahl_prd_dispositions_b dis, ahl_mc_path_positions pos2
3243: WHERE dis.path_position_id IS NOT NULL
3244: AND dis.path_position_id = pos2.path_position_id
3245: AND dis.workorder_id = p_workorder_id
3246: AND nvl(dis.status_code, 'dummy') NOT IN ('COMPLETE', 'TERMINATED')

Line 4179: SELECT 'x' FROM ahl_mc_path_positions

4175:
4176: --Validate_Path_Position---------------------------------------------
4177: PROCEDURE validate_path_position(p_path_position_id IN NUMBER) IS
4178: CURSOR path_position_csr(p_path_position_id IN NUMBER) IS
4179: SELECT 'x' FROM ahl_mc_path_positions
4180: WHERE path_position_id = p_path_position_id;
4181:
4182: l_exist VARCHAR(1);
4183: