DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.ICX_CAT_SHOP_STORES_VL

Object Details
Object Name: ICX_CAT_SHOP_STORES_VL
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


View to store tanslatable information for stores.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
the row ID
STORE_ID NUMBER
Yes the store ID
SEQUENCE NUMBER

the sequence of the store
LOCAL_CONTENT_FIRST_FLAG VARCHAR2 (1)
whether local content will show first in search results
NAME VARCHAR2 (2000)
name of the store
DESCRIPTION VARCHAR2 (2000)
description of the store
LONG_DESCRIPTION VARCHAR2 (4000)
long description of the store
IMAGE VARCHAR2 (2000)
image of the store
CREATED_BY NUMBER
Yes user who created the store
CREATION_DATE DATE
Yes creation date
LAST_UPDATED_BY NUMBER
Yes user who last updated the store
LAST_UPDATE_DATE DATE
Yes last update date
LAST_UPDATE_LOGIN NUMBER

last update login
Query Text

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


SELECT ROW_ID
,      STORE_ID
,      SEQUENCE
,      LOCAL_CONTENT_FIRST_FLAG
,      NAME
,      DESCRIPTION
,      LONG_DESCRIPTION
,      IMAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.ICX_CAT_SHOP_STORES_VL;

Dependencies

[top of page]

APPS.ICX_CAT_SHOP_STORES_VL references the following:

SchemaAPPS
SynonymICX_CAT_SHOP_STORES_B
SynonymICX_CAT_SHOP_STORES_TL
APPS.ICX_CAT_SHOP_STORES_VL is referenced by following:

SchemaAPPS
Package BodyICX_CAT_STORE_ASSIGNMENT_PKG - show dependent code