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.AR_BPA_ITEMS_VL

Object Details

Object Name:	AR_BPA_ITEMS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.AR_BPA_ITEMS_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
ITEM_ID	NUMBER	(15)	Yes
ITEM_CODE	VARCHAR2	(80)
ITEM_SOURCE	VARCHAR2	(30)	Yes
ITEM_TYPE	VARCHAR2	(30)	Yes
DISPLAY_LEVEL	VARCHAR2	(30)	Yes
DATA_SOURCE_ID	NUMBER	(15)
DISPLAY_ENABLED_FLAG	VARCHAR2	(1)
ASSIGNMENT_ENABLED_FLAG	VARCHAR2	(1)
AMOUNT_ITEM_FLAG	VARCHAR2	(1)
URL_ID	NUMBER	(15)
ITEM_IMAGE_FILENAME	VARCHAR2	(240)
ITEM_MESSAGE_NAME	VARCHAR2	(240)
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
DISPLAYED_MULTI_LEVEL_FLAG	VARCHAR2	(1)
SEEDED_APPLICATION_ID	NUMBER	(15)
TAX_ITEM_FLAG	VARCHAR2	(1)
TOTALS_ENABLED_FLAG	VARCHAR2	(1)
LINK_ENABLED_FLAG	VARCHAR2	(1)
DATA_TYPE	VARCHAR2	(30)
URLCFG_ENABLED_FLAG	VARCHAR2	(1)
FLEXFIELD_ITEM_FLAG	VARCHAR2	(1)
COLUMN_NAME	VARCHAR2	(30)
ITEM_NAME	VARCHAR2	(80)	Yes
ITEM_TEXT_VALUE	VARCHAR2	(2000)
DISPLAY_PROMPT	VARCHAR2	(80)
ITEM_DESCRIPTION	VARCHAR2	(240)

Query Text

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


SELECT ROW_ID
,      ITEM_ID
,      ITEM_CODE
,      ITEM_SOURCE
,      ITEM_TYPE
,      DISPLAY_LEVEL
,      DATA_SOURCE_ID
,      DISPLAY_ENABLED_FLAG
,      ASSIGNMENT_ENABLED_FLAG
,      AMOUNT_ITEM_FLAG
,      URL_ID
,      ITEM_IMAGE_FILENAME
,      ITEM_MESSAGE_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DISPLAYED_MULTI_LEVEL_FLAG
,      SEEDED_APPLICATION_ID
,      TAX_ITEM_FLAG
,      TOTALS_ENABLED_FLAG
,      LINK_ENABLED_FLAG
,      DATA_TYPE
,      URLCFG_ENABLED_FLAG
,      FLEXFIELD_ITEM_FLAG
,      COLUMN_NAME
,      ITEM_NAME
,      ITEM_TEXT_VALUE
,      DISPLAY_PROMPT
,      ITEM_DESCRIPTION
FROM APPS.AR_BPA_ITEMS_VL;

Dependencies

[top of page]

APPS.AR_BPA_ITEMS_VL references the following:

APPS: AR_BPA_ITEMS_B; AR_BPA_ITEMS_TL

APPS.AR_BPA_ITEMS_VL is referenced by following:

APPS: AR_BPA_UTILS_PKG - show dependent code