Product: | BOM - Bills of Material |
---|---|
Description: | View for department list of values - only enabled records |
Implementation/DBA Data: | APPS.BOM_DEPARTMENTS_VAL_V |
SELECT BD.DEPARTMENT_ID
, BD.DEPARTMENT_CODE
, BD.DESCRIPTION
, BD.DISABLE_DATE
, BD.ORGANIZATION_ID
, BD.LAST_UPDATE_DATE
, BD.LAST_UPDATED_BY
, BD.CREATION_DATE
, BD.CREATED_BY
, BD.LAST_UPDATE_LOGIN
, BD.DEPARTMENT_CLASS_CODE
, BD.ATTRIBUTE_CATEGORY
, BD.ATTRIBUTE1
, BD.ATTRIBUTE2
, BD.ATTRIBUTE3
, BD.ATTRIBUTE4
, BD.ATTRIBUTE5
, BD.ATTRIBUTE6
, BD.ATTRIBUTE7
, BD.ATTRIBUTE8
, BD.ATTRIBUTE9
, BD.ATTRIBUTE10
, BD.ATTRIBUTE11
, BD.ATTRIBUTE12
, BD.ATTRIBUTE13
, BD.ATTRIBUTE14
, BD.ATTRIBUTE15
, BD.REQUEST_ID
, BD.PROGRAM_APPLICATION_ID
, BD.PROGRAM_ID
, BD.PROGRAM_UPDATE_DATE
, BD.LOCATION_ID
FROM BOM_DEPARTMENTS BD
WHERE TRUNC(NVL(DISABLE_DATE
, SYSDATE + 1)) > TRUNC(SYSDATE)