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


VIEW: APPS.ICX_POR_SEARCH_ITEM_MASTER_V

Object Details
Object Name: ICX_POR_SEARCH_ITEM_MASTER_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.ICX_POR_SEARCH_ITEM_MASTER_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
POR_ASL_ID NUMBER

POR_TEMPLATE_NAME VARCHAR2 (0)
POR_TEMPLATE_LINE_NUM NUMBER

POR_RESERVE_PO_NUMBER VARCHAR2 (0)
POR_TEMPLATE_INACTIVE_DATE DATE

POR_RFQ_REQUIRED_FLAG VARCHAR2 (0)
POR_LINE_TYPE_ID NUMBER

POR_LINE_TYPE VARCHAR2 (0)
POR_ORDER_TYPE_CODE VARCHAR2 (0)
POR_ORDER_TYPE VARCHAR2 (0)
POR_ITEM_ID NUMBER
Yes
POR_ITEM_DESCRIPTION VARCHAR2 (240)
POR_ITEM_NUM VARCHAR2 (40)
POR_ITEM_REVISION VARCHAR2 (0)
POR_ITEM_URL VARCHAR2 (240)
POR_ITEM_LT NUMBER

POR_ITEM_PURCHASABLE_FLAG VARCHAR2 (1) Yes
POR_ITEM_INVENTORY_FLAG VARCHAR2 (1) Yes
POR_USE_APPROVED_SUPPLIER VARCHAR2 (1) Yes
POR_CATEGORY_ID NUMBER
Yes
POR_CATEGORY VARCHAR2 (163)
POR_CATEGORY_DESC VARCHAR2 (240)
POR_SUPPLIER_ID NUMBER

POR_SUPPL_NAME VARCHAR2 (0)
POR_SUPPLIER_SITE_ID NUMBER

POR_SUPPL_SITE VARCHAR2 (0)
POR_SUPPLIER_CONTACT_ID NUMBER

POR_SUPPL_CONTACT VARCHAR2 (0)
POR_SUPPL_CONTACT_PHONE VARCHAR2 (0)
POR_SUPPL_URL VARCHAR2 (0)
POR_SUPPL_ITEM_NUM VARCHAR2 (0)
POR_SUPPL_ITEM_URL VARCHAR2 (0)
POR_SUPPL_HOLD_FLAG VARCHAR2 (0)
POR_MANUFACTURER_NAME VARCHAR2 (0)
POR_MANUFACTURER_PART_NUM VARCHAR2 (0)
POR_UNIT_OF_MEASURE VARCHAR2 (25)
POR_CURRENCY_CODE VARCHAR2 (15) Yes
POR_CURRENCY_LINE_PRICE NUMBER

POR_FOREIGN_CURRENCY_CODE VARCHAR2 (0)
POR_RATE_TYPE VARCHAR2 (0)
POR_FOREIGN_CURRENCY_RATE_TYPE VARCHAR2 (0)
POR_FOREIGN_CURRENCY_RATE_DATE DATE

POR_FOREIGN_CURRENCY_RATE NUMBER

POR_UNIT_PRICE NUMBER

POR_TYPE_LOOKUP_CODE VARCHAR2 (0)
POR_SOURCE_DOC_TYPE_CODE VARCHAR2 (0)
POR_PO_HEADER_ID NUMBER

POR_SOURCE_DOC_NUM VARCHAR2 (0)
POR_PO_LINE_ID NUMBER

POR_SOURCE_DOC_LINE_NUM NUMBER

POR_SOURCE_DOC_EFFECTIVE_FROM DATE

POR_SOURCE_DOC_EFFECTIVE_TO DATE

POR_SOURCE_DOC_AMOUNT_AGREED NUMBER

POR_SOURCE_DOC_AMOUNT_LIMIT NUMBER

POR_SOURCE_DOC_MIN_RELEASE_AMT NUMBER

POR_SOURCE_DOC_QUANTITY_AGREED NUMBER

POR_SOURCE_DOC_MIN_ORDER_QTY NUMBER

POR_SOURCE_DOC_MAX_ORDER_QTY NUMBER

POR_TERMS_ID NUMBER

POR_PAYMENT_TERMS NUMBER

POR_SHIP_VIA_LOOKUP_CODE VARCHAR2 (0)
POR_SHIP_VIA VARCHAR2 (0)
POR_FREIGHT_TERMS_LOOKUP_CODE VARCHAR2 (0)
POR_FREIGHT_TERMS VARCHAR2 (0)
POR_FOB_LOOKUP_CODE VARCHAR2 (0)
POR_FOB VARCHAR2 (0)
POR_AGENT_ID NUMBER

POR_BUYER_NAME VARCHAR2 (0)
POR_CATTRIBUTE1 VARCHAR2 (0)
POR_CATTRIBUTE2 VARCHAR2 (0)
POR_CATTRIBUTE3 VARCHAR2 (0)
POR_CATTRIBUTE4 VARCHAR2 (0)
POR_CATTRIBUTE5 VARCHAR2 (0)
POR_CATTRIBUTE6 VARCHAR2 (0)
POR_CATTRIBUTE7 VARCHAR2 (0)
POR_CATTRIBUTE8 VARCHAR2 (0)
POR_CATTRIBUTE9 VARCHAR2 (0)
POR_CATTRIBUTE10 VARCHAR2 (0)
POR_CATTRIBUTE11 VARCHAR2 (0)
POR_CATTRIBUTE12 VARCHAR2 (0)
POR_CATTRIBUTE13 VARCHAR2 (0)
POR_CATTRIBUTE14 VARCHAR2 (0)
POR_CATTRIBUTE15 VARCHAR2 (0)
POR_TATTRIBUTE1 VARCHAR2 (0)
POR_TATTRIBUTE2 VARCHAR2 (0)
POR_TATTRIBUTE3 VARCHAR2 (0)
POR_TATTRIBUTE4 VARCHAR2 (0)
POR_TATTRIBUTE5 VARCHAR2 (0)
POR_TATTRIBUTE6 VARCHAR2 (0)
POR_TATTRIBUTE7 VARCHAR2 (0)
POR_TATTRIBUTE8 VARCHAR2 (0)
POR_TATTRIBUTE9 VARCHAR2 (0)
POR_TATTRIBUTE10 VARCHAR2 (0)
POR_TATTRIBUTE11 VARCHAR2 (0)
POR_TATTRIBUTE12 VARCHAR2 (0)
POR_TATTRIBUTE13 VARCHAR2 (0)
POR_TATTRIBUTE14 VARCHAR2 (0)
POR_TATTRIBUTE15 VARCHAR2 (0)
POR_AATTRIBUTE1 VARCHAR2 (0)
POR_AATTRIBUTE2 VARCHAR2 (0)
POR_AATTRIBUTE3 VARCHAR2 (0)
POR_AATTRIBUTE4 VARCHAR2 (0)
POR_AATTRIBUTE5 VARCHAR2 (0)
POR_AATTRIBUTE6 VARCHAR2 (0)
POR_AATTRIBUTE7 VARCHAR2 (0)
POR_AATTRIBUTE8 VARCHAR2 (0)
POR_AATTRIBUTE9 VARCHAR2 (0)
POR_AATTRIBUTE10 VARCHAR2 (0)
POR_AATTRIBUTE11 VARCHAR2 (0)
POR_AATTRIBUTE12 VARCHAR2 (0)
POR_AATTRIBUTE13 VARCHAR2 (0)
POR_AATTRIBUTE14 VARCHAR2 (0)
POR_AATTRIBUTE15 VARCHAR2 (0)
POR_IATTRIBUTE1 VARCHAR2 (240)
POR_IATTRIBUTE2 VARCHAR2 (240)
POR_IATTRIBUTE3 VARCHAR2 (240)
POR_IATTRIBUTE4 VARCHAR2 (240)
POR_IATTRIBUTE5 VARCHAR2 (240)
POR_IATTRIBUTE6 VARCHAR2 (240)
POR_IATTRIBUTE7 VARCHAR2 (240)
POR_IATTRIBUTE8 VARCHAR2 (240)
POR_IATTRIBUTE9 VARCHAR2 (240)
POR_IATTRIBUTE10 VARCHAR2 (240)
POR_IATTRIBUTE11 VARCHAR2 (240)
POR_IATTRIBUTE12 VARCHAR2 (240)
POR_IATTRIBUTE13 VARCHAR2 (240)
POR_IATTRIBUTE14 VARCHAR2 (240)
POR_IATTRIBUTE15 VARCHAR2 (240)
Query Text

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


SELECT POR_ASL_ID
,      POR_TEMPLATE_NAME
,      POR_TEMPLATE_LINE_NUM
,      POR_RESERVE_PO_NUMBER
,      POR_TEMPLATE_INACTIVE_DATE
,      POR_RFQ_REQUIRED_FLAG
,      POR_LINE_TYPE_ID
,      POR_LINE_TYPE
,      POR_ORDER_TYPE_CODE
,      POR_ORDER_TYPE
,      POR_ITEM_ID
,      POR_ITEM_DESCRIPTION
,      POR_ITEM_NUM
,      POR_ITEM_REVISION
,      POR_ITEM_URL
,      POR_ITEM_LT
,      POR_ITEM_PURCHASABLE_FLAG
,      POR_ITEM_INVENTORY_FLAG
,      POR_USE_APPROVED_SUPPLIER
,      POR_CATEGORY_ID
,      POR_CATEGORY
,      POR_CATEGORY_DESC
,      POR_SUPPLIER_ID
,      POR_SUPPL_NAME
,      POR_SUPPLIER_SITE_ID
,      POR_SUPPL_SITE
,      POR_SUPPLIER_CONTACT_ID
,      POR_SUPPL_CONTACT
,      POR_SUPPL_CONTACT_PHONE
,      POR_SUPPL_URL
,      POR_SUPPL_ITEM_NUM
,      POR_SUPPL_ITEM_URL
,      POR_SUPPL_HOLD_FLAG
,      POR_MANUFACTURER_NAME
,      POR_MANUFACTURER_PART_NUM
,      POR_UNIT_OF_MEASURE
,      POR_CURRENCY_CODE
,      POR_CURRENCY_LINE_PRICE
,      POR_FOREIGN_CURRENCY_CODE
,      POR_RATE_TYPE
,      POR_FOREIGN_CURRENCY_RATE_TYPE
,      POR_FOREIGN_CURRENCY_RATE_DATE
,      POR_FOREIGN_CURRENCY_RATE
,      POR_UNIT_PRICE
,      POR_TYPE_LOOKUP_CODE
,      POR_SOURCE_DOC_TYPE_CODE
,      POR_PO_HEADER_ID
,      POR_SOURCE_DOC_NUM
,      POR_PO_LINE_ID
,      POR_SOURCE_DOC_LINE_NUM
,      POR_SOURCE_DOC_EFFECTIVE_FROM
,      POR_SOURCE_DOC_EFFECTIVE_TO
,      POR_SOURCE_DOC_AMOUNT_AGREED
,      POR_SOURCE_DOC_AMOUNT_LIMIT
,      POR_SOURCE_DOC_MIN_RELEASE_AMT
,      POR_SOURCE_DOC_QUANTITY_AGREED
,      POR_SOURCE_DOC_MIN_ORDER_QTY
,      POR_SOURCE_DOC_MAX_ORDER_QTY
,      POR_TERMS_ID
,      POR_PAYMENT_TERMS
,      POR_SHIP_VIA_LOOKUP_CODE
,      POR_SHIP_VIA
,      POR_FREIGHT_TERMS_LOOKUP_CODE
,      POR_FREIGHT_TERMS
,      POR_FOB_LOOKUP_CODE
,      POR_FOB
,      POR_AGENT_ID
,      POR_BUYER_NAME
,      POR_CATTRIBUTE1
,      POR_CATTRIBUTE2
,      POR_CATTRIBUTE3
,      POR_CATTRIBUTE4
,      POR_CATTRIBUTE5
,      POR_CATTRIBUTE6
,      POR_CATTRIBUTE7
,      POR_CATTRIBUTE8
,      POR_CATTRIBUTE9
,      POR_CATTRIBUTE10
,      POR_CATTRIBUTE11
,      POR_CATTRIBUTE12
,      POR_CATTRIBUTE13
,      POR_CATTRIBUTE14
,      POR_CATTRIBUTE15
,      POR_TATTRIBUTE1
,      POR_TATTRIBUTE2
,      POR_TATTRIBUTE3
,      POR_TATTRIBUTE4
,      POR_TATTRIBUTE5
,      POR_TATTRIBUTE6
,      POR_TATTRIBUTE7
,      POR_TATTRIBUTE8
,      POR_TATTRIBUTE9
,      POR_TATTRIBUTE10
,      POR_TATTRIBUTE11
,      POR_TATTRIBUTE12
,      POR_TATTRIBUTE13
,      POR_TATTRIBUTE14
,      POR_TATTRIBUTE15
,      POR_AATTRIBUTE1
,      POR_AATTRIBUTE2
,      POR_AATTRIBUTE3
,      POR_AATTRIBUTE4
,      POR_AATTRIBUTE5
,      POR_AATTRIBUTE6
,      POR_AATTRIBUTE7
,      POR_AATTRIBUTE8
,      POR_AATTRIBUTE9
,      POR_AATTRIBUTE10
,      POR_AATTRIBUTE11
,      POR_AATTRIBUTE12
,      POR_AATTRIBUTE13
,      POR_AATTRIBUTE14
,      POR_AATTRIBUTE15
,      POR_IATTRIBUTE1
,      POR_IATTRIBUTE2
,      POR_IATTRIBUTE3
,      POR_IATTRIBUTE4
,      POR_IATTRIBUTE5
,      POR_IATTRIBUTE6
,      POR_IATTRIBUTE7
,      POR_IATTRIBUTE8
,      POR_IATTRIBUTE9
,      POR_IATTRIBUTE10
,      POR_IATTRIBUTE11
,      POR_IATTRIBUTE12
,      POR_IATTRIBUTE13
,      POR_IATTRIBUTE14
,      POR_IATTRIBUTE15
FROM APPS.ICX_POR_SEARCH_ITEM_MASTER_V;

Dependencies

[top of page]

APPS.ICX_POR_SEARCH_ITEM_MASTER_V references the following:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMETERS
ViewGL_SETS_OF_BOOKS
SynonymMTL_CATEGORIES_KFV
SynonymMTL_DEFAULT_CATEGORY_SETS
SynonymMTL_ITEM_CATEGORIES
SynonymMTL_SYSTEM_ITEMS_KFV

APPS.ICX_POR_SEARCH_ITEM_MASTER_V is not referenced by any database object