[Home] [Help] [Dependency Information]
Object Name: | ICX_ITEM_DETLS_INFO_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ICX.ICX_ITEM_DETLS_INFO_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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) |
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;
APPS.ICX_ITEM_DETLS_INFO_V is not referenced by any database object
|
|
|