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]

VIEW: APPS.AMS_CELLS_SEL_ALL_V

Object Details

Object Name:	AMS_CELLS_SEL_ALL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_CELLS_SEL_ALL_V
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.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
ROW_ID	ROWID	(10)	Row_id
CELL_ID	NUMBER		Unique identifier
CELL_NAME	VARCHAR2	(120)	Name of the cell
DESCRIPTION	VARCHAR2	(4000)	Description of the cell
LAST_UPDATE_DATE	DATE		Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Standard WHO Column
CREATION_DATE	DATE		Standard WHO Column
CREATED_BY	NUMBER	(15)	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard WHO Column
CELL_CODE	VARCHAR2	(30)	Unique Cell Code.
OWNER_ID	NUMBER		Owner identifier
MARKET_SEGMENT_FLAG	VARCHAR2	(1)	Indicates wether it is a 'market segment' or a 'target segment'.
ENABLED_FLAG	VARCHAR2	(1)	Enabled flag
ORIGINAL_SIZE	NUMBER	(15)	Original size of the cell
PARENT_CELL_ID	NUMBER		Parent Cell id of the cell.
OBJECT_VERSION_NUMBER	NUMBER	(9)	This column is used for locking purposes .
SEL_TYPE	VARCHAR2	(30)	Type of sel
USER_STATUS_ID	NUMBER		User status identifier
STATUS_CODE	VARCHAR2	(30)	Status code for the cell
STATUS_DATE	DATE
COUNTRY	NUMBER		Country
DISCOVERER_SQL_ID	NUMBER		Discoverer sql identifier
WORKBOOK_OWNER	VARCHAR2	(100)	Owner of the workbook
WORKBOOK_NAME	VARCHAR2	(254)	Name of the workbook
WORKSHEET_NAME	VARCHAR2	(254)	Name of the worksheet
ACTIVITY_DISCOVERER_ID	NUMBER		Activity discoverer identifier
ACT_DISC_VERSION_NUMBER	NUMBER	(9)	This column is used for locking purposes .
LIST_QUERY_ID	NUMBER		Last query identifier
LIST_SQL_STRING	CLOB	(4000)	Sql query
SOURCE_OBJECT_NAME	VARCHAR2	(60)	Source object name
LIST_QUERY_VERSION_NUMBER	NUMBER		This column is used for locking purposes .

Query Text

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


SELECT ROW_ID
,      CELL_ID
,      CELL_NAME
,      DESCRIPTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CELL_CODE
,      OWNER_ID
,      MARKET_SEGMENT_FLAG
,      ENABLED_FLAG
,      ORIGINAL_SIZE
,      PARENT_CELL_ID
,      OBJECT_VERSION_NUMBER
,      SEL_TYPE
,      USER_STATUS_ID
,      STATUS_CODE
,      STATUS_DATE
,      COUNTRY
,      DISCOVERER_SQL_ID
,      WORKBOOK_OWNER
,      WORKBOOK_NAME
,      WORKSHEET_NAME
,      ACTIVITY_DISCOVERER_ID
,      ACT_DISC_VERSION_NUMBER
,      LIST_QUERY_ID
,      LIST_SQL_STRING
,      SOURCE_OBJECT_NAME
,      LIST_QUERY_VERSION_NUMBER
FROM APPS.AMS_CELLS_SEL_ALL_V;

Dependencies

[top of page]

APPS.AMS_CELLS_SEL_ALL_V references the following:

APPS: AMS_ACT_DISCOVERER_ALL; AMS_CELLS_VL; AMS_LIST_QUERIES_ALL

APPS.AMS_CELLS_SEL_ALL_V is referenced by following:

APPS: AMS_CELL_PVT - show dependent code