[Home] [Help] [Dependency Information]
Object Name: | ICX_CATG_DETLS_INFO_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ICX.ICX_CATG_DETLS_INFO_VL |
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 |
---|---|---|---|---|
CATEGORY_ID | NUMBER | |||
TEMPLATE_BUSINESS | VARCHAR2 | (50) | ||
TEMPLATE_CONSUMER | VARCHAR2 | (50) | ||
DEFAULT_TEMPLATE_BUSINESS | VARCHAR2 | (50) | ||
DEFAULT_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 | (30) | ||
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 | (30) | ||
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 CATEGORY_ID
, TEMPLATE_BUSINESS
, TEMPLATE_CONSUMER
, DEFAULT_TEMPLATE_BUSINESS
, DEFAULT_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_CATG_DETLS_INFO_VL;
|
|
|