[Home] [Help]
562: -- Get workorder details.
563: -- and get organization id
564: CURSOR ahl_job_csr(p_wo_id in number) IS
565: select job_status_code, organization_id , wip_entity_id
566: --from ahl_workorders_v
567: from ahl_workorder_tasks_v
568: where workorder_id = p_wo_id;
569:
570: /*
1322:
1323: SELECT
1324: NVL(VST.ITEM_INSTANCE_ID, VTS.INSTANCE_ID)
1325: FROM
1326: AHL_WORKORDERS AWOS,
1327: AHL_VISITS_B VST,
1328: AHL_VISIT_TASKS_B VTS
1329: WHERE
1330: AWOS.VISIT_TASK_ID = VTS.VISIT_TASK_ID AND
1477: from csi_item_instances CII
1478: where CII.instance_id = p_instance_id;
1479:
1480: CURSOR get_wip_job_csr(p_workorder_id IN NUMBER) IS
1481: select wip_entity_id from ahl_workorders
1482: where workorder_id = p_workorder_id;
1483: l_wip_job_id NUMBER;
1484:
1485: CURSOR removal_instance_id(p_instance_id IN NUMBER, p_wip_job_id IN NUMBER) IS
2107: from csi_item_instances CII
2108: where CII.instance_id = p_instance_id;
2109:
2110: CURSOR get_wip_job_csr(p_workorder_id IN NUMBER) IS
2111: select wip_entity_id from ahl_workorders
2112: where workorder_id = p_workorder_id;
2113: l_wip_job_id NUMBER;
2114:
2115: CURSOR removal_instance_id(p_instance_id IN NUMBER, p_wip_job_id IN NUMBER) IS
2636:
2637: -- For wip_entity_id for the workorder
2638: CURSOR ahl_wip_entity_csr(p_wo_id in Number) IS
2639: Select AHL.wip_entity_id, WIP.entity_type
2640: --FROM ahl_workorders_v AHL, wip_entities WIP
2641: FROM ahl_search_workorders_v AHL, wip_entities WIP
2642: WHERE AHL.workorder_id = p_wo_id
2643: and WIP.wip_entity_id = AHL.wip_entity_id;
2644:
2739: CURSOR ahl_mtl_txn_param_csr (p_wo_id in number, p_instance_id number) is
2740: SELECT CSI.INVENTORY_ITEM_ID, AHL.organization_id
2741: , CSI.inventory_revision revision, CSI.quantity, CSI.unit_of_measure,
2742: CSI.serial_number, CSI.lot_number
2743: --FROM ahl_workorders_v AHL, csi_item_instances CSI
2744: FROM ahl_workorder_tasks_v AHL, csi_item_instances CSI
2745: Where CSI.instance_id = p_instance_id
2746: --and csi.inv_organization_id = ahl.organization_id
2747: And AHL.workorder_id = p_wo_id;
3086: disp.serial_number, disp.lot_number,
3087: csi.inventory_item_id, vst.organization_id, vst.inv_locator_id,
3088: loc.subinventory_code, awo.operation_sequence_num
3089: FROM ahl_prd_dispositions_b disp, csi_item_instances csi,
3090: ahl_workorders wo, ahl_visits_b vst,
3091: mtl_item_locations_kfv loc, ahl_workorder_operations awo
3092: WHERE disp.instance_id = csi.instance_id
3093: AND disp.part_change_id = p_part_change_id
3094: AND disp.workorder_id = wo.workorder_id
3619:
3620: l_junk VARCHAR2(1);
3621:
3622: CURSOR check_org_csr(p_from_wip_entity NUMBER,p_to_wip_entity NUMBER)IS
3623: SELECT 'x' FROM ahl_workorders A,ahl_workorders B WHERE
3624: A.wip_entity_id = p_from_wip_entity
3625: AND B.wip_entity_id = p_to_wip_entity
3626: AND A.visit_id = B.visit_id;
3627:
4125: l_inactive_item_found BOOLEAN;
4126: l_junk VARCHAR2(1);
4127:
4128: CURSOR is_open_job_instance_csr(p_instance_id IN NUMBER) IS
4129: SELECT 'x' from ahl_visit_tasks_b VST, ahl_workorders WO where
4130: VST.instance_id = p_instance_id
4131: AND VST.visit_task_id = WO.visit_task_id
4132: AND VST.visit_id = WO.visit_id
4133: AND WO.status_code NOT IN ('4','5','7','12','17','22');
4715:
4716: SELECT
4717: NVL(VST.ITEM_INSTANCE_ID, VTS.INSTANCE_ID)
4718: FROM
4719: AHL_WORKORDERS AWOS,
4720: AHL_VISITS_B VST,
4721: AHL_VISIT_TASKS_B VTS
4722: WHERE
4723: AWOS.VISIT_TASK_ID = VTS.VISIT_TASK_ID AND