[Home] [Help] [Dependency Information]

VIEW: APPS.MSC_EXC_DETAIL_ALL_V

Object Details

Object Name:	MSC_EXC_DETAIL_ALL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MSC.MSC_EXC_DETAIL_ALL_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT EXCEPTION_GROUP
,      EXCEPTION_TYPE
,      EXCEPTION_DETAIL_ID
,      PLAN_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      INVENTORY_ITEM_ID
,      ITEM_NAME
,      ORGANIZATION_CODE
,      BUYER_NAME
,      PLANNER_CODE
,      PROJECT_NUMBER
,      TASK_NUMBER
,      CUSTOMER_NAME
,      SUPPLIER_NAME
,      SUPPLIER_SITE_NAME
,      LOAD_RATIO
,      QUANTITY
,      FROM_DATE
,      TO_DATE
,      DUE_DATE
,      OLD_DUE_DATE
,      DMD_SATISFIED_DATE
,      ORDER_TYPE
,      ORDER_NUMBER
,      LINE_NUMBER
,      NUMBER4
,      ALTERNATE_FIELD
,      DEMAND_PROIRITY
,      TO_PROJECT_NUMBER
,      TO_TASK_NUMBER
,      CATEGORY_ID
,      CATEGORY_NAME
,      CATEGORY_SET_ID
,      CATEGORY_SET_NAME
,      DEPARTMENT_CODE
,      RESOURCE_CODE
,      DEPARTMENT_CLASS
,      RESOURCE_GROUP
,      DEPARTMENT_ID
,      RESOURCE_ID
,      ID_KEY
,      COMPARE_KEY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.MSC_EXC_DETAIL_ALL_V;

Dependencies

[top of page]

APPS

MSC_CATEGORY_SETS

MSC_EXC_DETAILS_ALL

MSC_ITEM_CATEGORIES

APPS.MSC_EXC_DETAIL_ALL_V is not referenced by any database object