View: QP_PTE_CONTEXT_TYPES_V

Product:	QP - Advanced Pricing
Description:	This view is used by QPXPTMAP.fmb to display the all Pricing transaction entities for all the Context type for which at least one attribute is linked to that Pricing Transaction Entity.
Implementation/DBA Data:	APPS.QP_PTE_CONTEXT_TYPES_V

View Text

SELECT A.PTE_CODE
, C.PRC_CONTEXT_TYPE
, D.MEANING PTE_MEANING
, E.MEANING PRC_CONTEXT_TYPE_MEANING
FROM QP_PTE_SEGMENTS A
, QP_SEGMENTS_B B
, QP_PRC_CONTEXTS_B C
, QP_LOOKUPS D
, QP_LOOKUPS E
WHERE A.SEGMENT_ID = B.SEGMENT_ID
AND B.PRC_CONTEXT_ID = C.PRC_CONTEXT_ID
AND A.PTE_CODE = D.LOOKUP_CODE
AND C.PRC_CONTEXT_TYPE = E.LOOKUP_CODE
AND D.LOOKUP_TYPE = 'QP_PTE_TYPE'
AND E.LOOKUP_TYPE = 'QP_CONTEXT_TYPE' GROUP BY A.PTE_CODE
, C.PRC_CONTEXT_TYPE
, D.MEANING
, E.MEANING

Columns