[Home] [Help]
View: MTL_ABC_CLASSES_VAL_V
View Text
SELECT "ABC_CLASS_ID"
, "ABC_CLASS_NAME"
, "ORGANIZATION_ID"
, "LAST_UPDATE_DATE"
, "LAST_UPDATED_BY"
, "CREATION_DATE"
, "CREATED_BY"
, "DESCRIPTION"
, "DISABLE_DATE"
, "REQUEST_ID"
, "PROGRAM_APPLICATION_ID"
, "PROGRAM_ID"
, "PROGRAM_UPDATE_DATE"
FROM MTL_ABC_CLASSES
WHERE TRUNC(NVL(DISABLE_DATE
, SYSDATE + 1)) > TRUNC(SYSDATE)
Columns
| Name |
| ABC_CLASS_ID |
| ABC_CLASS_NAME |
| ORGANIZATION_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |
| DESCRIPTION |
| DISABLE_DATE |
| REQUEST_ID |
| PROGRAM_APPLICATION_ID |
| PROGRAM_ID |
| PROGRAM_UPDATE_DATE |