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


VIEW: APPS.ICX_ITEM_DETLS_INFO_V

Object Details
Object Name: ICX_ITEM_DETLS_INFO_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.ICX_ITEM_DETLS_INFO_V
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

[View Source]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER


ITEM_NAME VARCHAR2 (40)

ITEM_DESCRIPTION VARCHAR2 (240)

TEMPLATE_BUSINESS VARCHAR2 (50)

TEMPLATE_CONSUMER VARCHAR2 (50)

MARKETING_TEXT_FILE VARCHAR2 (30)

MARKETING_TEXT VARCHAR2 (2000)

SPECIAL_FLAG_BUSINESS VARCHAR2 (1)

SPECIAL_IMAGE_BUSINESS VARCHAR2 (30)

SPECIAL_TEXT_BUSINESS VARCHAR2 (2000)

SPECIAL_THUMBNAIL_BUSINESS VARCHAR2 (30)

SPECIAL_START_DATE_BUSINESS DATE


SPECIAL_END_DATE_BUSINESS DATE


SPECIAL_FLAG_CONSUMER VARCHAR2 (1)

SPECIAL_IMAGE_CONSUMER VARCHAR2 (30)

SPECIAL_TEXT_CONSUMER VARCHAR2 (2000)

SPECIAL_THUMBNAIL_CONSUMER VARCHAR2 (30)

SPECIAL_START_DATE_CONSUMER DATE


SPECIAL_END_DATE_CONSUMER DATE


IMAGE_FILE_1 VARCHAR2 (30)

IMAGE_FILE_2 VARCHAR2 (30)

IMAGE_FILE_3 VARCHAR2 (30)

IMAGE_FILE_4 VARCHAR2 (30)

IMAGE_FILE_5 VARCHAR2 (30)

IMAGE_FILE_6 VARCHAR2 (30)

IMAGE_FILE_7 VARCHAR2 (30)

IMAGE_FILE_8 VARCHAR2 (30)

IMAGE_FILE_9 VARCHAR2 (30)

IMAGE_FILE_10 VARCHAR2 (30)

IMAGE_FILE_11 VARCHAR2 (30)

IMAGE_FILE_12 VARCHAR2 (30)

IMAGE_FILE_13 VARCHAR2 (30)

IMAGE_FILE_14 VARCHAR2 (30)

IMAGE_FILE_15 VARCHAR2 (30)

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ITEM_NAME
,      ITEM_DESCRIPTION
,      TEMPLATE_BUSINESS
,      TEMPLATE_CONSUMER
,      MARKETING_TEXT_FILE
,      MARKETING_TEXT
,      SPECIAL_FLAG_BUSINESS
,      SPECIAL_IMAGE_BUSINESS
,      SPECIAL_TEXT_BUSINESS
,      SPECIAL_THUMBNAIL_BUSINESS
,      SPECIAL_START_DATE_BUSINESS
,      SPECIAL_END_DATE_BUSINESS
,      SPECIAL_FLAG_CONSUMER
,      SPECIAL_IMAGE_CONSUMER
,      SPECIAL_TEXT_CONSUMER
,      SPECIAL_THUMBNAIL_CONSUMER
,      SPECIAL_START_DATE_CONSUMER
,      SPECIAL_END_DATE_CONSUMER
,      IMAGE_FILE_1
,      IMAGE_FILE_2
,      IMAGE_FILE_3
,      IMAGE_FILE_4
,      IMAGE_FILE_5
,      IMAGE_FILE_6
,      IMAGE_FILE_7
,      IMAGE_FILE_8
,      IMAGE_FILE_9
,      IMAGE_FILE_10
,      IMAGE_FILE_11
,      IMAGE_FILE_12
,      IMAGE_FILE_13
,      IMAGE_FILE_14
,      IMAGE_FILE_15
FROM APPS.ICX_ITEM_DETLS_INFO_V;

Dependencies

[top of page]

APPS.ICX_ITEM_DETLS_INFO_V references the following:

SchemaAPPS
SynonymFND_PROFILE_OPTIONS
SynonymFND_PROFILE_OPTION_VALUES
ViewICX_ITEM_DETLS_INFO_VL
SynonymMTL_CUSTOMER_ITEMS
SynonymMTL_CUSTOMER_ITEM_XREFS
SynonymMTL_ITEM_CATEGORIES
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymMTL_UNITS_OF_MEASURE
PL/SQL PackageQP_PRICE_LIST_PVT - show dependent code
PL/SQL PackageQP_UTIL - show dependent code
SynonymSO_PRICE_LISTS
SynonymSO_PRICE_LIST_LINES

APPS.ICX_ITEM_DETLS_INFO_V is not referenced by any database object