View: AMS_PRICE_LIST_LINES_V

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

View Text

SELECT QPLL.LIST_LINE_ID
, QPLL.LIST_HEADER_ID
, QPA.PRICING_ATTRIBUTE_ID
, QPA.PRODUCT_ATTR_VALUE
, QPLL.PRODUCT_PRECEDENCE
, QPA.PRODUCT_UOM_CODE
, QPLL.OPERAND
, QPLL.START_DATE_ACTIVE
, QPLL.END_DATE_ACTIVE
, MSI.PADDED_CONCATENATED_SEGMENTS
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION ITEM_DESCRIPTION
, QPLL.COMMENTS
FROM MTL_SYSTEM_ITEMS_KFV MSI
, QP_PRICING_ATTRIBUTES QPA
, QP_LIST_LINES QPLL
WHERE QPA.PRODUCT_ATTR_VALUE = TO_CHAR(MSI.INVENTORY_ITEM_ID)
AND QPA.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM'
AND QPA.EXCLUDER_FLAG = 'N'
AND MSI.ORGANIZATION_ID = TO_NUMBER(FND_PROFILE.VALUE('QP_ORGANIZATION_ID'))
AND QPLL.LIST_LINE_ID = QPA.LIST_LINE_ID
AND QPLL.LIST_LINE_TYPE_CODE = 'PLL'

Columns