[Home] [Help]
325: DEPARTMENT_NAME, OPERATION_ID, OPERATION_CODE, OPERATION_TYPE_CODE,
326: OPERATION_TYPE, STATUS_CODE, STATUS,
327: SCHEDULED_START_DATE, SCHEDULED_END_DATE,
328: ACTUAL_START_DATE, ACTUAL_END_DATE, PLAN_ID
329: FROM AHL_WORKORDER_OPERATIONS_V
330: WHERE WORKORDER_ID = p_WorkorderId
331: AND WORKORDER_OPERATION_ID = NVL(p_WoOperationId, WORKORDER_OPERATION_ID)
332: ORDER BY OPERATION_SEQUENCE_NUM;
333:
610: SELECT DISTINCT
611: DOC.DOCUMENT_NO, DOC.DOCUMENT_TITLE, DOC.ASO_OBJECT_TYPE_DESC, DOC.REVISION_NO,
612: DOC.CHAPTER, DOC.SECTION, DOC.SUBJECT, DOC.PAGE, DOC.FIGURE, DOC.NOTE
613: FROM
614: AHL_WORKORDER_OPERATIONS WOP, AHL_DOCUMENT_ASSOS_V DOC
615: WHERE
616: WOP.OPERATION_ID = DOC.ASO_OBJECT_ID
617: AND WOP.WORKORDER_ID = p_WorkorderId
618: AND DOC.ASO_OBJECT_TYPE_CODE = 'OPERATION'
888: AND MFGL.LOOKUP_TYPE(+) = 'BOM_RESOURCE_TYPE'
889: AND MFGL.LOOKUP_CODE(+) = BR.RESOURCE_TYPE;
890:
891: CURSOR get_operation_sequence_csr(p_WoOperationId IN NUMBER)IS
892: SELECT OPERATION_SEQUENCE_NUM FROM ahl_workorder_operations
893: WHERE WORKORDER_OPERATION_ID = p_WoOperationId;
894:
895: CURSOR get_operation_sequences_csr(p_WorkorderId IN NUMBER, p_OperationSequence IN NUMBER)
896: IS
893: WHERE WORKORDER_OPERATION_ID = p_WoOperationId;
894:
895: CURSOR get_operation_sequences_csr(p_WorkorderId IN NUMBER, p_OperationSequence IN NUMBER)
896: IS
897: SELECT OPERATION_SEQUENCE_NUM FROM ahl_workorder_operations
898: WHERE WORKORDER_ID = p_WorkorderId
899: AND OPERATION_SEQUENCE_NUM = NVL(p_OperationSequence, OPERATION_SEQUENCE_NUM);
900:
901: l_PRD_RESOURCE_TXNS_TBL AHL_PRD_RESOURCE_TRANX_PVT.PRD_RESOURCE_TXNS_TBL;
1086: Select plan_id,collection_id from ahl_search_workorders_v
1087: WHERE workorder_id = p_WorkorderId;
1088:
1089: CURSOR get_op_plan_csr(p_WoOperationId IN NUMBER)IS
1090: Select plan_id,collection_id from ahl_workorder_operations_v
1091: WHERE workorder_operation_id = p_WoOperationId;
1092:
1093:
1094:
1120: WO.WO_PART_NUMBER,
1121: WO.ITEM_INSTANCE_NUMBER,
1122: WO.LOT_NUMBER,
1123: WO.SERIAL_NUMBER
1124: FROM AHL_WORKORDER_TASKS_V WO, AHL_WORKORDER_OPERATIONS WOP,
1125: AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH
1126: WHERE WO.MR_ROUTE_ID=AMR.MR_ROUTE_ID (+)
1127: AND AMR.MR_HEADER_ID=AMH.MR_HEADER_ID(+)
1128: AND WO.WORKORDER_ID = WOP.WORKORDER_ID
1399:
1400: l_workorder_operation_id NUMBER;
1401:
1402: CURSOR get_workorder_operation_id_csr(p_WorkorderId IN NUMBER,p_operation_sequence IN NUMBER) IS
1403: Select WORKORDER_OPERATION_ID FROM AHL_WORKORDER_OPERATIONS
1404: WHERE WORKORDER_ID = p_WorkorderId AND
1405: OPERATION_SEQUENCE_NUM = p_operation_sequence;
1406:
1407: BEGIN
1809: )IS
1810:
1811:
1812: CURSOR get_current_obj_ver_csr(p_WoOperationId IN NUMBER)IS
1813: SELECT object_version_number FROM AHL_WORKORDER_OPERATIONS
1814: WHERE WORKORDER_OPERATION_ID = p_WoOperationId;
1815:
1816: l_prd_operation_tbl AHL_PRD_OPERATIONS_PVT.PRD_OPERATION_TBL;
1817: l_Operations OP_TBL_TYPE;