View: AMS_PRODUCT_PRL_IMP_V

Product:	AMS - Marketing
Description:	This view returns price list line of a given inventory item.
Implementation/DBA Data:	APPS.AMS_PRODUCT_PRL_IMP_V

View Text

SELECT QLH.NAME
, TO_NUMBER(QPA.PRODUCT_ATTR_VALUE)
, QLL.LIST_LINE_ID
, QLH.LIST_HEADER_ID
, QLH.CURRENCY_CODE
, QPA.PRODUCT_UOM_CODE
, AMS_UTILITY_PVT.GET_UOM_NAME(QPA.PRODUCT_UOM_CODE)
, QLL.OPERAND
FROM QP_LIST_HEADERS_V QLH
, QP_LIST_LINES QLL
, QP_PRICING_ATTRIBUTES QPA
WHERE QLH.LIST_HEADER_ID = QLL.LIST_HEADER_ID
AND QLL.LIST_LINE_ID = QPA.LIST_LINE_ID
AND QPA.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM'
AND QPA.EXCLUDER_FLAG = 'N'

Columns