View: AMS_PRODUCT_PRICING_V

Product:	AMS - Marketing
Description:
Implementation/DBA Data:	APPS.AMS_PRODUCT_PRICING_V

View Text

SELECT QLH.LIST_HEADER_ID LIST_HEADER_ID
, QLL.LIST_LINE_ID LIST_LINE_ID
, QLH.NAME NAME
, QLH.CURRENCY_CODE CURRENCY
, QLL.START_DATE_ACTIVE START_DATE
, QLL.END_DATE_ACTIVE END_DATE
, QLL.LIST_PRICE UNIT_PRICE
, QLL.OPERAND OPERAND
, QPA.PRODUCT_UOM_CODE UNIT
, AMS_UTILITY_PVT.GET_UOM_NAME(QPA.PRODUCT_UOM_CODE) UNIT_OF_MEASURE
, QPA.PRICING_ATTRIBUTE_ID PRICING_ATTRIBUTE_ID
, LA.STATUS_CODE STATUS_CODE
, LA.USER_STATUS_ID USER_STATUS_ID
, OZF_PRICE_LIST_PVT.GET_USER_STATUS_NAME(LA.USER_STATUS_ID) USER_STATUS_NAME
, QPA.PRODUCT_ATTR_VALUE PRODUCT_ID
, IA.ITEM_OWNER_ID ITEM_OWNER_ID
, QLH.DESCRIPTION DESCRIPTION
, MSI.CONCATENATED_SEGMENTS PRODUCT_NAME
, LA.OWNER_ID
, QLL.GENERATE_USING_FORMULA_ID
, QLL.PRICE_BY_FORMULA_ID
FROM QP_LIST_HEADERS_V QLH
, QP_LIST_LINES QLL
, QP_PRICING_ATTRIBUTES QPA
, OZF_PRICE_LIST_ATTRIBUTES LA
, AMS_ITEM_ATTRIBUTES IA
, MTL_SYSTEM_ITEMS_KFV MSI
WHERE QLH.LIST_HEADER_ID = LA.QP_LIST_HEADER_ID(+)
AND MSI.ORGANIZATION_ID = TO_NUMBER(FND_PROFILE.VALUE('QP_ORGANIZATION_ID'))
AND MSI.INVENTORY_ITEM_ID = IA.INVENTORY_ITEM_ID
AND QLH.LIST_HEADER_ID = QLL.LIST_HEADER_ID
AND QLL.LIST_LINE_ID = QPA.LIST_LINE_ID
AND QPA.PRODUCT_ATTR_VALUE = TO_CHAR(IA.INVENTORY_ITEM_ID)
AND QPA.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM'
AND QPA.EXCLUDER_FLAG = 'N'

Columns