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_MSITES_VL

Object Details

Object Name:	JTF_MSITES_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_MSITES_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)
MSITE_ID	NUMBER		Yes
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version number
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated 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_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
STORE_ID	NUMBER	(15)
START_DATE_ACTIVE	DATE		Yes
END_DATE_ACTIVE	DATE
DEFAULT_LANGUAGE_CODE	VARCHAR2	(4)
DEFAULT_CURRENCY_CODE	VARCHAR2	(15)
DEFAULT_DATE_FORMAT	VARCHAR2	(30)
DEFAULT_ORG_ID	NUMBER	(15)
ATP_CHECK_FLAG	VARCHAR2	(30)
WALKIN_ALLOWED_FLAG	VARCHAR2	(3)
MSITE_ROOT_SECTION_ID	NUMBER
PROFILE_ID	NUMBER
MASTER_MSITE_FLAG	VARCHAR2	(3)		Master Minisite Flag
ACCESS_NAME	VARCHAR2	(240)		Access Name for the specialty store
RESP_ACCESS_FLAG	VARCHAR2	(3)		Responsibility Access Flag
PARTY_ACCESS_CODE	VARCHAR2	(30)		Party Access Code
URL	VARCHAR2	(2000)		URL for the Specialty Store
THEME_ID	NUMBER	(15)
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
SOURCE_LANG	VARCHAR2	(4)	Yes	Source language
LANGUAGE	VARCHAR2	(4)	Yes
MSITE_NAME	VARCHAR2	(120)		Name of the store
MSITE_DESCRIPTION	VARCHAR2	(4000)		Defines the purpose of this store

Query Text

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


SELECT ROW_ID
,      MSITE_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      STORE_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      DEFAULT_LANGUAGE_CODE
,      DEFAULT_CURRENCY_CODE
,      DEFAULT_DATE_FORMAT
,      DEFAULT_ORG_ID
,      ATP_CHECK_FLAG
,      WALKIN_ALLOWED_FLAG
,      MSITE_ROOT_SECTION_ID
,      PROFILE_ID
,      MASTER_MSITE_FLAG
,      ACCESS_NAME
,      RESP_ACCESS_FLAG
,      PARTY_ACCESS_CODE
,      URL
,      THEME_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SOURCE_LANG
,      LANGUAGE
,      MSITE_NAME
,      MSITE_DESCRIPTION
FROM APPS.JTF_MSITES_VL;

Dependencies

[top of page]

APPS.JTF_MSITES_VL references the following:

APPS: JTF_MSITES_B; JTF_MSITES_TL

APPS.JTF_MSITES_VL is referenced by following:

APPS: JTF_DSP_LGL_PHYS_MAP_V; JTF_MSITE_PRTY_ACCSS_MGR_PVT - show dependent code; JTF_MSITE_RESP_MGR_PVT - show dependent code