APPS.AHL_CMP_PVT dependencies on AHL_VISIT_TASKS_VL

Line 2421: FROM AHL_VISIT_TASKS_VL TSK,

2417: FROM (SELECT VST.comp_inrepair_loc_id, VST.project_id,
2418: VST.visit_id,
2419: TSK.project_task_id,
2420: TSK.inventory_item_id
2421: FROM AHL_VISIT_TASKS_VL TSK,
2422: AHL_VISITS_B VST
2423: WHERE TSK.repair_batch_name = p_rprbatch_name_csr
2424: AND VST.visit_id = TSK.visit_id) VISIT_TASK,
2425: MTL_ITEM_LOCATIONS_KFV INRPR_LOC, CSI_ITEM_INSTANCES csi