View: ICX_POR_SEARCH_ITEM_MASTER_V

Product:	ICX - Oracle iProcurement
Description:
Implementation/DBA Data:	APPS.ICX_POR_SEARCH_ITEM_MASTER_V

View Text

SELECT TO_NUMBER(NULL) POR_ASL_ID
, TO_CHAR(NULL) POR_TEMPLATE_NAME
, TO_NUMBER(NULL) POR_TEMPLATE_LINE_NUM
, TO_CHAR(NULL) POR_RESERVE_PO_NUMBER
, TO_DATE(NULL) POR_TEMPLATE_INACTIVE_DATE
, TO_CHAR(NULL) POR_RFQ_REQUIRED_FLAG
, TO_NUMBER(NULL) POR_LINE_TYPE_ID
, TO_CHAR(NULL) POR_LINE_TYPE
, TO_CHAR(NULL) POR_ORDER_TYPE_CODE
, TO_CHAR(NULL) POR_ORDER_TYPE
, MSIK.INVENTORY_ITEM_ID POR_ITEM_ID
, MSIK.DESCRIPTION POR_ITEM_DESCRIPTION
, MSIK.CONCATENATED_SEGMENTS POR_ITEM_NUM
, TO_CHAR(NULL) POR_ITEM_REVISION
, MSIK.ATTRIBUTE14 POR_ITEM_URL
, MSIK.FULL_LEAD_TIME POR_ITEM_LT
, MSIK.PURCHASING_ENABLED_FLAG POR_ITEM_PURCHASABLE_FLAG
, MSIK.INVENTORY_ITEM_FLAG POR_ITEM_INVENTORY_FLAG
, MSIK.MUST_USE_APPROVED_VENDOR_FLAG POR_USE_APPROVED_SUPPLIER
, MCK.CATEGORY_ID POR_CATEGORY_ID
, MCK.CONCATENATED_SEGMENTS POR_CATEGORY
, MCK.DESCRIPTION POR_CATEGORY_DESC
, TO_NUMBER(NULL) POR_SUPPLIER_ID
, TO_CHAR(NULL) POR_SUPPL_NAME
, TO_NUMBER(NULL) POR_SUPPLIER_SITE_ID
, TO_CHAR(NULL) POR_SUPPL_SITE
, TO_NUMBER(NULL) POR_SUPPLIER_CONTACT_ID
, TO_CHAR(NULL) POR_SUPPL_CONTACT
, TO_CHAR(NULL) POR_SUPPL_CONTACT_PHONE
, TO_CHAR(NULL) POR_SUPPL_URL
, TO_CHAR(NULL) POR_SUPPL_ITEM_NUM
, TO_CHAR(NULL) POR_SUPPL_ITEM_URL
, TO_CHAR(NULL) POR_SUPPL_HOLD_FLAG
, TO_CHAR(NULL) POR_MANUFACTURER_NAME
, TO_CHAR(NULL) POR_MANUFACTURER_PART_NUM
, MSIK.PRIMARY_UNIT_OF_MEASURE POR_UNIT_OF_MEASURE
, GSB.CURRENCY_CODE POR_CURRENCY_CODE
, TO_NUMBER(NULL) POR_CURRENCY_LINE_PRICE
, TO_CHAR(NULL) POR_FOREIGN_CURRENCY_CODE
, TO_CHAR(NULL) POR_RATE_TYPE
, TO_CHAR(NULL) POR_FOREIGN_CURRENCY_RATE_TYPE
, TO_DATE(NULL) POR_FOREIGN_CURRENCY_RATE_DATE
, TO_NUMBER(NULL) POR_FOREIGN_CURRENCY_RATE
, MSIK.LIST_PRICE_PER_UNIT POR_UNIT_PRICE
, TO_CHAR(NULL) POR_TYPE_LOOKUP_CODE
, TO_CHAR(NULL) POR_SOURCE_DOC_TYPE_CODE
, TO_NUMBER(NULL) POR_PO_HEADER_ID
, TO_CHAR(NULL) POR_SOURCE_DOC_NUM
, TO_NUMBER(NULL) POR_PO_LINE_ID
, TO_NUMBER(NULL) POR_SOURCE_DOC_LINE_NUM
, TO_DATE(NULL) POR_SOURCE_DOC_EFFECTIVE_FROM
, TO_DATE(NULL) POR_SOURCE_DOC_EFFECTIVE_TO
, TO_NUMBER(NULL) POR_SOURCE_DOC_AMOUNT_AGREED
, TO_NUMBER(NULL) POR_SOURCE_DOC_AMOUNT_LIMIT
, TO_NUMBER(NULL) POR_SOURCE_DOC_MIN_RELEASE_AMT
, TO_NUMBER(NULL) POR_SOURCE_DOC_QUANTITY_AGREED
, TO_NUMBER(NULL) POR_SOURCE_DOC_MIN_ORDER_QTY
, TO_NUMBER(NULL) POR_SOURCE_DOC_MAX_ORDER_QTY
, TO_NUMBER(NULL) POR_TERMS_ID
, TO_NUMBER(NULL) POR_PAYMENT_TERMS
, TO_CHAR(NULL) POR_SHIP_VIA_LOOKUP_CODE
, TO_CHAR(NULL) POR_SHIP_VIA
, TO_CHAR(NULL) POR_FREIGHT_TERMS_LOOKUP_CODE
, TO_CHAR(NULL) POR_FREIGHT_TERMS
, TO_CHAR(NULL) POR_FOB_LOOKUP_CODE
, TO_CHAR(NULL) POR_FOB
, TO_NUMBER(NULL) POR_AGENT_ID
, TO_CHAR(NULL) POR_BUYER_NAME
, TO_CHAR(NULL) POR_CATTRIBUTE1
, TO_CHAR(NULL) POR_CATTRIBUTE2
, TO_CHAR(NULL) POR_CATTRIBUTE3
, TO_CHAR(NULL) POR_CATTRIBUTE4
, TO_CHAR(NULL) POR_CATTRIBUTE5
, TO_CHAR(NULL) POR_CATTRIBUTE6
, TO_CHAR(NULL) POR_CATTRIBUTE7
, TO_CHAR(NULL) POR_CATTRIBUTE8
, TO_CHAR(NULL) POR_CATTRIBUTE9
, TO_CHAR(NULL) POR_CATTRIBUTE10
, TO_CHAR(NULL) POR_CATTRIBUTE11
, TO_CHAR(NULL) POR_CATTRIBUTE12
, TO_CHAR(NULL) POR_CATTRIBUTE13
, TO_CHAR(NULL) POR_CATTRIBUTE14
, TO_CHAR(NULL) POR_CATTRIBUTE15
, TO_CHAR(NULL) POR_TATTRIBUTE1
, TO_CHAR(NULL) POR_TATTRIBUTE2
, TO_CHAR(NULL) POR_TATTRIBUTE3
, TO_CHAR(NULL) POR_TATTRIBUTE4
, TO_CHAR(NULL) POR_TATTRIBUTE5
, TO_CHAR(NULL) POR_TATTRIBUTE6
, TO_CHAR(NULL) POR_TATTRIBUTE7
, TO_CHAR(NULL) POR_TATTRIBUTE8
, TO_CHAR(NULL) POR_TATTRIBUTE9
, TO_CHAR(NULL) POR_TATTRIBUTE10
, TO_CHAR(NULL) POR_TATTRIBUTE11
, TO_CHAR(NULL) POR_TATTRIBUTE12
, TO_CHAR(NULL) POR_TATTRIBUTE13
, TO_CHAR(NULL) POR_TATTRIBUTE14
, TO_CHAR(NULL) POR_TATTRIBUTE15
, TO_CHAR(NULL) POR_AATTRIBUTE1
, TO_CHAR(NULL) POR_AATTRIBUTE2
, TO_CHAR(NULL) POR_AATTRIBUTE3
, TO_CHAR(NULL) POR_AATTRIBUTE4
, TO_CHAR(NULL) POR_AATTRIBUTE5
, TO_CHAR(NULL) POR_AATTRIBUTE6
, TO_CHAR(NULL) POR_AATTRIBUTE7
, TO_CHAR(NULL) POR_AATTRIBUTE8
, TO_CHAR(NULL) POR_AATTRIBUTE9
, TO_CHAR(NULL) POR_AATTRIBUTE10
, TO_CHAR(NULL) POR_AATTRIBUTE11
, TO_CHAR(NULL) POR_AATTRIBUTE12
, TO_CHAR(NULL) POR_AATTRIBUTE13
, TO_CHAR(NULL) POR_AATTRIBUTE14
, TO_CHAR(NULL) POR_AATTRIBUTE15
, MSIK.ATTRIBUTE1 POR_IATTRIBUTE1
, MSIK.ATTRIBUTE2 POR_IATTRIBUTE2
, MSIK.ATTRIBUTE3 POR_IATTRIBUTE3
, MSIK.ATTRIBUTE4 POR_IATTRIBUTE4
, MSIK.ATTRIBUTE5 POR_IATTRIBUTE5
, MSIK.ATTRIBUTE6 POR_IATTRIBUTE6
, MSIK.ATTRIBUTE7 POR_IATTRIBUTE7
, MSIK.ATTRIBUTE8 POR_IATTRIBUTE8
, MSIK.ATTRIBUTE9 POR_IATTRIBUTE9
, MSIK.ATTRIBUTE10 POR_IATTRIBUTE10
, MSIK.ATTRIBUTE11 POR_IATTRIBUTE11
, MSIK.ATTRIBUTE12 POR_IATTRIBUTE12
, MSIK.ATTRIBUTE13 POR_IATTRIBUTE13
, MSIK.ATTRIBUTE14 POR_IATTRIBUTE14
, MSIK.ATTRIBUTE15 POR_IATTRIBUTE15
FROM GL_SETS_OF_BOOKS GSB
, MTL_CATEGORIES_KFV MCK
, MTL_ITEM_CATEGORIES MIC
, MTL_SYSTEM_ITEMS_KFV MSIK
, MTL_DEFAULT_CATEGORY_SETS MDCS
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE MSIK.ORGANIZATION_ID = FSP.INVENTORY_ORGANIZATION_ID
AND MDCS.FUNCTIONAL_AREA_ID = 2
AND MIC.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND MIC.ORGANIZATION_ID = FSP.INVENTORY_ORGANIZATION_ID
AND MIC.CATEGORY_SET_ID = MDCS.CATEGORY_SET_ID
AND MCK.CATEGORY_ID = MIC.CATEGORY_ID
AND GSB.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID

Columns