View: BOM_STANDARD_OPERATIONS_V

Product:	BOM - Bills of Material
Description:	Standard operations
Implementation/DBA Data:	APPS.BOM_STANDARD_OPERATIONS_V

View Text

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'

Columns