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_STOREITEMS_REVIEW_V

Product:	ICX - Oracle iProcurement
Description:	Review Ordered Items View
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ASQL.QUOTE_ID
, ASQL.QUOTE_LINE_ID
, ASQL.CREATED_BY
, ASQL.PRICE_LIST_LINE_ID
, ASQL.INVENTORY_ITEM_ID
, ASQL.UOM_CODE
, ASQL.LINE_QUOTE_PRICE
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, MSI.ATTRIBUTE14
, ASQL.ORGANIZATION_ID
, ASQL.QUANTITY
, ASQL.LINE_QUOTE_PRICE * ASQL.QUANTITY
, TO_CHAR(( ASQL.LINE_QUOTE_PRICE * ASQL.QUANTITY)
, FND_CURRENCY.GET_FORMAT_MASK(ASQL.CURRENCY_CODE
, 30))
, ASQL.CURRENCY_CODE
, MSI.BOM_ITEM_TYPE
, ASQL.GROUP_ID
, ASQL.TOP_BILL_SEQUENCE_ID
FROM AS_QUOTE_LINES ASQL
, MTL_SYSTEM_ITEMS_KFV MSI
WHERE ASQL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND (MSI.BOM_ITEM_TYPE = 4 OR MSI.BOM_ITEM_TYPE = 1)
AND ASQL.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND ASQL.QUANTITY > 0

Columns

Name
QUOTE_ID
QUOTE_LINE_ID
CREATED_BY
PRICE_LIST_LINE_ID
INVENTORY_ITEM_ID
UNIT_OF_MEASURE
LIST_PRICE
ITEM_NAME
ITEM_DESCRIPTION
ITEM_URL
ORGANIZATION_ID
QUANTITY
COST
LINECOST
CURRENCY_CODE
BOM_ITEM_TYPE
GROUP_ID
TOP_BILL_SEQUENCE_ID