eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: ECX.ECX_PROC_MAPPINGS

Object Details

Object Name:	ECX_PROC_MAPPINGS
Object Type:	TABLE
Owner:	ECX
FND Design Data:	ECX.ECX_PROC_MAPPINGS
Subobject Name:
Status:	VALID

This table contains the procedure mappings

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ECX_PROC_MAPPINGS_U1	NORMAL	UNIQUE	APPS_TS_SEED	MAP_ID PROCMAP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROCMAP_ID	NUMBER		Yes	Procedure map Identifier
TRANSTAGE_ID	NUMBER		Yes	Transaction stage Identifier
PARAMETER_NAME	VARCHAR2	(250)		Parameter Name
ACTION_TYPE	NUMBER			IN or OUT parameter
VARIABLE_LEVEL	NUMBER			Direction variable Level
VARIABLE_NAME	VARCHAR2	(255)		Variable Name
DATA_TYPE	NUMBER			Datatype as specified in Oracle server
VARIABLE_POS	NUMBER			Variable Position
MAP_ID	NUMBER		Yes	Map Identifier
VARIABLE_DIRECTION	VARCHAR2	(1)		Variable direction (Direction or Global or Literal
VARIABLE_CONSTANT	VARCHAR2	(2000)		Stores Literal Value
VARIABLE_VALUE	VARCHAR2	(200)		Variable Value

Query Text

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


SELECT PROCMAP_ID
,      TRANSTAGE_ID
,      PARAMETER_NAME
,      ACTION_TYPE
,      VARIABLE_LEVEL
,      VARIABLE_NAME
,      DATA_TYPE
,      VARIABLE_POS
,      MAP_ID
,      VARIABLE_DIRECTION
,      VARIABLE_CONSTANT
,      VARIABLE_VALUE
FROM ECX.ECX_PROC_MAPPINGS;

Dependencies

[top of page]

ECX.ECX_PROC_MAPPINGS does not reference any database object

ECX.ECX_PROC_MAPPINGS is referenced by following:

APPS: ECX_PROC_MAPPINGS