VIEW: APPS.BOM_STANDARD_OPERATIONS_V

Source

View Text - Preformatted

SELECT WL.LINE_CODE , BSO.SEQUENCE_NUM , BSO.LINE_ID , BSO.OPERATION_TYPE , BSO.ROWID ROW_ID , BSO.STANDARD_OPERATION_ID , BSO.OPERATION_CODE , BSO.ORGANIZATION_ID , BSO.DEPARTMENT_ID , BD.DEPARTMENT_CODE DEPARTMENT_CODE , BD.DESCRIPTION DEPARTMENT_DESCRIPTION , BD.LOCATION_ID , BSO.LAST_UPDATE_DATE , BSO.LAST_UPDATED_BY , BSO.CREATION_DATE , BSO.CREATED_BY , BSO.LAST_UPDATE_LOGIN , BSO.MINIMUM_TRANSFER_QUANTITY , BSO.COUNT_POINT_TYPE , BSO.OPERATION_DESCRIPTION , BSO.OPTION_DEPENDENT_FLAG , BSO.ATTRIBUTE_CATEGORY , BSO.ATTRIBUTE1 , BSO.ATTRIBUTE2 , BSO.ATTRIBUTE3 , BSO.ATTRIBUTE4 , BSO.ATTRIBUTE5 , BSO.ATTRIBUTE6 , BSO.ATTRIBUTE7 , BSO.ATTRIBUTE8 , BSO.ATTRIBUTE9 , BSO.ATTRIBUTE10 , BSO.ATTRIBUTE11 , BSO.ATTRIBUTE12 , BSO.ATTRIBUTE13 , BSO.ATTRIBUTE14 , BSO.ATTRIBUTE15 , BSO.REQUEST_ID , BSO.PROGRAM_APPLICATION_ID , BSO.PROGRAM_ID , BSO.PROGRAM_UPDATE_DATE , BSO.BACKFLUSH_FLAG , DECODE(BSO.COUNT_POINT_TYPE, 1, 1, 2) COUNT_POINT_FLAG , DECODE(BSO.COUNT_POINT_TYPE, 3, 2, 1) AUTOCHARGE_FLAG , BSO.WMS_TASK_TYPE , BSO.OPERATION_YIELD_ENABLED , BSO.YIELD , BSO.SHUTDOWN_TYPE , ML.MEANING SHUTDOWN_TYPE_VALUE , BSO.DEFAULT_SUBINVENTORY , BSO.DEFAULT_LOCATOR_ID , BSO.LOWEST_ACCEPTABLE_YIELD , BSO.USE_ORG_SETTINGS , BSO.CRITICAL_TO_QUALITY , BSO.QUEUE_MANDATORY_FLAG , BSO.VALUE_ADDED , BSO.RUN_MANDATORY_FLAG , BSO.TO_MOVE_MANDATORY_FLAG , BSO.SHOW_NEXT_OP_BY_DEFAULT , BSO.SHOW_SCRAP_CODE , BSO.SHOW_LOT_ATTRIB , BSO.TRACK_MULTIPLE_RES_USAGE_DATES ,nvl(BSO.CHECK_SKILL,2) CHECK_SKILL FROM BOM_STANDARD_OPERATIONS BSO , BOM_DEPARTMENTS BD , WIP_LINES WL , MFG_LOOKUPS ML WHERE BD.DEPARTMENT_ID = BSO.DEPARTMENT_ID AND WL.LINE_ID(+)=BSO.LINE_ID AND ML.LOOKUP_CODE(+) = TO_NUMBER(BSO.SHUTDOWN_TYPE) AND ML.LOOKUP_TYPE(+) = 'BOM_EAM_SHUTDOWN_TYPE'

View Text - HTML Formatted

SELECT WL.LINE_CODE
, BSO.SEQUENCE_NUM
, BSO.LINE_ID
, BSO.OPERATION_TYPE
, BSO.ROWID ROW_ID
, BSO.STANDARD_OPERATION_ID
, BSO.OPERATION_CODE
, BSO.ORGANIZATION_ID
, BSO.DEPARTMENT_ID
, BD.DEPARTMENT_CODE DEPARTMENT_CODE
, BD.DESCRIPTION DEPARTMENT_DESCRIPTION
, BD.LOCATION_ID
, BSO.LAST_UPDATE_DATE
, BSO.LAST_UPDATED_BY
, BSO.CREATION_DATE
, BSO.CREATED_BY
, BSO.LAST_UPDATE_LOGIN
, BSO.MINIMUM_TRANSFER_QUANTITY
, BSO.COUNT_POINT_TYPE
, BSO.OPERATION_DESCRIPTION
, BSO.OPTION_DEPENDENT_FLAG
, BSO.ATTRIBUTE_CATEGORY
, BSO.ATTRIBUTE1
, BSO.ATTRIBUTE2
, BSO.ATTRIBUTE3
, BSO.ATTRIBUTE4
, BSO.ATTRIBUTE5
, BSO.ATTRIBUTE6
, BSO.ATTRIBUTE7
, BSO.ATTRIBUTE8
, BSO.ATTRIBUTE9
, BSO.ATTRIBUTE10
, BSO.ATTRIBUTE11
, BSO.ATTRIBUTE12
, BSO.ATTRIBUTE13
, BSO.ATTRIBUTE14
, BSO.ATTRIBUTE15
, BSO.REQUEST_ID
, BSO.PROGRAM_APPLICATION_ID
, BSO.PROGRAM_ID
, BSO.PROGRAM_UPDATE_DATE
, BSO.BACKFLUSH_FLAG
, DECODE(BSO.COUNT_POINT_TYPE
, 1
, 1
, 2) COUNT_POINT_FLAG
, DECODE(BSO.COUNT_POINT_TYPE
, 3
, 2
, 1) AUTOCHARGE_FLAG
, BSO.WMS_TASK_TYPE
, BSO.OPERATION_YIELD_ENABLED
, BSO.YIELD
, BSO.SHUTDOWN_TYPE
, ML.MEANING SHUTDOWN_TYPE_VALUE
, BSO.DEFAULT_SUBINVENTORY
, BSO.DEFAULT_LOCATOR_ID
, BSO.LOWEST_ACCEPTABLE_YIELD
, BSO.USE_ORG_SETTINGS
, BSO.CRITICAL_TO_QUALITY
, BSO.QUEUE_MANDATORY_FLAG
, BSO.VALUE_ADDED
, BSO.RUN_MANDATORY_FLAG
, BSO.TO_MOVE_MANDATORY_FLAG
, BSO.SHOW_NEXT_OP_BY_DEFAULT
, BSO.SHOW_SCRAP_CODE
, BSO.SHOW_LOT_ATTRIB
, BSO.TRACK_MULTIPLE_RES_USAGE_DATES
, NVL(BSO.CHECK_SKILL
, 2) CHECK_SKILL
FROM BOM_STANDARD_OPERATIONS BSO
, BOM_DEPARTMENTS BD
, WIP_LINES WL
, MFG_LOOKUPS ML
WHERE BD.DEPARTMENT_ID = BSO.DEPARTMENT_ID
AND WL.LINE_ID(+)=BSO.LINE_ID
AND ML.LOOKUP_CODE(+) = TO_NUMBER(BSO.SHUTDOWN_TYPE)
AND ML.LOOKUP_TYPE(+) = 'BOM_EAM_SHUTDOWN_TYPE'