View: MSC_X_ITEM_EXCEPTIONS_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.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