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: AZ.AZ_SELECTION_SET_APIS

Object Details

Object Name:	AZ_SELECTION_SET_APIS
Object Type:	TABLE
Owner:	AZ
FND Design Data:	AZ.AZ_SELECTION_SET_APIS
Subobject Name:
Status:	VALID

This table stores what APIs are included in each selection set for iSetup Migrator.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AZ_SELECTION_SET_APIS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	JOB_NAME ENTITY_OCCURANCE_CODE SUBMITTED_BY

Columns

Name	Datatype	Length	Mandatory	Comments
JOB_NAME	VARCHAR2	(45)	Yes	Job Name
ENTITY_OCCURANCE_CODE	VARCHAR2	(45)	Yes	Entity Occurance Code
SUBMITTED_BY	NUMBER	(15)	Yes	Submitted By
API_CODE	VARCHAR2	(45)	Yes	API Code
EXECUTION_STATUS	VARCHAR2	(1)	Yes	Execution Status
CREATED_BY	NUMBER	(15)	Yes	Standard who columns
CREATION_DATE	DATE		Yes	Standard who columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who columns
LAST_UPDATE_DATE	DATE		Yes	Standard who columns
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who columns
FILTERING_PARAMETER	LONG	(0)		Filtering Parameter

Query Text

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


SELECT JOB_NAME
,      ENTITY_OCCURANCE_CODE
,      SUBMITTED_BY
,      API_CODE
,      EXECUTION_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      FILTERING_PARAMETER
FROM AZ.AZ_SELECTION_SET_APIS;

Dependencies

[top of page]

AZ.AZ_SELECTION_SET_APIS does not reference any database object

AZ.AZ_SELECTION_SET_APIS is referenced by following:

APPS: AZ_SELECTION_SET_APIS