VIEW: APPS.QPR_SR_QUOTE_LINE_NUM_V

Source

View Text - Preformatted

SELECT line.quote_header_id, line.quote_line_id, nvl((SELECT application_id FROM fnd_application_vl WHERE application_short_name = 'ASO' AND rownum < 2), qpr_sr_util.get_null_pk) source_id, aso_line_num_int.aso_quote_line_number(line.quote_line_id, line.item_type_code, line.serviceable_product_flag, line.service_item_flag, line.service_ref_type_code, line.config_header_id, line.config_revision_num) line_num from (select l.quote_header_id, l.quote_line_id , l.item_type_code, l.serviceable_product_flag, l.service_item_flag, ldet.service_ref_type_code, ldet.config_header_id, ldet.config_revision_num from aso_quote_lines_all l, aso_quote_line_details ldet where l.quote_line_id = ldet.quote_line_id(+) ORDER BY l.line_number, decode(ldet.service_ref_type_code, 'QUOTE', (SELECT bom_sort_order FROM aso_quote_line_details WHERE quote_line_id = ldet.service_ref_line_id), ldet.bom_sort_order), decode(ldet.service_ref_type_code, 'QUOTE', ldet.service_ref_line_id, l.quote_line_id), decode(l.serviceable_product_flag, 'Y', 0, l.quote_line_id) ) line

View Text - HTML Formatted

SELECT LINE.QUOTE_HEADER_ID
, LINE.QUOTE_LINE_ID
, NVL((SELECT APPLICATION_ID
FROM FND_APPLICATION_VL
WHERE APPLICATION_SHORT_NAME = 'ASO'
AND ROWNUM < 2)
, QPR_SR_UTIL.GET_NULL_PK) SOURCE_ID
, ASO_LINE_NUM_INT.ASO_QUOTE_LINE_NUMBER(LINE.QUOTE_LINE_ID
, LINE.ITEM_TYPE_CODE
, LINE.SERVICEABLE_PRODUCT_FLAG
, LINE.SERVICE_ITEM_FLAG
, LINE.SERVICE_REF_TYPE_CODE
, LINE.CONFIG_HEADER_ID
, LINE.CONFIG_REVISION_NUM) LINE_NUM
FROM (SELECT L.QUOTE_HEADER_ID
, L.QUOTE_LINE_ID
, L.ITEM_TYPE_CODE
, L.SERVICEABLE_PRODUCT_FLAG
, L.SERVICE_ITEM_FLAG
, LDET.SERVICE_REF_TYPE_CODE
, LDET.CONFIG_HEADER_ID
, LDET.CONFIG_REVISION_NUM
FROM ASO_QUOTE_LINES_ALL L
, ASO_QUOTE_LINE_DETAILS LDET
WHERE L.QUOTE_LINE_ID = LDET.QUOTE_LINE_ID(+) ORDER BY L.LINE_NUMBER
, DECODE(LDET.SERVICE_REF_TYPE_CODE
, 'QUOTE'
, (SELECT BOM_SORT_ORDER
FROM ASO_QUOTE_LINE_DETAILS
WHERE QUOTE_LINE_ID = LDET.SERVICE_REF_LINE_ID)
, LDET.BOM_SORT_ORDER)
, DECODE(LDET.SERVICE_REF_TYPE_CODE
, 'QUOTE'
, LDET.SERVICE_REF_LINE_ID
, L.QUOTE_LINE_ID)
, DECODE(L.SERVICEABLE_PRODUCT_FLAG
, 'Y'
, 0
, L.QUOTE_LINE_ID) ) LINE