eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: ICX_FMT_STORE_ITEMS_V

Product:	ICX - Oracle iProcurement
Description:	- Retrofitted
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PRICE_LIST_LINE_ID
, INVENTORY_ITEM_ID
, ICX.UNIT_OF_MEASURE
, UOM.UOM_CODE
, LIST_PRICE
, TO_CHAR(LIST_PRICE
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, ITEM_NAME
, ITEM_DESCRIPTION
, ITEM_URL
, PRICE_LIST_ID
, CURRENCY_CODE
, CATEGORY_ID
, ORGANIZATION_ID
, CATEGORY_SET_ID
, BOM_ITEM_TYPE
, CUSTOMER_ID
, CUSTOMER_ADDRESS_ID
, CUSTOMER_ITEM_ID
, CUSTOMER_ITEM_NAME
, CUSTOMER_CATEGORY_CODE
, ITEM_DEFINITION_LEVEL
, MASTER_ORGANIZATION_ID
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM ICX_WEBSTORE_ITEMS_V ICX
, MTL_UNITS_OF_MEASURE UOM
WHERE ICX.UNIT_OF_MEASURE = UOM.UNIT_OF_MEASURE

Columns

Name
PRICE_LIST_LINE_ID
INVENTORY_ITEM_ID
UNIT_OF_MEASURE
UOM_CODE
LIST_PRICE
FORMATTED_LIST_PRICE
ITEM_NAME
ITEM_DESCRIPTION
ITEM_URL
PRICE_LIST_ID
CURRENCY_CODE
CATEGORY_ID
ORGANIZATION_ID
CATEGORY_SET_ID
BOM_ITEM_TYPE
CUSTOMER_ID
CUSTOMER_ADDRESS_ID
CUSTOMER_ITEM_ID
CUSTOMER_ITEM_NAME
CUSTOMER_CATEGORY_CODE
ITEM_DEFINITION_LEVEL
MASTER_ORGANIZATION_ID
START_DATE_ACTIVE
END_DATE_ACTIVE