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_SM_RESULTING_JOBS_V

Source

View Text - Preformatted


SELECT WSRJ.rowid, WSRJ.transaction_id, WSRJ.wip_entity_name, WSRJ.wip_entity_id, WSRJ.description, WSMT.organization_id, WSRJ.primary_item_id, WSRJ.class_code, WSRJ.start_quantity, decode(WSRJ.job_type, 1, 'STANDARD', 3, 'NON-STANDARD', 'STANDARD'), WSRJ.bom_reference_id, WSRJ.routing_reference_id, WSRJ.common_bom_sequence_id, WSRJ.common_routing_sequence_id, WSRJ.bom_revision, WSRJ.routing_revision, WSRJ.bom_revision_date, WSRJ.routing_revision_date, WSRJ.alternate_bom_designator, WSRJ.alternate_routing_designator, WSRJ.completion_subinventory, WSRJ.completion_locator_id, WO.operation_seq_num, BSO.operation_code, WSRJ.starting_intraoperation_step, WO.standard_operation_id, MFG.meaning, WO.description, BD.department_code, BD.department_id, WSRJ.scheduled_start_date, WSRJ.scheduled_completion_date, WSRJ.demand_class, WSRJ.bonus_acct_id, WSRJ.forward_op_option, WSRJ.last_update_date, WSRJ.last_updated_by, WSRJ.creation_date, WSRJ.created_by, WSRJ.last_update_login, WSRJ.attribute_category, WSRJ.attribute1, WSRJ.attribute2, WSRJ.attribute3, WSRJ.attribute4, WSRJ.attribute5, WSRJ.attribute6, WSRJ.attribute7, WSRJ.attribute8, WSRJ.attribute9, WSRJ.attribute10, WSRJ.attribute11, WSRJ.attribute12, WSRJ.attribute13, WSRJ.attribute14, WSRJ.attribute15, WSRJ.request_id, WSRJ.program_application_id, WSRJ.program_id, WSRJ.program_update_date, WSRJ.net_quantity, WSRJ.coproducts_supply, WSRJ.split_has_update_assy from mfg_lookups MFG, wsm_split_merge_transactions WSMT, wsm_sm_resulting_jobs WSRJ, wip_operations WO, bom_departments BD, bom_standard_operations BSO WHERE WSRJ.transaction_id = WSMT.transaction_id and WO.wip_entity_id = WSRJ.wip_entity_id and WO.organization_id = WSRJ.organization_id and WO.standard_operation_id = BSO.standard_operation_id (+) and BD.department_id = WO.department_id and ( ( ( WSMT.transaction_type_id in (2,6,7) or (WSMT.transaction_type_id = 1 and nvl(WSRJ.split_has_update_assy,0)=0) ) and (WO.operation_seq_num IN (select WSSJ.operation_seq_num from wsm_sm_starting_jobs WSSJ where WSSJ.transaction_id = WSMT.transaction_id and WSSJ.representative_flag = 'Y' ) ) ) OR ( ( WSMT.transaction_type_id in (3,4,5) or (WSMT.transaction_type_id = 1 and WSRJ.split_has_update_assy=1) ) and WSRJ.job_operation_seq_num IS NOT NULL and (WO.operation_seq_num = WSRJ.job_operation_seq_num) ) OR ( ( WSMT.transaction_type_id in (3,5) or (WSMT.transaction_type_id = 1 and WSRJ.split_has_update_assy=1) ) and WSRJ.job_operation_seq_num IS NULL and WSRJ.starting_operation_seq_num IS NULL and (WO.operation_seq_num IN (select WSSJ.operation_seq_num from wsm_sm_starting_jobs WSSJ where WSSJ.transaction_id = WSMT.transaction_id ) ) ) OR ( ( WSMT.transaction_type_id in (3,4,5) or (WSMT.transaction_type_id = 1 and WSRJ.split_has_update_assy=1) ) and WSRJ.job_operation_seq_num IS NULL and WSRJ.starting_operation_seq_num IS NOT NULL and WO.WSM_OP_SEQ_NUM = WSRJ.starting_operation_seq_num) ) and mfg.lookup_type = 'WIP_INTRAOPERATION_STEP' and mfg.lookup_code = WSRJ.starting_intraoperation_step

View Text - HTML Formatted

SELECT WSRJ.ROWID
, WSRJ.TRANSACTION_ID
, WSRJ.WIP_ENTITY_NAME
, WSRJ.WIP_ENTITY_ID
, WSRJ.DESCRIPTION
, WSMT.ORGANIZATION_ID
, WSRJ.PRIMARY_ITEM_ID
, WSRJ.CLASS_CODE
, WSRJ.START_QUANTITY
, DECODE(WSRJ.JOB_TYPE
, 1
, 'STANDARD'
, 3
, 'NON-STANDARD'
, 'STANDARD')
, WSRJ.BOM_REFERENCE_ID
, WSRJ.ROUTING_REFERENCE_ID
, WSRJ.COMMON_BOM_SEQUENCE_ID
, WSRJ.COMMON_ROUTING_SEQUENCE_ID
, WSRJ.BOM_REVISION
, WSRJ.ROUTING_REVISION
, WSRJ.BOM_REVISION_DATE
, WSRJ.ROUTING_REVISION_DATE
, WSRJ.ALTERNATE_BOM_DESIGNATOR
, WSRJ.ALTERNATE_ROUTING_DESIGNATOR
, WSRJ.COMPLETION_SUBINVENTORY
, WSRJ.COMPLETION_LOCATOR_ID
, WO.OPERATION_SEQ_NUM
, BSO.OPERATION_CODE
, WSRJ.STARTING_INTRAOPERATION_STEP
, WO.STANDARD_OPERATION_ID
, MFG.MEANING
, WO.DESCRIPTION
, BD.DEPARTMENT_CODE
, BD.DEPARTMENT_ID
, WSRJ.SCHEDULED_START_DATE
, WSRJ.SCHEDULED_COMPLETION_DATE
, WSRJ.DEMAND_CLASS
, WSRJ.BONUS_ACCT_ID
, WSRJ.FORWARD_OP_OPTION
, WSRJ.LAST_UPDATE_DATE
, WSRJ.LAST_UPDATED_BY
, WSRJ.CREATION_DATE
, WSRJ.CREATED_BY
, WSRJ.LAST_UPDATE_LOGIN
, WSRJ.ATTRIBUTE_CATEGORY
, WSRJ.ATTRIBUTE1
, WSRJ.ATTRIBUTE2
, WSRJ.ATTRIBUTE3
, WSRJ.ATTRIBUTE4
, WSRJ.ATTRIBUTE5
, WSRJ.ATTRIBUTE6
, WSRJ.ATTRIBUTE7
, WSRJ.ATTRIBUTE8
, WSRJ.ATTRIBUTE9
, WSRJ.ATTRIBUTE10
, WSRJ.ATTRIBUTE11
, WSRJ.ATTRIBUTE12
, WSRJ.ATTRIBUTE13
, WSRJ.ATTRIBUTE14
, WSRJ.ATTRIBUTE15
, WSRJ.REQUEST_ID
, WSRJ.PROGRAM_APPLICATION_ID
, WSRJ.PROGRAM_ID
, WSRJ.PROGRAM_UPDATE_DATE
, WSRJ.NET_QUANTITY
, WSRJ.COPRODUCTS_SUPPLY
, WSRJ.SPLIT_HAS_UPDATE_ASSY
FROM MFG_LOOKUPS MFG
, WSM_SPLIT_MERGE_TRANSACTIONS WSMT
, WSM_SM_RESULTING_JOBS WSRJ
, WIP_OPERATIONS WO
, BOM_DEPARTMENTS BD
, BOM_STANDARD_OPERATIONS BSO
WHERE WSRJ.TRANSACTION_ID = WSMT.TRANSACTION_ID
AND WO.WIP_ENTITY_ID = WSRJ.WIP_ENTITY_ID
AND WO.ORGANIZATION_ID = WSRJ.ORGANIZATION_ID
AND WO.STANDARD_OPERATION_ID = BSO.STANDARD_OPERATION_ID (+)
AND BD.DEPARTMENT_ID = WO.DEPARTMENT_ID
AND ( ( ( WSMT.TRANSACTION_TYPE_ID IN (2
, 6
, 7) OR (WSMT.TRANSACTION_TYPE_ID = 1
AND NVL(WSRJ.SPLIT_HAS_UPDATE_ASSY
, 0)=0) )
AND (WO.OPERATION_SEQ_NUM IN (SELECT WSSJ.OPERATION_SEQ_NUM
FROM WSM_SM_STARTING_JOBS WSSJ
WHERE WSSJ.TRANSACTION_ID = WSMT.TRANSACTION_ID
AND WSSJ.REPRESENTATIVE_FLAG = 'Y' ) ) ) OR ( ( WSMT.TRANSACTION_TYPE_ID IN (3
, 4
, 5) OR (WSMT.TRANSACTION_TYPE_ID = 1
AND WSRJ.SPLIT_HAS_UPDATE_ASSY=1) )
AND WSRJ.JOB_OPERATION_SEQ_NUM IS NOT NULL
AND (WO.OPERATION_SEQ_NUM = WSRJ.JOB_OPERATION_SEQ_NUM) ) OR ( ( WSMT.TRANSACTION_TYPE_ID IN (3
, 5) OR (WSMT.TRANSACTION_TYPE_ID = 1
AND WSRJ.SPLIT_HAS_UPDATE_ASSY=1) )
AND WSRJ.JOB_OPERATION_SEQ_NUM IS NULL
AND WSRJ.STARTING_OPERATION_SEQ_NUM IS NULL
AND (WO.OPERATION_SEQ_NUM IN (SELECT WSSJ.OPERATION_SEQ_NUM
FROM WSM_SM_STARTING_JOBS WSSJ
WHERE WSSJ.TRANSACTION_ID = WSMT.TRANSACTION_ID ) ) ) OR ( ( WSMT.TRANSACTION_TYPE_ID IN (3
, 4
, 5) OR (WSMT.TRANSACTION_TYPE_ID = 1
AND WSRJ.SPLIT_HAS_UPDATE_ASSY=1) )
AND WSRJ.JOB_OPERATION_SEQ_NUM IS NULL
AND WSRJ.STARTING_OPERATION_SEQ_NUM IS NOT NULL
AND WO.WSM_OP_SEQ_NUM = WSRJ.STARTING_OPERATION_SEQ_NUM) )
AND MFG.LOOKUP_TYPE = 'WIP_INTRAOPERATION_STEP'
AND MFG.LOOKUP_CODE = WSRJ.STARTING_INTRAOPERATION_STEP