View: QPFV_PRICE_LISTS

Product:	QP - Advanced Pricing
Description:	This view gives information about Standard and Agreement Price list headers.
Implementation/DBA Data:	APPS.QPFV_PRICE_LISTS

View Text

SELECT TL.NAME
, LH.ROUNDING_FACTOR
, LH.START_DATE_ACTIVE
, LH.END_DATE_ACTIVE
, LH.COMMENTS
, LH.ACTIVE_FLAG
, TL.DESCRIPTION
, LH.LIST_TYPE_CODE
, '_LA:LH.LIST_TYPE_CODE:QP_LOOKUPS:LIST_TYPE_CODE:MEANING'
, LH.CURRENCY_CODE
, CUR.NAME
, LH.SOURCE_SYSTEM_CODE
, '_LA:LH.SOURCE_SYSTEM_CODE:QP_LOOKUPS:SOURCE_SYSTEM:MEANING'
, LH.SHIP_METHOD_CODE
, SHIP.MEANING
, LH.FREIGHT_TERMS_CODE
, FREIGHT.FREIGHT_TERMS
, LH.LIST_HEADER_ID
, LH.TERMS_ID
, RA.NAME
, LH.CREATION_DATE
, LH.CREATED_BY
, LH.LAST_UPDATE_DATE
, LH.LAST_UPDATED_BY
, '_DF:QP:QP_LIST_HEADERS:LH'
FROM QP_LIST_HEADERS_B LH
, QP_LIST_HEADERS_TL TL
, FND_CURRENCIES_VL CUR
, OE_SHIP_METHODS_V SHIP
, OE_FRGHT_TERMS_ACTIVE_V FREIGHT
, RA_TERMS RA
WHERE LH.LIST_HEADER_ID = TL.LIST_HEADER_ID
AND TL.LANGUAGE = USERENV('LANG')
AND LH.LIST_TYPE_CODE IN ('PRL'
, 'AGR')
AND LH.CURRENCY_CODE = CUR.CURRENCY_CODE
AND LH.SHIP_METHOD_CODE = SHIP.LOOKUP_CODE (+)
AND LH.FREIGHT_TERMS_CODE = FREIGHT.FREIGHT_TERMS_CODE (+)
AND LH.TERMS_ID = RA.TERM_ID (+) WITH READ ONLY

Columns