DBA Data[Home] [Help] [Dependency Information]

TABLE: ONT.OE_UPGRADE_WF_ACT_MAP

Object Details
Object Name: OE_UPGRADE_WF_ACT_MAP
Object Type: TABLE
Owner: ONT
FND Design Data: TableONT.OE_UPGRADE_WF_ACT_MAP
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ACTION_NAME VARCHAR2 (35)
Cycle Action Name
ACTION_LEVEL_TYPE VARCHAR2 (1)
To denote if it is a Header or Line level action.
ACTIVITY_NAME VARCHAR2 (30)
Equivalent Activity name for a given action name.
ACTIVITY_ITEM_TYPE VARCHAR2 (8)
To denote if header or line level activity.
ACTIVITY_SEQ NUMBER

Denotes the sequence of the activity in the new flow.
STATUS_FLAG VARCHAR2 (1)
To denote if this action is obsoleted in the new version or not.
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
ACTION_RESULT VARCHAR2 (30)
Description of Action Result in Old version
ACTIVITY_RESULT VARCHAR2 (30)
Activity result in new version for upgrade
ACTION_ID NUMBER

Action Id for the mapped action.
ACTION_RESULT_ID NUMBER

Action Result id for the Action mapped.
LINE_TYPE VARCHAR2 (10)
Denotes Regular/Return/ATO lines.
Query Text

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


SELECT ACTION_NAME
,      ACTION_LEVEL_TYPE
,      ACTIVITY_NAME
,      ACTIVITY_ITEM_TYPE
,      ACTIVITY_SEQ
,      STATUS_FLAG
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      ACTION_RESULT
,      ACTIVITY_RESULT
,      ACTION_ID
,      ACTION_RESULT_ID
,      LINE_TYPE
FROM ONT.OE_UPGRADE_WF_ACT_MAP;

Dependencies

[top of page]

ONT.OE_UPGRADE_WF_ACT_MAP does not reference any database object

ONT.OE_UPGRADE_WF_ACT_MAP is referenced by following:

SchemaONT
ViewOE_UPGRADE_WF_ACT_MAP#