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: AMS.AMS_DIALOGS_ALL_B

Object Details

Object Name:	AMS_DIALOGS_ALL_B
Object Type:	TABLE
Owner:	AMS
FND Design Data:	AMS.AMS_DIALOGS_ALL_B
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

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_DIALOGS_ALL_B_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	DIALOG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DIALOG_ID	NUMBER		Yes	Unique Dialog identifier
CREATION_DATE	DATE		Yes	WHO column
CREATED_BY	NUMBER		Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
OBJECT_VERSION_NUMBER	NUMBER		Yes	This column is used for locking purpose
OWNER_ID	NUMBER		Yes	Dialog owner identifier
SOURCE_CODE	VARCHAR2	(30)	Yes	Dialog source code
APPLICATION_ID	NUMBER		Yes	Application identifier
GLOBAL_FLAG	VARCHAR2	(1)		Flag that indicates the dialog is global or not.
ORG_ID	NUMBER			Organization identifier
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
CUSTOM_SETUP_ID	NUMBER		Yes	Custom setup id used for creating the dialog
DIALOG_TYPE	VARCHAR2	(30)		Dialog type
PROGRAM_ID	NUMBER			Unique identifier of the parent program to which the dialog is rolling up
BUSINESS_UNIT_ID	NUMBER			Identifier of the business unit this dialog belongs to
PURPOSE	VARCHAR2	(30)		Purpose of the dialog
PRIORITY	VARCHAR2	(30)		Priority of the dialog
CONFIDENTIAL_FLAG	VARCHAR2	(1)		Flag that indicates whether the dialog is confidential
TEMPLATE_FLAG	VARCHAR2	(1)		Flag to indicate whether the dialog is template or not
ACTIVE_FLAG	VARCHAR2	(1)		Flag to indicate whether a dialog is active
USER_STATUS_ID	NUMBER		Yes	User status identifier
SYSTEM_STATUS_CODE	VARCHAR2	(30)	Yes	system status code
STATUS_UPDATE_DATE	DATE		Yes	Date on which the status was last updated
DIALOG_CALENDAR	VARCHAR2	(15)		Calendar used for dialog planning. Refers to General Ledger calendar
START_PERIOD_NAME	VARCHAR2	(15)		Start period of the dialog
END_PERIOD_NAME	VARCHAR2	(15)		Dialog's end period
START_DATE	DATE			Dialog start date
END_DATE	DATE			Dialog end date
LANGUAGE_CODE	VARCHAR2	(30)		Language code in which the dialog is created
TRANSACTION_CURRENCY_CODE	VARCHAR2	(15)		Currency code
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	(15)		Functional currency code
BUDGET_AMOUNT_TC	NUMBER			Transactional curency
COUNTRY_ID	NUMBER			Country in which the Dialog was created
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
BUDGET_AMOUNT_FC	NUMBER			Functional currency
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flex field segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment

Query Text

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


SELECT DIALOG_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      OWNER_ID
,      SOURCE_CODE
,      APPLICATION_ID
,      GLOBAL_FLAG
,      ORG_ID
,      SECURITY_GROUP_ID
,      CUSTOM_SETUP_ID
,      DIALOG_TYPE
,      PROGRAM_ID
,      BUSINESS_UNIT_ID
,      PURPOSE
,      PRIORITY
,      CONFIDENTIAL_FLAG
,      TEMPLATE_FLAG
,      ACTIVE_FLAG
,      USER_STATUS_ID
,      SYSTEM_STATUS_CODE
,      STATUS_UPDATE_DATE
,      DIALOG_CALENDAR
,      START_PERIOD_NAME
,      END_PERIOD_NAME
,      START_DATE
,      END_DATE
,      LANGUAGE_CODE
,      TRANSACTION_CURRENCY_CODE
,      FUNCTIONAL_CURRENCY_CODE
,      BUDGET_AMOUNT_TC
,      COUNTRY_ID
,      ATTRIBUTE_CATEGORY
,      BUDGET_AMOUNT_FC
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM AMS.AMS_DIALOGS_ALL_B;

Dependencies

[top of page]

AMS.AMS_DIALOGS_ALL_B does not reference any database object

AMS.AMS_DIALOGS_ALL_B is referenced by following:

AMS: AMS_DIALOGS_ALL_B#