[Home] [Help]
114: VTS.service_request_id,
115: VTS.service_request_id service_request_number
116: FROM AHL_WORKORDER_TASKS_V WO, PA_PROJECTS_ALL PAA, PA_TASKS PAT,
117: AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH, AHL_ROUTES_B AR, AHL_VISIT_TASKS_B VTS,
118: AHL_VISITS_B VST,AHL_WORKORDERS WOS
119: WHERE WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
120: AND WO.VISIT_ID=VST.VISIT_ID
121: AND WO.MR_ROUTE_ID=AMR.MR_ROUTE_ID (+)
122: AND AMR.MR_HEADER_ID=AMH.MR_HEADER_ID(+)
448: AWOS.workorder_id,
449: asml.inventory_item_id,
450: ASML.organization_id,
451: ASML.scheduled_material_id
452: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
453: WHERE AWOS.visit_task_id = ASML.visit_task_id
454: and ASML.inventory_item_id = MSIK.inventory_item_id
455: and ASML.organization_id = MSIK.organization_id
456: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID
576: SELECT
577: DOC.DOCUMENT_NO, DOC.DOCUMENT_TITLE, DOC.ASO_OBJECT_TYPE_DESC, DOC.REVISION_NO,
578: DOC.CHAPTER, DOC.SECTION, DOC.SUBJECT, DOC.PAGE, DOC.FIGURE, DOC.NOTE
579: FROM
580: AHL_WORKORDERS WO, ahl_reference_doc_v DOC, AHL_DOC_REVISIONS_B REV
581: WHERE
582: WO.ROUTE_ID = DOC.ASO_OBJECT_ID
583: AND WO.WORKORDER_ID = p_WorkorderId
584: AND DOC.ASO_OBJECT_TYPE_CODE = 'ROUTE'
602: SELECT
603: DOC.DOCUMENT_NO, DOC.DOCUMENT_TITLE, DOC.ASO_OBJECT_TYPE_DESC, DOC.REVISION_NO,
604: DOC.CHAPTER, DOC.SECTION, DOC.SUBJECT, DOC.PAGE, DOC.FIGURE, DOC.NOTE
605: FROM
606: AHL_WORKORDERS WO, AHL_VISIT_TASKS_B VST, ahl_reference_doc_v DOC, AHL_DOC_REVISIONS_B REV
607: WHERE
608: WO.VISIT_TASK_ID = VST.VISIT_TASK_ID
609: AND WO.WORKORDER_ID = p_WorkorderId
610: AND VST.MR_ID = DOC.ASO_OBJECT_ID
616: SELECT
617: DOC.DOCUMENT_NO, DOC.DOCUMENT_TITLE, DOC.ASO_OBJECT_TYPE_DESC, DOC.REVISION_NO,
618: DOC.CHAPTER, DOC.SECTION, DOC.SUBJECT, DOC.PAGE, DOC.FIGURE, DOC.NOTE
619: FROM
620: AHL_WORKORDERS WO, CSI_II_RELATIONSHIPS CSI, AHL_VISIT_TASKS_B VTS,
621: ahl_reference_doc_v DOC, AHL_DOC_REVISIONS_B REV
622: WHERE
623: WO.VISIT_TASK_ID = VTS.VISIT_TASK_ID
624: AND WO.WORKORDER_ID = p_WorkorderId
634: SELECT
635: DOC.DOCUMENT_NO, DOC.DOCUMENT_TITLE, DOC.ASO_OBJECT_TYPE_DESC, DOC.REVISION_NO,
636: DOC.CHAPTER, DOC.SECTION, DOC.SUBJECT, DOC.PAGE, DOC.FIGURE, DOC.NOTE
637: FROM
638: AHL_WORKORDERS WO, AHL_PC_ASSOCIATIONS PCA, AHL_VISIT_TASKS_B VTS,
639: ahl_reference_doc_v DOC, AHL_DOC_REVISIONS_B REV
640: WHERE
641: WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
642: AND WO.WORKORDER_ID = p_WorkorderId
1352:
1353: l_workorder_id NUMBER;
1354:
1355: CURSOR get_workorder_id_csr(p_workorder_number IN VARCHAR2) IS
1356: Select WORKORDER_ID FROM AHL_WORKORDERS
1357: WHERE WORKORDER_NAME = p_workorder_number;
1358:
1359: BEGIN
1360: OPEN get_workorder_id_csr(p_WorkorderNumber);
2062: l_api_name CONSTANT VARCHAR2(30) := 'process_workorder';
2063: l_WO_DETAILS_REC WO_DETAILS_REC_TYPE;
2064:
2065: CURSOR get_current_obj_ver_csr(p_WotkorderId IN NUMBER)IS
2066: SELECT object_version_number FROM AHL_WORKORDERS
2067: WHERE WORKORDER_ID = p_WotkorderId;
2068:
2069: BEGIN
2070: -- Standard call to check for call compatibility