VIEW: APPS.QP_PTE_CONTEXT_TYPES_V

Source

View Text - Preformatted

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' and d.lookup_type <> e.lookup_type group by a.pte_code, c.prc_context_type, d.meaning, e.meaning

View Text - HTML Formatted

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'
AND D.LOOKUP_TYPE <> E.LOOKUP_TYPE GROUP BY A.PTE_CODE
, C.PRC_CONTEXT_TYPE
, D.MEANING
, E.MEANING