View: QP_QUALIFIER_CONTEXT_V

Product:	QP - Advanced Pricing
Description:	This view is required to change the valueset definition of QP_QUALIFIER_CONTEXT being used in two reports (QPXPACRL.rdf and QPXPRQFS.rdf) as part of attribute manager change.
Implementation/DBA Data:	APPS.QP_QUALIFIER_CONTEXT_V

View Text

SELECT B.QUALIFIER_CONTEXT CONTEXT
, A.FORM_LEFT_PROMPT DESCRIPTION
FROM QP_QUALIFIERS_V B
, FND_DESCR_FLEX_COL_USAGE_VL A
WHERE B.ROWID IN (SELECT MAX(C.ROWID)
FROM QP_QUALIFIERS_V C GROUP BY C.QUALIFIER_CONTEXT)
AND A.APPLICATION_ID IN (SELECT D.APPLICATION_ID
FROM FND_APPLICATION D
WHERE D.APPLICATION_SHORT_NAME = 'QP')
AND A.DESCRIPTIVE_FLEXFIELD_NAME = 'QP_ATTR_DEFNS_QUALIFIER'
AND A.DESCRIPTIVE_FLEX_CONTEXT_CODE = B.QUALIFIER_CONTEXT
AND A.APPLICATION_COLUMN_NAME = B.QUALIFIER_ATTRIBUTE
AND QP_UTIL.ATTRMGR_INSTALLED = 'N' UNION SELECT B.QUALIFIER_CONTEXT CONTEXT
, A.USER_SEGMENT_NAME DESCRIPTION
FROM QP_SEGMENTS_TL A
, QP_QUALIFIERS_V B
, QP_PRC_CONTEXTS_TL C
, QP_SEGMENTS_B D
, QP_PRC_CONTEXTS_B E
, QP_PTE_SEGMENTS H
WHERE B.ROWID IN (SELECT MAX(G.ROWID)
FROM QP_QUALIFIERS_V G GROUP BY G.QUALIFIER_CONTEXT)
AND D.APPLICATION_ID IN (SELECT F.APPLICATION_ID
FROM FND_APPLICATION F
WHERE F.APPLICATION_SHORT_NAME = 'QP')
AND E.PRC_CONTEXT_TYPE = 'QUALIFIER'
AND E.PRC_CONTEXT_CODE = B.QUALIFIER_CONTEXT
AND D.SEGMENT_MAPPING_COLUMN = B.QUALIFIER_ATTRIBUTE
AND H.PTE_CODE = NVL(FND_PROFILE.VALUE('QP_PRICING_TRANSACTION_ENTITY')
, 'ORDFUL')
AND D.SEGMENT_ID = H.SEGMENT_ID
AND D.PRC_CONTEXT_ID = E.PRC_CONTEXT_ID
AND H.LOV_ENABLED = 'Y'
AND E.ENABLED_FLAG = 'Y'
AND A.SEGMENT_ID = D.SEGMENT_ID
AND A.LANGUAGE = USERENV('LANG')
AND D.PRC_CONTEXT_ID = E.PRC_CONTEXT_ID
AND C.PRC_CONTEXT_ID = E.PRC_CONTEXT_ID
AND C.LANGUAGE = USERENV('LANG')
AND QP_UTIL.ATTRMGR_INSTALLED = 'Y'

Columns