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.

[Home] [Help]

View: WSM_SM_RESULTING_JOBS_V

Product:	WSM - Shop Floor Management
Description:
Implementation/DBA Data:	APPS.WSM_SM_RESULTING_JOBS_V

View Text

SELECT SM.ROWID
, SM.TRANSACTION_ID
, SM.WIP_ENTITY_NAME
, SM.WIP_ENTITY_ID
, SM.DESCRIPTION
, SM_HD.ORGANIZATION_ID
, SM.PRIMARY_ITEM_ID
, SM.CLASS_CODE
, SM.START_QUANTITY
, DECODE(SM.JOB_TYPE
, 1
, 'STANDARD'
, 3
, 'NON-STANDARD'
, 'STANDARD')
, SM.BOM_REFERENCE_ID
, SM.ROUTING_REFERENCE_ID
, SM.COMMON_BOM_SEQUENCE_ID
, SM.COMMON_ROUTING_SEQUENCE_ID
, SM.BOM_REVISION
, SM.ROUTING_REVISION
, SM.BOM_REVISION_DATE
, SM.ROUTING_REVISION_DATE
, SM.ALTERNATE_BOM_DESIGNATOR
, SM.ALTERNATE_ROUTING_DESIGNATOR
, SM.COMPLETION_SUBINVENTORY
, SM.COMPLETION_LOCATOR_ID
, SM.STARTING_OPERATION_SEQ_NUM
, SM.STARTING_OPERATION_CODE
, SM.STARTING_INTRAOPERATION_STEP
, SM.STARTING_STD_OP_ID
, MFG.MEANING
, BOS.OPERATION_DESCRIPTION
, BD.DEPARTMENT_CODE
, BD.DEPARTMENT_ID
, SM.SCHEDULED_START_DATE
, SM.SCHEDULED_COMPLETION_DATE
, SM.DEMAND_CLASS
, SM.BONUS_ACCT_ID
, SM.FORWARD_OP_OPTION
, SM.LAST_UPDATE_DATE
, SM.LAST_UPDATED_BY
, SM.CREATION_DATE
, SM.CREATED_BY
, SM.LAST_UPDATE_LOGIN
, SM.ATTRIBUTE_CATEGORY
, SM.ATTRIBUTE1
, SM.ATTRIBUTE2
, SM.ATTRIBUTE3
, SM.ATTRIBUTE4
, SM.ATTRIBUTE5
, SM.ATTRIBUTE6
, SM.ATTRIBUTE7
, SM.ATTRIBUTE8
, SM.ATTRIBUTE9
, SM.ATTRIBUTE10
, SM.ATTRIBUTE11
, SM.ATTRIBUTE12
, SM.ATTRIBUTE13
, SM.ATTRIBUTE14
, SM.ATTRIBUTE15
, SM.REQUEST_ID
, SM.PROGRAM_APPLICATION_ID
, SM.PROGRAM_ID
, SM.PROGRAM_UPDATE_DATE
, SM.NET_QUANTITY
, SM.COPRODUCTS_SUPPLY
, SM.SPLIT_HAS_UPDATE_ASSY
FROM MFG_LOOKUPS MFG
, WSM_SPLIT_MERGE_TRANSACTIONS SM_HD
, WSM_SM_RESULTING_JOBS SM
, BOM_OPERATION_SEQUENCES BOS
, BOM_DEPARTMENTS BD
WHERE SM.TRANSACTION_ID = SM_HD.TRANSACTION_ID
AND NVL(SM.COMMON_ROUTING_SEQUENCE_ID
, -9999) = BOS.ROUTING_SEQUENCE_ID
AND NVL(SM.STARTING_OPERATION_SEQ_NUM
, -9999) = BOS.OPERATION_SEQ_NUM (+)
AND NVL(BOS.OPERATION_TYPE
, 1) = 1
AND (SM.ROUTING_REVISION_DATE BETWEEN NVL(BOS.EFFECTIVITY_DATE
, SM.ROUTING_REVISION_DATE)
AND NVL(BOS.DISABLE_DATE
, SM.ROUTING_REVISION_DATE+1) )
AND MFG.LOOKUP_TYPE = 'WIP_INTRAOPERATION_STEP'
AND MFG.LOOKUP_CODE = SM.STARTING_INTRAOPERATION_STEP
AND BOS.DEPARTMENT_ID = BD.DEPARTMENT_ID

Columns

Name
ROW_ID
TRANSACTION_ID
WIP_ENTITY_NAME
WIP_ENTITY_ID
DESCRIPTION
ORGANIZATION_ID
PRIMARY_ITEM_ID
CLASS_CODE
START_QUANTITY
JOB_TYPE
BOM_REFERENCE_ID
ROUTING_REFERENCE_ID
COMMON_BOM_SEQUENCE_ID
COMMON_ROUTING_SEQUENCE_ID
BOM_REVISION
ROUTING_REVISION
BOM_REVISION_DATE
ROUTING_REVISION_DATE
ALTERNATE_BOM_DESIGNATOR
ALTERNATE_ROUTING_DESIGNATOR
COMPLETION_SUBINVENTORY
COMPLETION_LOCATOR_ID
STARTING_OPERATION_SEQ_NUM
STARTING_OPERATION_CODE
STARTING_INTRAOPERATION_STEP
STARTING_STD_OP_ID
STARTING_INTRAOP_STEP_TEXT
OPERATION_DESCRIPTION
DEPARTMENT_CODE
DEPARTMENT_ID
SCHEDULED_START_DATE
SCHEDULED_COMPLETION_DATE
DEMAND_CLASS
BONUS_ACCT_ID
FORWARD_OP_OPTION
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
NET_QUANTITY
COPRODUCTS_SUPPLY
SPLIT_HAS_UPDATE_ASSY