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_ALL_OPERATIONS_V

Source

View Text - Preformatted


SELECT /* all the operations in BON */ wdj.wip_entity_id, 10, bos.operation_seq_num, bos.operation_sequence_id, bso.operation_code, bos.operation_description, bos.standard_operation_id, bd.department_code, bos.department_id from bom_operation_sequences bos, bom_standard_operations bso, bom_operational_routings bor, bom_operation_networks bon, bom_departments bd, wip_discrete_jobs wdj WHERE /* BC: CZH: I_OED-2 */ /* CZH: remove calling WSMPUTIL.replacement_op_seq_id ( NVL(WSMPUTIL.replacement_op_seq_id(bon.from_op_seq_id, wdj.routing_revision_date), -1) = bos.operation_sequence_id or NVL(WSMPUTIL.replacement_op_seq_id(bon.to_op_seq_id, wdj.routing_revision_date), -1) = bos.operation_sequence_id ) */ ( 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 = bos.operation_sequence_id ) or 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 ) ) /* EC: CZH: I_OED-2 */ and bso.standard_operation_id(+) = bos.standard_operation_id and bd.department_id = bos.department_id and bos.routing_sequence_id = nvl(bor.common_routing_sequence_id, bor.routing_sequence_id) and bos.routing_sequence_id = wdj.common_routing_sequence_id and bor.assembly_item_id = decode(wdj.job_type, 1, wdj.primary_item_id, wdj.routing_reference_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)) and nvl(wdj.routing_revision_date, SYSDATE) <= nvl(bon.disable_date, nvl(wdj.routing_revision_date, SYSDATE)+1)

View Text - HTML Formatted

SELECT /* ALL THE OPERATIONS IN BON */ WDJ.WIP_ENTITY_ID
, 10
, BOS.OPERATION_SEQ_NUM
, BOS.OPERATION_SEQUENCE_ID
, BSO.OPERATION_CODE
, BOS.OPERATION_DESCRIPTION
, BOS.STANDARD_OPERATION_ID
, BD.DEPARTMENT_CODE
, BOS.DEPARTMENT_ID
FROM BOM_OPERATION_SEQUENCES BOS
, BOM_STANDARD_OPERATIONS BSO
, BOM_OPERATIONAL_ROUTINGS BOR
, BOM_OPERATION_NETWORKS BON
, BOM_DEPARTMENTS BD
, WIP_DISCRETE_JOBS WDJ
WHERE /* BC: CZH: I_OED-2 */ /* CZH: REMOVE CALLING WSMPUTIL.REPLACEMENT_OP_SEQ_ID ( NVL(WSMPUTIL.REPLACEMENT_OP_SEQ_ID(BON.FROM_OP_SEQ_ID
, WDJ.ROUTING_REVISION_DATE)
, -1) = BOS.OPERATION_SEQUENCE_ID OR NVL(WSMPUTIL.REPLACEMENT_OP_SEQ_ID(BON.TO_OP_SEQ_ID
, WDJ.ROUTING_REVISION_DATE)
, -1) = BOS.OPERATION_SEQUENCE_ID ) */ ( 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 = BOS.OPERATION_SEQUENCE_ID ) OR 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 ) ) /* EC: CZH: I_OED-2 */
AND BSO.STANDARD_OPERATION_ID(+) = BOS.STANDARD_OPERATION_ID
AND BD.DEPARTMENT_ID = BOS.DEPARTMENT_ID
AND BOS.ROUTING_SEQUENCE_ID = NVL(BOR.COMMON_ROUTING_SEQUENCE_ID
, BOR.ROUTING_SEQUENCE_ID)
AND BOS.ROUTING_SEQUENCE_ID = WDJ.COMMON_ROUTING_SEQUENCE_ID
AND BOR.ASSEMBLY_ITEM_ID = DECODE(WDJ.JOB_TYPE
, 1
, WDJ.PRIMARY_ITEM_ID
, WDJ.ROUTING_REFERENCE_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))
AND NVL(WDJ.ROUTING_REVISION_DATE
, SYSDATE) <= NVL(BON.DISABLE_DATE
, NVL(WDJ.ROUTING_REVISION_DATE
, SYSDATE)+1)