DBA Data[Home] [Help]

APPS.AHL_PRD_UTIL_PKG dependencies on WIP_DISCRETE_JOBS

Line 995: FROM AHL_WORKORDERS WO,wip_discrete_jobs WIP

991: -- cursor to retrieve whether workorder is released
992: CURSOR is_workorders_released(c_wo_id NUMBER)
993: IS
994: SELECT 'x'
995: FROM AHL_WORKORDERS WO,wip_discrete_jobs WIP
996: WHERE WO.wip_entity_id = WIP.wip_entity_id
997: AND WIP.date_released IS NOT NULL AND
998: WO.WORKORDER_ID = c_wo_id;
999: