Skip to content

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

VIEW: ICX.ICX_CAT_FAV_LIST_LINES_TLP#

Object Details
Object Name: ICX_CAT_FAV_LIST_LINES_TLP#
Object Type: VIEW
Owner: ICX
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
FAVORITE_LIST_LINE_ID NUMBER
Yes
FAVORITE_LIST_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

PO_HEADER_ID NUMBER

PO_LINE_ID NUMBER

INVENTORY_ITEM_ID NUMBER

ITEM_DESCRIPTION VARCHAR2 (240)
LINE_TYPE_ID NUMBER

ITEM_REVISION VARCHAR2 (3)
PO_CATEGORY_ID NUMBER

UNIT_MEAS_LOOKUP_CODE VARCHAR2 (25)
UNIT_PRICE NUMBER

SUGGESTED_VENDOR_ID NUMBER

SUGGESTED_VENDOR_NAME VARCHAR2 (240)
SUGGESTED_VENDOR_SITE_ID NUMBER

SUGGESTED_VENDOR_SITE VARCHAR2 (100)
SUGGESTED_VENDOR_CONTACT_ID NUMBER

SUGGESTED_VENDOR_CONTACT VARCHAR2 (80)
SUPPLIER_URL VARCHAR2 (240)
SUGGESTED_BUYER_ID NUMBER

SUGGESTED_BUYER VARCHAR2 (80)
SUPPLIER_ITEM_NUM VARCHAR2 (25)
MANUFACTURER_ID NUMBER

MANUFACTURER_NAME VARCHAR2 (240)
MANUFACTURER_PART_NUMBER VARCHAR2 (30)
RFQ_REQUIRED_FLAG VARCHAR2 (1) Yes
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
PO_CATEGORY_NAME VARCHAR2 (81)
SUGGESTED_VENDOR_CONTACT_PHONE VARCHAR2 (25)
NEW_SUPPLIER VARCHAR2 (1)
REQ_TEMPLATE_NAME VARCHAR2 (25)
REQ_TEMPLATE_LINE_NUM NUMBER

CURRENCY VARCHAR2 (15)
RATE_TYPE VARCHAR2 (30)
RATE NUMBER

RATE_DATE DATE

NONCAT_TEMPLATE_ID NUMBER

SUGGESTED_VENDOR_CONTACT_FAX VARCHAR2 (25)
SUGGESTED_VENDOR_CONTACT_EMAIL VARCHAR2 (2000)
NEGOTIATED_BY_PREPARER_FLAG VARCHAR2 (1)
THUMBNAIL_IMAGE VARCHAR2 (700)
ORG_ID NUMBER
Yes
LANGUAGE VARCHAR2 (4) Yes
CONTENT_ZONE_ID NUMBER

LONG_DESCRIPTION VARCHAR2 (2000)
UNSPSC_CODE VARCHAR2 (700)
HAZARD_CLASS_ID NUMBER

PICTURE VARCHAR2 (700)
AMOUNT NUMBER

SOURCE_TYPE VARCHAR2 (20) Yes
Query Text

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


SELECT FAVORITE_LIST_LINE_ID
,      FAVORITE_LIST_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PO_HEADER_ID
,      PO_LINE_ID
,      INVENTORY_ITEM_ID
,      ITEM_DESCRIPTION
,      LINE_TYPE_ID
,      ITEM_REVISION
,      PO_CATEGORY_ID
,      UNIT_MEAS_LOOKUP_CODE
,      UNIT_PRICE
,      SUGGESTED_VENDOR_ID
,      SUGGESTED_VENDOR_NAME
,      SUGGESTED_VENDOR_SITE_ID
,      SUGGESTED_VENDOR_SITE
,      SUGGESTED_VENDOR_CONTACT_ID
,      SUGGESTED_VENDOR_CONTACT
,      SUPPLIER_URL
,      SUGGESTED_BUYER_ID
,      SUGGESTED_BUYER
,      SUPPLIER_ITEM_NUM
,      MANUFACTURER_ID
,      MANUFACTURER_NAME
,      MANUFACTURER_PART_NUMBER
,      RFQ_REQUIRED_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PO_CATEGORY_NAME
,      SUGGESTED_VENDOR_CONTACT_PHONE
,      NEW_SUPPLIER
,      REQ_TEMPLATE_NAME
,      REQ_TEMPLATE_LINE_NUM
,      CURRENCY
,      RATE_TYPE
,      RATE
,      RATE_DATE
,      NONCAT_TEMPLATE_ID
,      SUGGESTED_VENDOR_CONTACT_FAX
,      SUGGESTED_VENDOR_CONTACT_EMAIL
,      NEGOTIATED_BY_PREPARER_FLAG
,      THUMBNAIL_IMAGE
,      ORG_ID
,      LANGUAGE
,      CONTENT_ZONE_ID
,      LONG_DESCRIPTION
,      UNSPSC_CODE
,      HAZARD_CLASS_ID
,      PICTURE
,      AMOUNT
,      SOURCE_TYPE
FROM ICX.ICX_CAT_FAV_LIST_LINES_TLP#;

Dependencies

[top of page]

ICX.ICX_CAT_FAV_LIST_LINES_TLP# references the following:

SchemaICX
TableICX_CAT_FAV_LIST_LINES_TLP
ICX.ICX_CAT_FAV_LIST_LINES_TLP# is referenced by following:

SchemaAPPS
SynonymICX_CAT_FAV_LIST_LINES_TLP