View: BOM_STANDARD_OPERATIONS_VAL_V

Product:	BOM - Bills of Material
Description:	Valid standard operations
Implementation/DBA Data:	APPS.BOM_STANDARD_OPERATIONS_VAL_V

View Text

SELECT 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
, BSO.DEFAULT_SUBINVENTORY
, BSO.DEFAULT_LOCATOR_ID
, BSO.CRITICAL_TO_QUALITY
, BSO.VALUE_ADDED
FROM BOM_STANDARD_OPERATIONS BSO
, BOM_DEPARTMENTS BD
WHERE BD.DEPARTMENT_ID = BSO.DEPARTMENT_ID
AND TRUNC(NVL(BD.DISABLE_DATE
, SYSDATE+1)) > TRUNC(SYSDATE)

Columns