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

TABLE: ICX.POR_FAVORITE_LIST_LINES

Object Details
Object Name: POR_FAVORITE_LIST_LINES
Object Type: TABLE
Owner: ICX
FND Design Data: TableICX.POR_FAVORITE_LIST_LINES
Subobject Name:
Status: VALID


This table is obsolete since R12.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
POR_FAVORITE_LIST_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFAVORITE_LIST_LINE_ID
POR_FAVORITE_LIST_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRT_ITEM_ID
POR_FAVORITE_LIST_LINES_U2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFAVORITE_LIST_ID
Columns
Name Datatype Length Mandatory Comments
FAVORITE_LIST_LINE_ID NUMBER
Yes Primary Key generated from a sequence
FAVORITE_LIST_ID NUMBER
Yes Favorite List unique identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
SOURCE_DOC_HEADER_ID NUMBER

The header_id for the document to which this item is referring. (documents include blankets and quotations)
SOURCE_DOC_LINE_ID NUMBER

Line Id of the blanket or quotation to which this item refers.
ITEM_ID NUMBER

The id for the item as available in the mtl_system_items_table
ITEM_DESCRIPTION VARCHAR2 (240)
Description of the Item
LINE_TYPE_ID NUMBER

Id which indicates the type (whether goods,amount or rate-based line)
ITEM_REVISION VARCHAR2 (3)
Item Revision
CATEGORY_ID NUMBER

Category Id
UNIT_MEAS_LOOKUP_CODE VARCHAR2 (25)
Unit of Measure
UNIT_PRICE NUMBER

Price per unit
SUGGESTED_VENDOR_ID NUMBER

Id identifying the vendor referred to in the favorites list. Obtained from po_vendors table.
SUGGESTED_VENDOR_NAME VARCHAR2 (240)
Name of the Supplier
SUGGESTED_VENDOR_SITE_ID NUMBER

Supplier Site Id
SUGGESTED_VENDOR_SITE VARCHAR2 (100)
Supplier Site
SUGGESTED_VENDOR_CONTACT_ID NUMBER

Supplier Contact Id
SUGGESTED_VENDOR_CONTACT VARCHAR2 (80)
Supplier Contact Name
SUPPLIER_URL VARCHAR2 (240)
URL giving information about supplier
SUGGESTED_BUYER_ID NUMBER

Buyer Id
SUGGESTED_BUYER VARCHAR2 (80)
Buyer Name
SUPPLIER_ITEM_NUM VARCHAR2 (25)
Item Number used by the supplier.
MANUFACTURER_ID NUMBER

Currently Not used
MANUFACTURER_NAME VARCHAR2 (240)
Not begin used
MANUFACTURER_PART_NUMBER VARCHAR2 (30)
Not being used
RFQ_REQUIRED_FLAG VARCHAR2 (1) Yes Not Used
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
CATEGORY VARCHAR2 (81)
Item Category
RT_ITEM_ID NUMBER

Refers to the item id used in the catalog
RT_CATEGORY_ID NUMBER

Category Id which is used in the catalog.
SUGGESTED_VENDOR_CONTACT_PHONE VARCHAR2 (25)
Phone number of the Supplier Contact
NEW_SUPPLIER VARCHAR2 (1)
Flag indicating if it is a new supplier or not.
ASL_ID NUMBER

Id for the approved supplier lists from which this item is sourced.
TEMPLATE_NAME VARCHAR2 (25)
Template name (REQ_EXPRESS_HEADERS) from which the item is sourced
TEMPLATE_LINE_NUM NUMBER

Template Line Num as obtained from REQ_EXPRESS_LINES table.
CURRENCY VARCHAR2 (15)
Currency
RATE_TYPE VARCHAR2 (30)
Rate Type
RATE NUMBER

Rate
PRICE_LIST_ID NUMBER

Foreign key reference to PRICE_LIST_ID column in Table ICX_CAT_ITEM_PRICES
RATE_DATE DATE

Rate Date
NONCAT_TEMPLATE_ID NUMBER

Template id of non-catalog item
SUGGESTED_VENDOR_CONTACT_FAX VARCHAR2 (25)
Supplier's fax
SUGGESTED_VENDOR_CONTACT_EMAIL VARCHAR2 (2000)
Supplier's email
NEGOTIATED_BY_PREPARER_FLAG VARCHAR2 (1)
Negotiated by preparer flag
THUMBNAIL_IMAGE VARCHAR2 (700)
Thumbnail image
ITEM_TYPE VARCHAR2 (20)
Item Type
DUPLICATE_IN_R12 VARCHAR2 (1)
Indicates if the favorite list line is duplicate in R12
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
,      SOURCE_DOC_HEADER_ID
,      SOURCE_DOC_LINE_ID
,      ITEM_ID
,      ITEM_DESCRIPTION
,      LINE_TYPE_ID
,      ITEM_REVISION
,      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
,      CATEGORY
,      RT_ITEM_ID
,      RT_CATEGORY_ID
,      SUGGESTED_VENDOR_CONTACT_PHONE
,      NEW_SUPPLIER
,      ASL_ID
,      TEMPLATE_NAME
,      TEMPLATE_LINE_NUM
,      CURRENCY
,      RATE_TYPE
,      RATE
,      PRICE_LIST_ID
,      RATE_DATE
,      NONCAT_TEMPLATE_ID
,      SUGGESTED_VENDOR_CONTACT_FAX
,      SUGGESTED_VENDOR_CONTACT_EMAIL
,      NEGOTIATED_BY_PREPARER_FLAG
,      THUMBNAIL_IMAGE
,      ITEM_TYPE
,      DUPLICATE_IN_R12
FROM ICX.POR_FAVORITE_LIST_LINES;

Dependencies

[top of page]

ICX.POR_FAVORITE_LIST_LINES does not reference any database object

ICX.POR_FAVORITE_LIST_LINES is referenced by following:

SchemaICX
ViewPOR_FAVORITE_LIST_LINES#