FND Design Data [Home] [Help]

View: MTL_ABC_CLASSES_VAL_V

Product: INV - Inventory
Description: 10SC ONLY
Implementation/DBA Data: ViewAPPS.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