DBA Data[Home] [Help]

APPS.AHL_PRD_UTIL_PKG dependencies on WIP_DISCRETE_JOBS

Line 975: FROM AHL_WORKORDERS WO,wip_discrete_jobs WIP

971: -- cursor to retrieve whether workorder is released
972: CURSOR is_workorders_released(c_wo_id NUMBER)
973: IS
974: SELECT 'x'
975: FROM AHL_WORKORDERS WO,wip_discrete_jobs WIP
976: WHERE WO.wip_entity_id = WIP.wip_entity_id
977: AND WIP.date_released IS NOT NULL AND
978: WO.WORKORDER_ID = c_wo_id;
979: