[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 |