[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 |