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

TABLE: ICX.ICX_CAT_FAV_LIST_LINES_TLP

Object Details
Object Name: ICX_CAT_FAV_LIST_LINES_TLP
Object Type: TABLE
Owner: ICX
Subobject Name:
Status: VALID


Table which stores all the items which are added to favorite lists. It stores the document ids to which the item refers so that the latest information can be retrieved from the document from which this item is sourced.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ICX_CAT_FAV_LIST_LINES_TLP_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFAVORITE_LIST_LINE_ID
ICX_CAT_FAV_LIST_LINES_TLP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFAVORITE_LIST_ID
Columns
Name Datatype Length Mandatory Comments
FAVORITE_LIST_LINE_ID NUMBER
Yes Favorite List Line Id
FAVORITE_LIST_ID NUMBER
Yes Favorite List Id
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER
Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER
Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column
PO_HEADER_ID NUMBER

Po Header Id
PO_LINE_ID NUMBER

Po Line Id
INVENTORY_ITEM_ID NUMBER

Inventory Item Id
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
LINE_TYPE_ID NUMBER

Line Type Id
ITEM_REVISION VARCHAR2 (3)
Item Revision
PO_CATEGORY_ID NUMBER

Po Category Id
UNIT_MEAS_LOOKUP_CODE VARCHAR2 (25)
Unit Meas Lookup Code
UNIT_PRICE NUMBER

Unit Price
SUGGESTED_VENDOR_ID NUMBER

Suggested Vendor Id
SUGGESTED_VENDOR_NAME VARCHAR2 (240)
Suggested Vendor Name
SUGGESTED_VENDOR_SITE_ID NUMBER

Suggested Vendor Site Id
SUGGESTED_VENDOR_SITE VARCHAR2 (100)
Suggested Vendor Site
SUGGESTED_VENDOR_CONTACT_ID NUMBER

Suggested Vendor Contact Id
SUGGESTED_VENDOR_CONTACT VARCHAR2 (80)
Suggested Vendor Contact
SUPPLIER_URL VARCHAR2 (240)
Supplier Url
SUGGESTED_BUYER_ID NUMBER

Suggested Buyer Id
SUGGESTED_BUYER VARCHAR2 (80)
Suggested Buyer
SUPPLIER_ITEM_NUM VARCHAR2 (25)
Supplier Item Num
MANUFACTURER_ID NUMBER

Manufacturer Id
MANUFACTURER_NAME VARCHAR2 (240)
Manufacturer Name
MANUFACTURER_PART_NUMBER VARCHAR2 (30)
Manufacturer Part Number
RFQ_REQUIRED_FLAG VARCHAR2 (1) Yes Rfq Required Flag
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute Category
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flex
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flex
PO_CATEGORY_NAME VARCHAR2 (81)
Po Category Name
SUGGESTED_VENDOR_CONTACT_PHONE VARCHAR2 (25)
Suggested Vendor Contact Phone
NEW_SUPPLIER VARCHAR2 (1)
New Supplier
REQ_TEMPLATE_NAME VARCHAR2 (25)
Express name from requisition template
REQ_TEMPLATE_LINE_NUM NUMBER

Sequence num from requisition template
CURRENCY VARCHAR2 (15)
Currency
RATE_TYPE VARCHAR2 (30)
Rate Type
RATE NUMBER

Rate
RATE_DATE DATE

Rate Date
NONCAT_TEMPLATE_ID NUMBER

Noncat Template Id
SUGGESTED_VENDOR_CONTACT_FAX VARCHAR2 (25)
Suggested Vendor Contact Fax
SUGGESTED_VENDOR_CONTACT_EMAIL VARCHAR2 (2000)
Suggested Vendor Contact Email
NEGOTIATED_BY_PREPARER_FLAG VARCHAR2 (1)
Negotiated By Preparer Flag
THUMBNAIL_IMAGE VARCHAR2 (700)
Thumbnail Image
ORG_ID NUMBER
Yes Org Id
LANGUAGE VARCHAR2 (4) Yes Language
CONTENT_ZONE_ID NUMBER

Content Zone Id
LONG_DESCRIPTION VARCHAR2 (2000)
Long Description
UNSPSC_CODE VARCHAR2 (700)
Unspsc Code
HAZARD_CLASS_ID NUMBER

Hazard Class Id
PICTURE VARCHAR2 (700)
Picture
AMOUNT NUMBER

Amount
SOURCE_TYPE VARCHAR2 (20) Yes Indicates the source of the item. The possible values: 1. BLANKET 2. GLOBAL_BLANKET 3. QUOTATION 4. TEMPLATE 5. INTERNAL_TEMPLATE 6. MASTER_ITEM 7. NONCATALOG 8. EXTERNAL
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 does not reference any database object

ICX.ICX_CAT_FAV_LIST_LINES_TLP is referenced by following:

SchemaAPPS
SynonymICX_CAT_FAV_LIST_LINES_TLP