APPS.AHL_CMP_UTIL_PKG dependencies on AHL_VWP_PROJ_PROD_PVT

Line 63: AND MTL.task_id = AHL_VWP_PROJ_PROD_PVT.Get_RB_Transaction_Task(VST.project_id,TSK.project_task_id,VST.visit_id)

59: MTL.physical_location_id = VST.comp_planning_loc_id
60: OR MTL.physical_location_id = VST.comp_inrepair_loc_id
61: )
62: AND MTL.project_id = VST.project_id
63: AND MTL.task_id = AHL_VWP_PROJ_PROD_PVT.Get_RB_Transaction_Task(VST.project_id,TSK.project_task_id,VST.visit_id)
64: AND CSI.inv_locator_id = MTL.inventory_location_id
65: AND CSI.instance_id = c_instance_id
66: AND TSK.task_type_code = 'SUMMARY'
67: AND TSK.status_code NOT IN ('CANCELLED', 'CLOSED', 'DELETED')

Line 524: AND MTL.task_id = AHL_VWP_PROJ_PROD_PVT.Get_RB_Transaction_Task(VST.project_id,TSK.project_task_id,VST.visit_id)

520: WHERE TSK.repair_batch_name = p_repair_batch
521: AND VST.visit_id = TSK.visit_id
522: AND MTL.physical_location_id = VST.comp_planning_loc_id
523: AND MTL.project_id = VST.project_id
524: AND MTL.task_id = AHL_VWP_PROJ_PROD_PVT.Get_RB_Transaction_Task(VST.project_id,TSK.project_task_id,VST.visit_id)
525: AND CII.LOCATION_TYPE_CODE = 'INVENTORY'
526: AND CII.inv_locator_id = MTL.inventory_location_id
527: AND CII.inv_organization_id = VST.organization_id
528: AND CII.inventory_item_id = TSK.inventory_item_id

Line 544: AND MTL.task_id = AHL_VWP_PROJ_PROD_PVT.Get_RB_Transaction_Task(VST.project_id,TSK.project_task_id,VST.visit_id)

540: WHERE TSK.repair_batch_name = p_repair_batch
541: AND VST.visit_id = TSK.visit_id
542: AND MTL.physical_location_id = VST.comp_inrepair_loc_id
543: AND MTL.project_id = VST.project_id
544: AND MTL.task_id = AHL_VWP_PROJ_PROD_PVT.Get_RB_Transaction_Task(VST.project_id,TSK.project_task_id,VST.visit_id)
545: AND CII.LOCATION_TYPE_CODE = 'INVENTORY'
546: AND CII.inv_locator_id = MTL.inventory_location_id
547: AND CII.inv_organization_id = VST.organization_id
548: AND CII.inventory_item_id = TSK.inventory_item_id