APPS.AHL_PRD_WO_PUB dependencies on AHL_WORKORDERS

Line 134: AHL_VISITS_B VST,AHL_WORKORDERS WOS

130: WO.HOLD_REASON_CODE,
131: WO.HOLD_REASON
132: FROM AHL_WORKORDER_TASKS_V WO, PA_PROJECTS_ALL PAA, PA_TASKS PAT,
133: AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH, AHL_ROUTES_B AR, AHL_VISIT_TASKS_B VTS,
134: AHL_VISITS_B VST,AHL_WORKORDERS WOS
135: WHERE WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
136: AND WO.VISIT_ID=VST.VISIT_ID
137: AND WO.MR_ROUTE_ID=AMR.MR_ROUTE_ID (+)
138: AND AMR.MR_HEADER_ID=AMH.MR_HEADER_ID(+)

Line 473: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK

469: AWOS.workorder_id,
470: asml.inventory_item_id,
471: ASML.organization_id,
472: ASML.scheduled_material_id
473: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
474: WHERE AWOS.visit_task_id = ASML.visit_task_id
475: and ASML.inventory_item_id = MSIK.inventory_item_id
476: and ASML.organization_id = MSIK.organization_id
477: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

Line 603: AHL_WORKORDERS WO, AHL_DOCUMENT_ASSOS_V DOC

599: SELECT DISTINCT
600: DOC.DOCUMENT_NO, DOC.DOCUMENT_TITLE, DOC.ASO_OBJECT_TYPE_DESC, DOC.REVISION_NO,
601: DOC.CHAPTER, DOC.SECTION, DOC.SUBJECT, DOC.PAGE, DOC.FIGURE, DOC.NOTE
602: FROM
603: AHL_WORKORDERS WO, AHL_DOCUMENT_ASSOS_V DOC
604: WHERE
605: WO.ROUTE_ID = DOC.ASO_OBJECT_ID
606: AND WO.WORKORDER_ID = p_WorkorderId
607: AND DOC.ASO_OBJECT_TYPE_CODE = 'ROUTE'

Line 625: AHL_WORKORDERS WO, AHL_VISIT_TASKS_B VST, AHL_DOCUMENT_ASSOS_V DOC

621: SELECT DISTINCT
622: DOC.DOCUMENT_NO, DOC.DOCUMENT_TITLE, DOC.ASO_OBJECT_TYPE_DESC, DOC.REVISION_NO,
623: DOC.CHAPTER, DOC.SECTION, DOC.SUBJECT, DOC.PAGE, DOC.FIGURE, DOC.NOTE
624: FROM
625: AHL_WORKORDERS WO, AHL_VISIT_TASKS_B VST, AHL_DOCUMENT_ASSOS_V DOC
626: WHERE
627: WO.VISIT_TASK_ID = VST.VISIT_TASK_ID
628: AND WO.WORKORDER_ID = p_WorkorderId
629: AND VST.MR_ID = DOC.ASO_OBJECT_ID

Line 637: AHL_WORKORDERS WO, CSI_II_RELATIONSHIPS CSI, AHL_VISIT_TASKS_B VTS,

633: SELECT DISTINCT
634: DOC.DOCUMENT_NO, DOC.DOCUMENT_TITLE, DOC.ASO_OBJECT_TYPE_DESC, DOC.REVISION_NO,
635: DOC.CHAPTER, DOC.SECTION, DOC.SUBJECT, DOC.PAGE, DOC.FIGURE, DOC.NOTE
636: FROM
637: AHL_WORKORDERS WO, CSI_II_RELATIONSHIPS CSI, AHL_VISIT_TASKS_B VTS,
638: AHL_DOCUMENT_ASSOS_V DOC
639: WHERE
640: WO.VISIT_TASK_ID = VTS.VISIT_TASK_ID
641: AND WO.WORKORDER_ID = p_WorkorderId

Line 654: AHL_WORKORDERS WO, AHL_PC_ASSOCIATIONS PCA, AHL_VISIT_TASKS_B VTS,

650: SELECT DISTINCT
651: DOC.DOCUMENT_NO, DOC.DOCUMENT_TITLE, DOC.ASO_OBJECT_TYPE_DESC, DOC.REVISION_NO,
652: DOC.CHAPTER, DOC.SECTION, DOC.SUBJECT, DOC.PAGE, DOC.FIGURE, DOC.NOTE
653: FROM
654: AHL_WORKORDERS WO, AHL_PC_ASSOCIATIONS PCA, AHL_VISIT_TASKS_B VTS,
655: AHL_DOCUMENT_ASSOS_V DOC
656: WHERE
657: WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
658: AND WO.WORKORDER_ID = p_WorkorderId

Line 1381: Select WORKORDER_ID FROM AHL_WORKORDERS

1377:
1378: l_workorder_id NUMBER;
1379:
1380: CURSOR get_workorder_id_csr(p_workorder_number IN VARCHAR2) IS
1381: Select WORKORDER_ID FROM AHL_WORKORDERS
1382: WHERE WORKORDER_NAME = p_workorder_number;
1383:
1384: BEGIN
1385: OPEN get_workorder_id_csr(p_WorkorderNumber);

Line 2217: SELECT object_version_number FROM AHL_WORKORDERS

2213: l_api_name CONSTANT VARCHAR2(30) := 'process_workorder';
2214: l_WO_DETAILS_REC WO_DETAILS_REC_TYPE;
2215:
2216: CURSOR get_current_obj_ver_csr(p_WotkorderId IN NUMBER)IS
2217: SELECT object_version_number FROM AHL_WORKORDERS
2218: WHERE WORKORDER_ID = p_WotkorderId;
2219:
2220: BEGIN
2221: