VIEW: APPS.QP_QUALIFIER_CONTEXT_V

Source

View Text - Preformatted

SELECT B.QUALIFIER_CONTEXT Context, A.FORM_LEFT_PROMPT Description from QP_QUALIFIERS_V B, FND_DESCR_FLEX_COL_USAGE_VL A WHERE B.ROW_ID IN (SELECT MAX(C.ROW_ID) 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.ROW_ID IN (SELECT MAX(G.ROW_ID) 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'

View Text - HTML Formatted

SELECT B.QUALIFIER_CONTEXT CONTEXT
, A.FORM_LEFT_PROMPT DESCRIPTION
FROM QP_QUALIFIERS_V B
, FND_DESCR_FLEX_COL_USAGE_VL A
WHERE B.ROW_ID IN (SELECT MAX(C.ROW_ID)
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.ROW_ID IN (SELECT MAX(G.ROW_ID)
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'