DBA Data[Home] [Help]

APPS.AHL_CMP_PVT dependencies on PA_TASKS

Line 1300: PA_PROJECTS_ALL PRJ, PA_TASKS PRT

1296: PRT.task_number project_task_number,
1297: VST.comp_planning_loc_id,
1298: VST.comp_inrepair_loc_id
1299: FROM AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,
1300: PA_PROJECTS_ALL PRJ, PA_TASKS PRT
1301: WHERE TSK.visit_task_id = c_visit_task_id
1302: AND VST.visit_id = TSK.visit_id
1303: AND PRJ.project_id = VST.project_id
1304: AND PRT.project_id = PRJ.project_id

Line 2338: PA_PROJECTS_ALL PRJ, PA_TASKS PRT

2334: PRT.task_number project_task_number,
2335: VST.comp_inrepair_loc_id,
2336: VST.comp_planning_loc_id
2337: FROM AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,
2338: PA_PROJECTS_ALL PRJ, PA_TASKS PRT
2339: WHERE TSK.repair_batch_name = p_rpr_batch_name_csr
2340: AND VST.visit_id = TSK.visit_id
2341: AND PRJ.project_id = VST.project_id
2342: AND PRT.project_id = PRJ.project_id