VIEW: APPS.QP_PB_INPUT_LINES_V

Source

View Text - Preformatted

SELECT L.RowId ROW_ID, L.PB_INPUT_LINE_ID, L.PB_INPUT_HEADER_ID, L.CREATION_DATE, L.CREATED_BY, L.LAST_UPDATE_DATE, L.LAST_UPDATED_BY, L.LAST_UPDATE_LOGIN, L.CONTEXT, L.ATTRIBUTE, L.ATTRIBUTE_VALUE, L.ATTRIBUTE_TYPE, nvl(c.user_prc_context_name,c.seeded_prc_context_name) CONTEXT_NAME, nvl(b.user_segment_name,b.seeded_segment_name) ATTRIBUTE_NAME, QP_Price_Book_Util.get_attribute_value_common(L.ATTRIBUTE_TYPE,L.CONTEXT,b.segment_code, L.ATTRIBUTE_VALUE) ATTRIBUTE_VALUE_NAME, QP_Price_Book_Util.value_to_meaning(L.ATTRIBUTE_TYPE,'DISPLAY_ATTRIBUTE_TYPE') ATTRIBUTE_TYPE_VALUE FROM QP_PB_INPUT_LINES L, qp_segments_v b, qp_prc_contexts_v c WHERE c.prc_context_type = l.attribute_type AND c.prc_context_code = l.context AND b.segment_mapping_column = l.attribute AND b.prc_context_id = c.prc_context_id

View Text - HTML Formatted

SELECT L.ROWID ROW_ID
, L.PB_INPUT_LINE_ID
, L.PB_INPUT_HEADER_ID
, L.CREATION_DATE
, L.CREATED_BY
, L.LAST_UPDATE_DATE
, L.LAST_UPDATED_BY
, L.LAST_UPDATE_LOGIN
, L.CONTEXT
, L.ATTRIBUTE
, L.ATTRIBUTE_VALUE
, L.ATTRIBUTE_TYPE
, NVL(C.USER_PRC_CONTEXT_NAME
, C.SEEDED_PRC_CONTEXT_NAME) CONTEXT_NAME
, NVL(B.USER_SEGMENT_NAME
, B.SEEDED_SEGMENT_NAME) ATTRIBUTE_NAME
, QP_PRICE_BOOK_UTIL.GET_ATTRIBUTE_VALUE_COMMON(L.ATTRIBUTE_TYPE
, L.CONTEXT
, B.SEGMENT_CODE
, L.ATTRIBUTE_VALUE) ATTRIBUTE_VALUE_NAME
, QP_PRICE_BOOK_UTIL.VALUE_TO_MEANING(L.ATTRIBUTE_TYPE
, 'DISPLAY_ATTRIBUTE_TYPE') ATTRIBUTE_TYPE_VALUE
FROM QP_PB_INPUT_LINES L
, QP_SEGMENTS_V B
, QP_PRC_CONTEXTS_V C
WHERE C.PRC_CONTEXT_TYPE = L.ATTRIBUTE_TYPE
AND C.PRC_CONTEXT_CODE = L.CONTEXT
AND B.SEGMENT_MAPPING_COLUMN = L.ATTRIBUTE
AND B.PRC_CONTEXT_ID = C.PRC_CONTEXT_ID