DBA Data[Home] [Help]

APPS.AHL_INV_RESERVATIONS_GRP dependencies on WIP_DISCRETE_JOBS

Line 410: ahl_workorders wo, ahl_visit_tasks_b vts, wip_discrete_jobs wdj

406: */
407: CURSOR validate_wip_supply(c_wip_entity_id IN NUMBER, c_item_id IN NUMBER, c_organization_id IN NUMBER, c_source_type IN NUMBER) IS
408: SELECT 'X'
409: FROM
410: ahl_workorders wo, ahl_visit_tasks_b vts, wip_discrete_jobs wdj
411: WHERE
412: wdj.wip_entity_id = c_wip_entity_id
413: AND wo.wip_entity_id = wdj.wip_entity_id
414: AND wo.status_code NOT IN (7, 22, 17, 12, 18, 21, 4, 5) -- cancelled, deleted, draft, closed,Deffered,Pending Defer/Cancel Approval, Complete, Complete No-charge