VIEW: APPS.BOM_DEPARTMENTS_VAL_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)