[Home] [Help]
View: QPBV_SECONDARY_PRICE_LISTS
Product: | QP - Advanced Pricing |
Description: | This view gives information about Primary Price list and its Secondary Price list. |
Implementation/DBA Data: |
APPS.QPBV_SECONDARY_PRICE_LISTS
|
View Text
SELECT TL2.NAME
, TL2.LIST_HEADER_ID
, TL1.NAME
, TL1.LIST_HEADER_ID
, QUAL.QUALIFIER_PRECEDENCE
, TL1.CREATION_DATE
, TL1.CREATED_BY
, TL1.LAST_UPDATE_DATE
, TL1.LAST_UPDATED_BY
FROM QP_LIST_HEADERS_TL TL1
, QP_LIST_HEADERS_TL TL2
, QP_QUALIFIERS QUAL
WHERE QUAL.LIST_HEADER_ID = TL1.LIST_HEADER_ID
AND TL1.LANGUAGE = USERENV('LANG')
AND TL2.LANGUAGE = USERENV('LANG')
AND QUAL.LIST_TYPE_CODE IN ('PRL'
, 'AGR')
AND QUAL.QUALIFIER_CONTEXT = 'MODLIST'
AND QUAL.QUALIFIER_ATTRIBUTE = 'QUALIFIER_ATTRIBUTE4'
AND TL2.LIST_HEADER_ID = FND_NUMBER.CANONICAL_TO_NUMBER(QUAL.QUALIFIER_ATTR_VALUE)
Columns
Name |
PRIMARY_LIST_NAME |
PRIMARY_LIST_HEADER_ID |
SECONDARY_LIST_NAME |
SECONDARY_LIST_HEADER_ID |
QUALIFIER_PRECEDENCE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |