[Home] [Help]
View: MSC_X_ITEM_EXCEPTIONS_V
View Text
SELECT PLAN_ID
, ORGANIZATION_ID
, SR_INSTANCE_ID
, INVENTORY_ITEM_ID
, PROJECT_ID
, TASK_ID
, VERSION
, PLANNING_GROUP
, EXCEPTION_TYPE
, DISPLAY
, EXCEPTION_COUNT
, RESOURCE_ID
, DEPARTMENT_ID
, EXCEPTION_GROUP
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SUPPLIER_ID
, SUPPLIER_SITE_ID
FROM MSC_ITEM_EXCEPTIONS
WHERE NVL(VERSION
, -1) = 0
AND SR_INSTANCE_ID = -1
Columns
Name |
PLAN_ID |
ORGANIZATION_ID |
SR_INSTANCE_ID |
INVENTORY_ITEM_ID |
PROJECT_ID |
TASK_ID |
VERSION |
PLANNING_GROUP |
EXCEPTION_TYPE |
DISPLAY |
EXCEPTION_COUNT |
RESOURCE_ID |
DEPARTMENT_ID |
EXCEPTION_GROUP |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
REQUEST_ID |
PROGRAM_APPLICATION_ID |
PROGRAM_ID |
PROGRAM_UPDATE_DATE |
SUPPLIER_ID |
SUPPLIER_SITE_ID |