[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:	ICX.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

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

FINANCIALS_SYSTEM_PARAMETERS

GL_SETS_OF_BOOKS

MTL_CATEGORIES_KFV

MTL_DEFAULT_CATEGORY_SETS

MTL_ITEM_CATEGORIES

MTL_SYSTEM_ITEMS_KFV

APPS.ICX_POR_SEARCH_ITEM_MASTER_V is not referenced by any database object