VIEW: APPS.QPR_SR_ADJ_HIER_V

Source

View Text - Preformatted

SELECT l.list_line_id, h.name || '-' || l.list_line_no, l.list_line_type_code, l.automatic_flag, l.arithmetic_operator, l.modifier_level_code, h.list_source_code, qpr_sr_util.get_null_pk, qpr_sr_util.get_null_desc, null, null, null, null, null, qpr_sr_util.get_null_pk, qpr_sr_util.get_null_desc, null, null, null, null, null, qpr_sr_util.get_all_adj_pk , qpr_sr_util.get_all_adj_desc, null, null, null, null, null, qpr_sr_util.get_max_date(trunc(h.last_update_date,'dd'),trunc(l.last_update_date,'dd')) FROM qp_list_lines l, qp_list_headers_vl h WHERE l.list_header_id = h.list_header_id and l.pricing_phase_id > 1 and (l.list_line_type_code in ('PBH', 'FREIGHT_CHARGE') or (l.list_line_type_code in ('DIS', 'SUR') and l.list_line_id not in(select to_rltd_modifier_id from QP_RLTD_MODIFIERS where rltd_modifier_grp_type = 'PRICE BREAK') ))

View Text - HTML Formatted

SELECT L.LIST_LINE_ID
, H.NAME || '-' || L.LIST_LINE_NO
, L.LIST_LINE_TYPE_CODE
, L.AUTOMATIC_FLAG
, L.ARITHMETIC_OPERATOR
, L.MODIFIER_LEVEL_CODE
, H.LIST_SOURCE_CODE
, QPR_SR_UTIL.GET_NULL_PK
, QPR_SR_UTIL.GET_NULL_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
, QPR_SR_UTIL.GET_NULL_PK
, QPR_SR_UTIL.GET_NULL_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
, QPR_SR_UTIL.GET_ALL_ADJ_PK
, QPR_SR_UTIL.GET_ALL_ADJ_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
, QPR_SR_UTIL.GET_MAX_DATE(TRUNC(H.LAST_UPDATE_DATE
, 'DD')
, TRUNC(L.LAST_UPDATE_DATE
, 'DD'))
FROM QP_LIST_LINES L
, QP_LIST_HEADERS_VL H
WHERE L.LIST_HEADER_ID = H.LIST_HEADER_ID
AND L.PRICING_PHASE_ID > 1
AND (L.LIST_LINE_TYPE_CODE IN ('PBH'
, 'FREIGHT_CHARGE') OR (L.LIST_LINE_TYPE_CODE IN ('DIS'
, 'SUR')
AND L.LIST_LINE_ID NOT IN(SELECT TO_RLTD_MODIFIER_ID
FROM QP_RLTD_MODIFIERS
WHERE RLTD_MODIFIER_GRP_TYPE = 'PRICE BREAK') ))