eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WSM_NEXT_OPERATIONS_V

Source

View Text - Preformatted


SELECT /* next operation according to the BON */ wo.wip_entity_id, wo.operation_seq_num, to_number(null), /* added to_number so that TO_OPERATION_SEQ_NUM is of datatype Number */ wo2.operation_seq_num + nvl(wp.OP_SEQ_NUM_INCREMENT,10), /* CZH.I_9999 */ bos.operation_seq_num, wo.operation_sequence_id, bos.operation_sequence_id, bso1.operation_code, bso2.operation_code, bos.operation_description, bos.standard_operation_id, bd.department_code, bos.department_id from bom_standard_operations bso1, bom_standard_operations bso2, bom_Departments bd, bom_operation_sequences bos, bom_operational_routings bor, bom_operation_networks bon, wip_operations wo, wip_operations wo2, wip_discrete_jobs wdj, wsm_parameters wp WHERE wo.wip_entity_id = wdj.wip_entity_id and bor.assembly_item_id = decode(wdj.job_type, 1, wdj.primary_item_id, wdj.routing_reference_id) and bos.routing_sequence_id = nvl(wdj.common_routing_sequence_id, wdj.routing_reference_id)/*BBK1550565*/ and bos.routing_sequence_id = nvl(bor.common_routing_sequence_id, bor.routing_sequence_id) and nvl(wdj.routing_revision_date, SYSDATE) >= nvl(bos.effectivity_date, nvl(wdj.routing_revision_date, SYSDATE)) and nvl(wdj.routing_revision_date, SYSDATE) <= nvl(bos.disable_date, nvl(wdj.routing_revision_date, SYSDATE)+1) and nvl(wdj.routing_revision_date, SYSDATE) >= nvl(bon.effectivity_date, nvl(wdj.routing_revision_date, SYSDATE)) /* no use */ and nvl(wdj.routing_revision_date, SYSDATE) <= nvl(bon.disable_date, nvl(wdj.routing_revision_date, SYSDATE)+1) /* no use */ and bso1.standard_operation_id(+) = wo.standard_operation_id and bso2.standard_operation_id(+) = bos.standard_operation_id and bd.department_id = bos.department_id /* BA: CZH.I_OED-2 */ /* CZH: remove calling WSMPUTIL.replacement_op_seq_id and NVL(WSMPUTIL.replacement_op_seq_id(bon.from_op_seq_id, wdj.routing_revision_date), -1) = wo.operation_sequence_id and NVL(WSMPUTIL.replacement_op_seq_id(bon.to_op_seq_id, wdj.routing_revision_date), -1) = bos.operation_sequence_id */ and bon.from_op_seq_id IN ( select b.operation_sequence_id from bom_operation_sequences b, bom_operation_sequences b2 where b.operation_seq_num = b2.operation_seq_num AND b.routing_sequence_id = b2.routing_sequence_id AND b2.operation_sequence_id = wo.operation_sequence_id ) and bon.to_op_seq_id IN ( select b.operation_sequence_id from bom_operation_sequences b, bom_operation_sequences b2 where b.operation_seq_num = b2.operation_seq_num AND b.routing_sequence_id = b2.routing_sequence_id AND b2.operation_sequence_id = bos.operation_sequence_id ) /* EA: CZH.I_OED-2 */ and wo2.wip_entity_id = wo.wip_entity_id and wo2.operation_seq_num = ( select max(operation_seq_num) from wip_operations where wip_entity_id = wo2.wip_entity_id ) and wp.organization_id = wo.organization_id UNION select /* current operation itself */ wo.wip_entity_id, wo.operation_seq_num, to_number(null), /* added to_number so that TO_OPERATION_SEQ_NUM is of datatype Number */ wo.operation_seq_num, bos.operation_seq_num, wo.operation_sequence_id, bos.operation_sequence_id, bso.operation_code, bso.operation_code, NVL(bso.operation_description, bos.operation_description), wo.standard_operation_id, bd.department_code, wo.department_id from bom_operation_sequences bos, bom_standard_operations bso, bom_departments bd, wip_operations wo, wip_discrete_jobs wdj where bos.operation_sequence_id = wo.operation_sequence_id and bso.standard_operation_id(+) = bos.standard_operation_id and wo.wip_entity_id = wdj.wip_entity_id and wo.organization_id = wdj.organization_id and bd.department_id = bos.department_id

View Text - HTML Formatted

SELECT /* NEXT OPERATION ACCORDING TO THE BON */ WO.WIP_ENTITY_ID
, WO.OPERATION_SEQ_NUM
, TO_NUMBER(NULL)
, /* ADDED TO_NUMBER SO THAT TO_OPERATION_SEQ_NUM IS OF DATATYPE NUMBER */ WO2.OPERATION_SEQ_NUM + NVL(WP.OP_SEQ_NUM_INCREMENT
, 10)
, /* CZH.I_9999 */ BOS.OPERATION_SEQ_NUM
, WO.OPERATION_SEQUENCE_ID
, BOS.OPERATION_SEQUENCE_ID
, BSO1.OPERATION_CODE
, BSO2.OPERATION_CODE
, BOS.OPERATION_DESCRIPTION
, BOS.STANDARD_OPERATION_ID
, BD.DEPARTMENT_CODE
, BOS.DEPARTMENT_ID
FROM BOM_STANDARD_OPERATIONS BSO1
, BOM_STANDARD_OPERATIONS BSO2
, BOM_DEPARTMENTS BD
, BOM_OPERATION_SEQUENCES BOS
, BOM_OPERATIONAL_ROUTINGS BOR
, BOM_OPERATION_NETWORKS BON
, WIP_OPERATIONS WO
, WIP_OPERATIONS WO2
, WIP_DISCRETE_JOBS WDJ
, WSM_PARAMETERS WP
WHERE WO.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND BOR.ASSEMBLY_ITEM_ID = DECODE(WDJ.JOB_TYPE
, 1
, WDJ.PRIMARY_ITEM_ID
, WDJ.ROUTING_REFERENCE_ID)
AND BOS.ROUTING_SEQUENCE_ID = NVL(WDJ.COMMON_ROUTING_SEQUENCE_ID
, WDJ.ROUTING_REFERENCE_ID)/*BBK1550565*/
AND BOS.ROUTING_SEQUENCE_ID = NVL(BOR.COMMON_ROUTING_SEQUENCE_ID
, BOR.ROUTING_SEQUENCE_ID)
AND NVL(WDJ.ROUTING_REVISION_DATE
, SYSDATE) >= NVL(BOS.EFFECTIVITY_DATE
, NVL(WDJ.ROUTING_REVISION_DATE
, SYSDATE))
AND NVL(WDJ.ROUTING_REVISION_DATE
, SYSDATE) <= NVL(BOS.DISABLE_DATE
, NVL(WDJ.ROUTING_REVISION_DATE
, SYSDATE)+1)
AND NVL(WDJ.ROUTING_REVISION_DATE
, SYSDATE) >= NVL(BON.EFFECTIVITY_DATE
, NVL(WDJ.ROUTING_REVISION_DATE
, SYSDATE)) /* NO USE */
AND NVL(WDJ.ROUTING_REVISION_DATE
, SYSDATE) <= NVL(BON.DISABLE_DATE
, NVL(WDJ.ROUTING_REVISION_DATE
, SYSDATE)+1) /* NO USE */
AND BSO1.STANDARD_OPERATION_ID(+) = WO.STANDARD_OPERATION_ID
AND BSO2.STANDARD_OPERATION_ID(+) = BOS.STANDARD_OPERATION_ID
AND BD.DEPARTMENT_ID = BOS.DEPARTMENT_ID /* BA: CZH.I_OED-2 */ /* CZH: REMOVE CALLING WSMPUTIL.REPLACEMENT_OP_SEQ_ID
AND NVL(WSMPUTIL.REPLACEMENT_OP_SEQ_ID(BON.FROM_OP_SEQ_ID
, WDJ.ROUTING_REVISION_DATE)
, -1) = WO.OPERATION_SEQUENCE_ID
AND NVL(WSMPUTIL.REPLACEMENT_OP_SEQ_ID(BON.TO_OP_SEQ_ID
, WDJ.ROUTING_REVISION_DATE)
, -1) = BOS.OPERATION_SEQUENCE_ID */
AND BON.FROM_OP_SEQ_ID IN ( SELECT B.OPERATION_SEQUENCE_ID
FROM BOM_OPERATION_SEQUENCES B
, BOM_OPERATION_SEQUENCES B2
WHERE B.OPERATION_SEQ_NUM = B2.OPERATION_SEQ_NUM
AND B.ROUTING_SEQUENCE_ID = B2.ROUTING_SEQUENCE_ID
AND B2.OPERATION_SEQUENCE_ID = WO.OPERATION_SEQUENCE_ID )
AND BON.TO_OP_SEQ_ID IN ( SELECT B.OPERATION_SEQUENCE_ID
FROM BOM_OPERATION_SEQUENCES B
, BOM_OPERATION_SEQUENCES B2
WHERE B.OPERATION_SEQ_NUM = B2.OPERATION_SEQ_NUM
AND B.ROUTING_SEQUENCE_ID = B2.ROUTING_SEQUENCE_ID
AND B2.OPERATION_SEQUENCE_ID = BOS.OPERATION_SEQUENCE_ID ) /* EA: CZH.I_OED-2 */
AND WO2.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
AND WO2.OPERATION_SEQ_NUM = ( SELECT MAX(OPERATION_SEQ_NUM)
FROM WIP_OPERATIONS
WHERE WIP_ENTITY_ID = WO2.WIP_ENTITY_ID )
AND WP.ORGANIZATION_ID = WO.ORGANIZATION_ID UNION SELECT /* CURRENT OPERATION ITSELF */ WO.WIP_ENTITY_ID
, WO.OPERATION_SEQ_NUM
, TO_NUMBER(NULL)
, /* ADDED TO_NUMBER SO THAT TO_OPERATION_SEQ_NUM IS OF DATATYPE NUMBER */ WO.OPERATION_SEQ_NUM
, BOS.OPERATION_SEQ_NUM
, WO.OPERATION_SEQUENCE_ID
, BOS.OPERATION_SEQUENCE_ID
, BSO.OPERATION_CODE
, BSO.OPERATION_CODE
, NVL(BSO.OPERATION_DESCRIPTION
, BOS.OPERATION_DESCRIPTION)
, WO.STANDARD_OPERATION_ID
, BD.DEPARTMENT_CODE
, WO.DEPARTMENT_ID
FROM BOM_OPERATION_SEQUENCES BOS
, BOM_STANDARD_OPERATIONS BSO
, BOM_DEPARTMENTS BD
, WIP_OPERATIONS WO
, WIP_DISCRETE_JOBS WDJ
WHERE BOS.OPERATION_SEQUENCE_ID = WO.OPERATION_SEQUENCE_ID
AND BSO.STANDARD_OPERATION_ID(+) = BOS.STANDARD_OPERATION_ID
AND WO.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND WO.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
AND BD.DEPARTMENT_ID = BOS.DEPARTMENT_ID