[Home] [Help]
79: --It also validates workorder's RTS flag, WO state, and reservation for this WO as valid supply in mtl_reservation table.
80: CURSOR get_workorder_quantity(c_wip_entity_id IN NUMBER, c_source_type IN NUMBER) IS
81: SELECT 1
82: FROM
83: ahl_workorders wo, ahl_visit_tasks_b vts
84: WHERE
85: wo.wip_entity_id = c_wip_entity_id
86: 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
87: AND vts.visit_task_id = wo.visit_task_id
390: AND Operation_sequence = c_oper_seq_num
391: AND status = 'ACTIVE'
392: AND requested_quantity <>0
393: AND visit_task_id = ( SELECT aw.visit_task_id
394: FROM ahl_visit_tasks_b vt, ahl_workorders aw
395: WHERE vt.status_code IN ('PLANNING','RELEASED')
396: AND aw.wip_entity_id = c_wip_entity_id
397: AND aw.status_code in ('1','3')
398: AND aw.visit_task_id= vt.visit_task_id );
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