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

Object Details

Object Name:	JTF_AMV_ITEMS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_AMV_ITEMS_VL
Subobject Name:
Status:	VALID

View Type

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

JTF_AMV_ITEMS_VL is a view on the base and translation tables that contains the translated data based on the current language.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Unique identifier generated by database
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	This column is used for locking purposes
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_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).
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).
ITEM_ID	NUMBER		Yes	Unique Identifier
STATUS_CODE	VARCHAR2	(30)		Indicates the status of the item
EFFECTIVE_START_DATE	DATE			The date the item becomes available.
EXPIRATION_DATE	DATE			The date the item become unavailable.
APPLICATION_ID	NUMBER		Yes	Application Identifier
EXTERNAL_ACCESS_FLAG	VARCHAR2	(1)	Yes	Indicates whether the item can be accessed external to the application
PRIORITY	VARCHAR2	(30)		Item priority
PUBLICATION_DATE	DATE			The date the item is origianlly published.
LANGUAGE_CODE	VARCHAR2	(4)	Yes	The language code used by InterMedia.
ITEM_TYPE	VARCHAR2	(240)		Item Type
URL_STRING	VARCHAR2	(2000)		The URL of the itemcontent if the item_type is URL.
CONTENT_TYPE_ID	NUMBER			Content Type Identifier
OWNER_ID	NUMBER	(15)		Owner Resource Identifier
DEFAULT_APPROVER_ID	NUMBER	(15)		Default Approver Resource Identifier
ITEM_DESTINATION_TYPE	VARCHAR2	(240)		Destination of the item. either on regular place or on the tool bar.
ACCESS_NAME	VARCHAR2	(40)		The field is used by iStore.
DELIVERABLE_TYPE_CODE	VARCHAR2	(40)		The field is used by iStore.
APPLICABLE_TO_CODE	VARCHAR2	(40)		The field is used by iStore.
ITEM_NAME	VARCHAR2	(240)	Yes	Item Name
DESCRIPTION	VARCHAR2	(2000)		Description
TEXT_STRING	VARCHAR2	(2000)		Text Message for an item of type MESSAGE
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield 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 ROW_ID
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ITEM_ID
,      STATUS_CODE
,      EFFECTIVE_START_DATE
,      EXPIRATION_DATE
,      APPLICATION_ID
,      EXTERNAL_ACCESS_FLAG
,      PRIORITY
,      PUBLICATION_DATE
,      LANGUAGE_CODE
,      ITEM_TYPE
,      URL_STRING
,      CONTENT_TYPE_ID
,      OWNER_ID
,      DEFAULT_APPROVER_ID
,      ITEM_DESTINATION_TYPE
,      ACCESS_NAME
,      DELIVERABLE_TYPE_CODE
,      APPLICABLE_TO_CODE
,      ITEM_NAME
,      DESCRIPTION
,      TEXT_STRING
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.JTF_AMV_ITEMS_VL;

Dependencies

[top of page]

APPS.JTF_AMV_ITEMS_VL references the following:

APPS: JTF_AMV_ITEMS_B; JTF_AMV_ITEMS_TL

APPS.JTF_AMV_ITEMS_VL is referenced by following:

APPS: AMV_CATEGORY_PVT - show dependent code; AMV_CHANNEL_PVT - show dependent code; AMV_ITEM_PUB - show dependent code; AMV_MYCHANNEL_PVT - show dependent code; AMV_SEARCH_PVT - show dependent code; AMV_UTILITY_PVT - show dependent code; AMV_WFAPPROVAL_PVT - show dependent code; IBE_DSP_AMV_ITEMS_V; IBE_DSP_ATTACHMENTS_V; IBE_DSP_FEATURED_MEDIA_V; IBE_DSP_HIERARCHY_QUERY_PVT - show dependent code; IBE_DSP_LGL_CTNT_V; IBE_DSP_LGL_TEMPLATES_V; IBE_DSP_OBJ_LGL_CTNT_V; IBE_LOG_TO_PHY_PVT - show dependent code; IBE_LOG_TO_PHY_PVT - show dependent code; IBE_M_IBC_INT_PVT - show dependent code; IBE_PHY_MEDIA_PVT - show dependent code; IBE_PHY_MEDIA_PVT - show dependent code; IBW_OE_PVT - show dependent code; IEM_DIAG_KB_DOC_PVT - show dependent code; IEM_EMAIL_PROC_PVT - show dependent code; IEM_RULES_ENGINE_PUB - show dependent code; JTF_AMV_ITEM_PUB - show dependent code; JTF_DSP_AMV_ITEMS_V; JTF_DSP_ATTACHMENTS_V; JTF_DSP_FEATURED_MEDIA_V; JTF_DSP_LGL_TEMPLATES_V; JTF_DSP_OBJ_LGL_CTNT_V; JTF_FM_AMV_ITEMS_VL; JTF_LOG_TO_PHY_PVT - show dependent code; JTF_LOG_TO_PHY_PVT - show dependent code; JTF_PHY_MEDIA_PVT - show dependent code; JTF_PHY_MEDIA_PVT - show dependent code; OKL_AM_UTIL_PVT - show dependent code; OKL_CS_PROCESS_TMPLTS_UV