[Home] [Help] [Dependency Information]
Object Name: | MSC_ACTION_SUMMARY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSC.MSC_ACTION_SUMMARY_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
EXCEPTION_TYPE | NUMBER | |||
EXCEPTION_GROUP | NUMBER | |||
EXCEPTION_GROUP_TEXT | VARCHAR2 | (0) | ||
EXCEPTION_LEVEL | NUMBER | |||
COMPILE_DESIGNATOR | VARCHAR2 | (10) | Yes | |
PLAN_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
SR_INSTANCE_ID | NUMBER | |||
PROJECT_ID | NUMBER | |||
TASK_ID | NUMBER | |||
VERSION | VARCHAR2 | (4000) | ||
EXCEPTION_COUNT | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
PLANNER_CODE | VARCHAR2 | (80) | ||
PLANNER_CODE_HIDDEN | VARCHAR2 | (80) | ||
CATEGORY_ID | NUMBER | |||
CATEGORY_NAME | VARCHAR2 | (250) | ||
PLANNING_GROUP | VARCHAR2 | (80) | ||
PLANNING_GROUP_HIDDEN | VARCHAR2 | (80) | ||
QUERY_ID | NUMBER | Yes | ||
EXCEPTION_TYPE_TEXT | VARCHAR2 | (4000) | ||
ITEM_SEGMENTS | VARCHAR2 | (4000) | ||
PRODUCT_FAMILY_ID | NUMBER | |||
PRODUCT_FAMILY_NAME | VARCHAR2 | (4000) | ||
ORGANIZATION_CODE | VARCHAR2 | (4000) | ||
PROJECT_NUMBER | VARCHAR2 | (4000) | ||
TASK_NUMBER | VARCHAR2 | (4000) | ||
BUYER_NAME | VARCHAR2 | (250) | ||
BUYER_NAME_HIDDEN | VARCHAR2 | (250) | ||
DEPARTMENT_CLASS | VARCHAR2 | (80) | ||
RESOURCE_GROUP | VARCHAR2 | (80) | ||
DEPARTMENT_ID | NUMBER | |||
RESOURCE_ID | NUMBER | |||
DEPARTMENT_LINE_CODE | VARCHAR2 | (4000) | ||
RESOURCE_CODE | VARCHAR2 | (4000) | ||
RESOURCE_TYPE_CODE | VARCHAR2 | (80) | ||
SUPPLIER_ID | NUMBER | |||
SUPPLIER_NAME | VARCHAR2 | (4000) | ||
LAST_UPDATE_LOGIN | NUMBER | |||
DISPLAY | NUMBER | |||
ROW_ID | ROWID | (10) | ||
HIDDEN_SORT_GROUP | NUMBER | |||
HIDDEN_SORT_EXCEPT | NUMBER | |||
NEW_EXCEPTION_COUNT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, EXCEPTION_TYPE
, EXCEPTION_GROUP
, EXCEPTION_GROUP_TEXT
, EXCEPTION_LEVEL
, COMPILE_DESIGNATOR
, PLAN_ID
, ORGANIZATION_ID
, SR_INSTANCE_ID
, PROJECT_ID
, TASK_ID
, VERSION
, EXCEPTION_COUNT
, INVENTORY_ITEM_ID
, PLANNER_CODE
, PLANNER_CODE_HIDDEN
, CATEGORY_ID
, CATEGORY_NAME
, PLANNING_GROUP
, PLANNING_GROUP_HIDDEN
, QUERY_ID
, EXCEPTION_TYPE_TEXT
, ITEM_SEGMENTS
, PRODUCT_FAMILY_ID
, PRODUCT_FAMILY_NAME
, ORGANIZATION_CODE
, PROJECT_NUMBER
, TASK_NUMBER
, BUYER_NAME
, BUYER_NAME_HIDDEN
, DEPARTMENT_CLASS
, RESOURCE_GROUP
, DEPARTMENT_ID
, RESOURCE_ID
, DEPARTMENT_LINE_CODE
, RESOURCE_CODE
, RESOURCE_TYPE_CODE
, SUPPLIER_ID
, SUPPLIER_NAME
, LAST_UPDATE_LOGIN
, DISPLAY
, ROW_ID
, HIDDEN_SORT_GROUP
, HIDDEN_SORT_EXCEPT
, NEW_EXCEPTION_COUNT
FROM APPS.MSC_ACTION_SUMMARY_V;
APPS.MSC_ACTION_SUMMARY_V is not referenced by any database object
|
|
|