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_STORECONFIRM_REVIEW_V

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

View Text

SELECT DISTINCT ASQL.QUOTE_ID
, MUOM.UNIT_OF_MEASURE
, TO_CHAR(ASQL.LINE_LIST_PRICE
, FND_CURRENCY.GET_FORMAT_MASK(ASQL.CURRENCY_CODE
, 30))
, TO_CHAR(ASQL.LINE_QUOTE_PRICE
, FND_CURRENCY.GET_FORMAT_MASK(ASQL.CURRENCY_CODE
, 30))
, ASQL.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, ASQL.QUANTITY
, TO_CHAR((ASQL.QUANTITY * ASQL.LINE_QUOTE_PRICE)
, 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
, MTL_UNITS_OF_MEASURE MUOM
WHERE ASQL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND ASQL.UOM_CODE = MUOM.UOM_CODE
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
UNIT_OF_MEASURE
LIST_PRICE
SEL_PRICE
INVENTORY_ITEM_ID
ITEM_NAME
ITEM_DESCRIPTION
QUANTITY
LINECOST
CURRENCY_CODE
BOM_ITEM_TYPE
GROUP_ID
TOP_BILL_SEQUENCE_ID