[Home] [Help]
305: DEPARTMENT_NAME, OPERATION_ID, OPERATION_CODE, OPERATION_TYPE_CODE,
306: OPERATION_TYPE, STATUS_CODE, STATUS,
307: SCHEDULED_START_DATE, SCHEDULED_END_DATE,
308: ACTUAL_START_DATE, ACTUAL_END_DATE, PLAN_ID
309: FROM AHL_WORKORDER_OPERATIONS_V
310: WHERE WORKORDER_ID = p_WorkorderId
311: AND WORKORDER_OPERATION_ID = NVL(p_WoOperationId, WORKORDER_OPERATION_ID)
312: ORDER BY OPERATION_SEQUENCE_NUM;
313:
589: SELECT
590: DOC.DOCUMENT_NO, DOC.DOCUMENT_TITLE, DOC.ASO_OBJECT_TYPE_DESC, DOC.REVISION_NO,
591: DOC.CHAPTER, DOC.SECTION, DOC.SUBJECT, DOC.PAGE, DOC.FIGURE, DOC.NOTE
592: FROM
593: AHL_WORKORDER_OPERATIONS WOP, ahl_reference_doc_v DOC, AHL_DOC_REVISIONS_B REV
594: WHERE
595: WOP.OPERATION_ID = DOC.ASO_OBJECT_ID
596: AND WOP.WORKORDER_ID = p_WorkorderId
597: AND DOC.ASO_OBJECT_TYPE_CODE = 'OPERATION'
870: AND MFGL.LOOKUP_TYPE(+) = 'BOM_RESOURCE_TYPE'
871: AND MFGL.LOOKUP_CODE(+) = BR.RESOURCE_TYPE;
872:
873: CURSOR get_operation_sequence_csr(p_WoOperationId IN NUMBER)IS
874: SELECT OPERATION_SEQUENCE_NUM FROM ahl_workorder_operations
875: WHERE WORKORDER_OPERATION_ID = p_WoOperationId;
876:
877: CURSOR get_operation_sequences_csr(p_WorkorderId IN NUMBER, p_OperationSequence IN NUMBER)
878: IS
875: WHERE WORKORDER_OPERATION_ID = p_WoOperationId;
876:
877: CURSOR get_operation_sequences_csr(p_WorkorderId IN NUMBER, p_OperationSequence IN NUMBER)
878: IS
879: SELECT OPERATION_SEQUENCE_NUM FROM ahl_workorder_operations
880: WHERE WORKORDER_ID = p_WorkorderId
881: AND OPERATION_SEQUENCE_NUM = NVL(p_OperationSequence, OPERATION_SEQUENCE_NUM);
882:
883: l_PRD_RESOURCE_TXNS_TBL AHL_PRD_RESOURCE_TRANX_PVT.PRD_RESOURCE_TXNS_TBL;
1065: Select plan_id,collection_id from ahl_search_workorders_v
1066: WHERE workorder_id = p_WorkorderId;
1067:
1068: CURSOR get_op_plan_csr(p_WoOperationId IN NUMBER)IS
1069: Select plan_id,collection_id from ahl_workorder_operations_v
1070: WHERE workorder_operation_id = p_WoOperationId;
1071:
1072:
1073:
1099: WO.WO_PART_NUMBER,
1100: WO.ITEM_INSTANCE_NUMBER,
1101: WO.LOT_NUMBER,
1102: WO.SERIAL_NUMBER
1103: FROM AHL_WORKORDER_TASKS_V WO, AHL_WORKORDER_OPERATIONS WOP,
1104: AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH
1105: WHERE WO.MR_ROUTE_ID=AMR.MR_ROUTE_ID (+)
1106: AND AMR.MR_HEADER_ID=AMH.MR_HEADER_ID(+)
1107: AND WO.WORKORDER_ID = WOP.WORKORDER_ID
1374:
1375: l_workorder_operation_id NUMBER;
1376:
1377: CURSOR get_workorder_operation_id_csr(p_WorkorderId IN NUMBER,p_operation_sequence IN NUMBER) IS
1378: Select WORKORDER_OPERATION_ID FROM AHL_WORKORDER_OPERATIONS
1379: WHERE WORKORDER_ID = p_WorkorderId AND
1380: OPERATION_SEQUENCE_NUM = p_operation_sequence;
1381:
1382: BEGIN
1725: )IS
1726:
1727:
1728: CURSOR get_current_obj_ver_csr(p_WoOperationId IN NUMBER)IS
1729: SELECT object_version_number FROM AHL_WORKORDER_OPERATIONS
1730: WHERE WORKORDER_OPERATION_ID = p_WoOperationId;
1731:
1732: l_prd_operation_tbl AHL_PRD_OPERATIONS_PVT.PRD_OPERATION_TBL;
1733: l_Operations OP_TBL_TYPE;