oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT quotelineeo.quote_line_id ,quotelineeo.quote_header_id ,quotelineeo.org_id ,quotelineeo.item_type_code ,aso_line_num_int.ASO_QUOTE_LINE_NUMBER(p_quote_line_id => quotelineeo.quote_line_id ,p_item_type_code => quotelineeo.item_type_code ,p_serviceable_product_flag => quotelineeo.serviceable_product_flag ,p_service_item_flag => quotelineeo.service_item_flag ,p_service_ref_type_code => qte_line_det.service_ref_type_code ,p_config_header_id => qte_line_det.config_header_id ,p_config_revision_num => qte_line_det.config_revision_num) ui_line_number ,quotelineeo.organization_id ,quotelineeo.inventory_item_id ,quotelineeo.quantity ,quotelineeo.uom_code ,quotelineeo.currency_code ,quote_rollups.tot_list_prc line_list_price--round((quotelineeo.line_list_price * quotelineeo.quantity), 2) line_list_price ,round(quotelineeo.line_adjusted_amount, 2) line_adjusted_amount ,round(quotelineeo.line_adjusted_percent, 2) line_adjusted_percent ,quote_rollups.tot_sell_prc line_quote_price--round(quotelineeo.line_quote_price, 2) line_quote_price ,nvl(to_number(quotelineeo.attribute10) ,DECODE(items.ITEM_TYPE,'ATO' ,(SELECT SUM(nvl(cicd.item_cost, 0)) FROM cst_item_cost_details_v cicd WHERE quotelineeo.inventory_item_id = cicd.inventory_item_id AND NVL(quotelineeo.attribute11, 284) = cicd.organization_id AND cicd.cost_type_id = 1 AND cicd.resource_id IN (28, 29)) ,'PTO' ,NULL ,(SELECT to_char(round(nvl(cic.item_cost, 0), 2)) FROM cst_item_costs cic WHERE cic.inventory_item_id = quotelineeo.inventory_item_id AND cic.organization_id = nvl(quotelineeo.attribute11, 284) AND cic.cost_type_id = 1))) att10_cost ,quotelineeo.attribute10 ,quotelineeo.attribute11 ,quotelineeo.attribute12 ,quotelineeo.attribute13 ,quotelineeo.attribute14 ,quotelineeo.attribute15 ,qte_line_det.ref_type_code ,qte_line_det.ref_line_id ,qte_line_det.top_model_line_id ,qte_line_det.ato_line_id ,items.concatenated_segments inventory_item ,items.description item_description ,items.long_description long_description ,round((quotelineeo.line_adjusted_amount * quotelineeo.quantity), 2) extended_adjusted_amount ,round((quotelineeo.line_list_price * quotelineeo.quantity), 2) extended_list_price ,round((quotelineeo.line_quote_price * quotelineeo.quantity), 2) extended_selling_price ,(CASE WHEN (quotelineeo.item_type_code = 'MDL' AND qte_line_det.complete_configuration_flag IS NOT NULL AND nvl(items.config_model_type, 'XX') <> 'N') THEN 'TOTAL' ELSE 'NOTOTAL' END) description_switcher ,(CASE WHEN (quotelineeo.item_type_code = 'MDL' AND qte_line_det.complete_configuration_flag IS NOT NULL AND nvl(items.config_model_type, 'XX') <> 'N') THEN round(aso_quote_pub_w.get_model_rollup_quote_price(quotelineeo.quote_line_id), 2) ELSE 0 END) rollup_price ,round((quotelineeo.quantity * quote_rollups.tot_sell_prc), 2) line_total_price ,decode(nvl(quotelineeo.line_list_price, 0), 0, 'A', 'P') line_discount_flag --,NULL ui_line_number ,cat_lok.meaning line_category ,0 line_discount ,ottt.NAME line_type ,'LN_DET_IMAGE' line_det_image_switcher ,muv.UNIT_OF_MEASURE --,to_char(round(nvl(cic.item_cost, 0), 2)) item_cost ,decode(item_type_code, 'MDL', 'ORG_UPDATE', 'STD', 'ORG_UPDATE', 'ORG_READONLY') org_switcher ,nvl(quotelineeo.attribute11, nvl(cic.organization_id, 284)) cost_org_id ,0 margin ,0 margin_percent ,decode((SELECT 'x' FROM aso_quote_line_details WHERE ref_line_id = quotelineeo.quote_line_id AND rownum < 2) ,NULL ,'FALSE' ,'TRUE') leaf_node_yn ,DECODE(items.ITEM_TYPE, 'ATO', 'SHOWCOST', 'PTO', 'SHOWCOST', 'AOC', 'SHOWCOST', DECODE(quotelineeo.attribute10, NULL, 'UPDCOST', 0, 'UPDCOST', 'SHOWCOST')) item_cost_switcher ,'SHOWTYPE' adj_type_switcher ,'SHOWAMT' adj_amt_switcher ,'SHOWPER' adj_per_switcher ,'SHOWSP' selling_price_switcher ,'SHOWLP' list_price_switcher ,'SHOWMARGIN' margin_switcher ,'SHOWMARGINPER' margin_per_switcher ,'SHOWTOTAL' total_price_switcher ,qte_line_det.service_ref_type_code ,quotelineeo.serviceable_product_flag ,quotelineeo.service_item_flag ,NVL((SELECT SUM(quoteline.line_quote_price*quoteline.quantity) FROM aso_quote_lines_all quoteline ,aso_quote_line_details quotedetail WHERE quoteline.quote_line_id = quotedetail.quote_line_id AND quotedetail.ref_line_id = quotelineeo.quote_line_id), (quotelineeo.line_quote_price*quotelineeo.quantity)) total_price ,SYSDATE creation_date ,fnd_global.USER_ID created_by ,SYSDATE last_update_date ,fnd_global.USER_ID last_updated_by ,fnd_global.LOGIN_ID last_update_login ,/*(SELECT SUM(NVL(to_number(qotline.attribute10), 0)) FROM aso_quote_lines_all qotline ,aso_quote_line_details qotdet WHERE qotdet.ref_line_id = quotelineeo.quote_line_id AND qotline.quote_line_id = qotdet.quote_line_id) rollup_cost--*/quote_rollups.tot_cost rollup_cost FROM aso_oa_quote_lines_all_v quotelineeo ,aso_quote_line_details qte_line_det ,mtl_system_items_vl items ,mtl_units_of_measure_vl muv ,oe_transaction_types_tl ottt ,fnd_lookup_values cat_lok ,cst_item_costs cic ,cst_cost_types cct ,aso_quote_headers_all qoh ,(SELECT ql.quote_header_id ,ql.quote_line_id ,ref_line_id ,SUM(NVL(to_number(ql.attribute10), 0)) tot_cost ,SUM(NVL(ql.line_list_price, 0)) tot_list_prc ,SUM(NVL(ql.line_quote_price, 0)) tot_sell_prc ,GROUPING(ql.quote_line_id) AS qlid ,GROUPING(qld.ref_line_id) AS refid FROM aso_oa_quote_lines_all_v ql ,aso_quote_line_details qld WHERE ql.quote_line_id = qld.quote_line_id(+) AND ql.quote_header_id = 120318 AND (NOT regexp_like(ql.attribute10,'[^0-9.]+') OR ql.attribute10 IS NULL) GROUP BY CUBE (ql.quote_header_id, ql.quote_line_id, qld.ref_line_id)) quote_rollups WHERE quotelineeo.quote_header_id = :1 AND quotelineeo.quote_line_id = qte_line_det.quote_line_id(+) AND quotelineeo.inventory_item_id = items.inventory_item_id AND quotelineeo.organization_id = items.organization_id AND quotelineeo.line_category_code = cat_lok.lookup_code(+) AND quotelineeo.uom_code = muv.uom_code AND cat_lok.lookup_type(+) = 'LINE_CATEGORY' AND cat_lok.LANGUAGE(+) = userenv('LANG') AND quotelineeo.order_line_type_id = ottt.transaction_type_id(+) AND ottt.LANGUAGE(+) = userenv('LANG') AND cic.inventory_item_id(+) = quotelineeo.inventory_item_id AND cic.cost_type_id(+) = 1 --default cost type AND cic.organization_id(+) = nvl(quotelineeo.attribute11, 284) --quotelineeo.organization_id AND cct.cost_type_id(+) = cic.cost_type_id AND quotelineeo.quote_header_id = qoh.quote_header_id AND ((items.ITEM_TYPE NOT IN ('PTO', 'ATO', 'AOC') AND quote_rollups.quote_header_id = quotelineeo.quote_header_id AND quote_rollups.quote_line_id = quotelineeo.quote_line_id AND quote_rollups.ref_line_id IS NULL AND quote_rollups.refid = 1) OR(items.ITEM_TYPE IN ('ATO', 'AOC') AND quote_rollups.quote_header_id = quotelineeo.quote_header_id AND quote_rollups.ref_line_id = quotelineeo.quote_line_id AND quote_rollups.quote_line_id IS NULL AND quote_rollups.refid = 0) OR(items.ITEM_TYPE = 'PTO' AND quote_rollups.quote_header_id = quotelineeo.quote_header_id AND quote_rollups.ref_line_id IS NULL AND quote_rollups.qlid = 1 AND quote_rollups.refid = 1)) ORDER BY LINE_NUMBER) QRSLT WHERE REF_LINE_ID = :1

Oracle Community | AlkaT. | 4 years ago
  1. 0

    Error with bind parameter

    Oracle Community | 4 years ago | AlkaT.
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT quotelineeo.quote_line_id ,quotelineeo.quote_header_id ,quotelineeo.org_id ,quotelineeo.item_type_code ,aso_line_num_int.ASO_QUOTE_LINE_NUMBER(p_quote_line_id => quotelineeo.quote_line_id ,p_item_type_code => quotelineeo.item_type_code ,p_serviceable_product_flag => quotelineeo.serviceable_product_flag ,p_service_item_flag => quotelineeo.service_item_flag ,p_service_ref_type_code => qte_line_det.service_ref_type_code ,p_config_header_id => qte_line_det.config_header_id ,p_config_revision_num => qte_line_det.config_revision_num) ui_line_number ,quotelineeo.organization_id ,quotelineeo.inventory_item_id ,quotelineeo.quantity ,quotelineeo.uom_code ,quotelineeo.currency_code ,quote_rollups.tot_list_prc line_list_price--round((quotelineeo.line_list_price * quotelineeo.quantity), 2) line_list_price ,round(quotelineeo.line_adjusted_amount, 2) line_adjusted_amount ,round(quotelineeo.line_adjusted_percent, 2) line_adjusted_percent ,quote_rollups.tot_sell_prc line_quote_price--round(quotelineeo.line_quote_price, 2) line_quote_price ,nvl(to_number(quotelineeo.attribute10) ,DECODE(items.ITEM_TYPE,'ATO' ,(SELECT SUM(nvl(cicd.item_cost, 0)) FROM cst_item_cost_details_v cicd WHERE quotelineeo.inventory_item_id = cicd.inventory_item_id AND NVL(quotelineeo.attribute11, 284) = cicd.organization_id AND cicd.cost_type_id = 1 AND cicd.resource_id IN (28, 29)) ,'PTO' ,NULL ,(SELECT to_char(round(nvl(cic.item_cost, 0), 2)) FROM cst_item_costs cic WHERE cic.inventory_item_id = quotelineeo.inventory_item_id AND cic.organization_id = nvl(quotelineeo.attribute11, 284) AND cic.cost_type_id = 1))) att10_cost ,quotelineeo.attribute10 ,quotelineeo.attribute11 ,quotelineeo.attribute12 ,quotelineeo.attribute13 ,quotelineeo.attribute14 ,quotelineeo.attribute15 ,qte_line_det.ref_type_code ,qte_line_det.ref_line_id ,qte_line_det.top_model_line_id ,qte_line_det.ato_line_id ,items.concatenated_segments inventory_item ,items.description item_description ,items.long_description long_description ,round((quotelineeo.line_adjusted_amount * quotelineeo.quantity), 2) extended_adjusted_amount ,round((quotelineeo.line_list_price * quotelineeo.quantity), 2) extended_list_price ,round((quotelineeo.line_quote_price * quotelineeo.quantity), 2) extended_selling_price ,(CASE WHEN (quotelineeo.item_type_code = 'MDL' AND qte_line_det.complete_configuration_flag IS NOT NULL AND nvl(items.config_model_type, 'XX') <> 'N') THEN 'TOTAL' ELSE 'NOTOTAL' END) description_switcher ,(CASE WHEN (quotelineeo.item_type_code = 'MDL' AND qte_line_det.complete_configuration_flag IS NOT NULL AND nvl(items.config_model_type, 'XX') <> 'N') THEN round(aso_quote_pub_w.get_model_rollup_quote_price(quotelineeo.quote_line_id), 2) ELSE 0 END) rollup_price ,round((quotelineeo.quantity * quote_rollups.tot_sell_prc), 2) line_total_price ,decode(nvl(quotelineeo.line_list_price, 0), 0, 'A', 'P') line_discount_flag --,NULL ui_line_number ,cat_lok.meaning line_category ,0 line_discount ,ottt.NAME line_type ,'LN_DET_IMAGE' line_det_image_switcher ,muv.UNIT_OF_MEASURE --,to_char(round(nvl(cic.item_cost, 0), 2)) item_cost ,decode(item_type_code, 'MDL', 'ORG_UPDATE', 'STD', 'ORG_UPDATE', 'ORG_READONLY') org_switcher ,nvl(quotelineeo.attribute11, nvl(cic.organization_id, 284)) cost_org_id ,0 margin ,0 margin_percent ,decode((SELECT 'x' FROM aso_quote_line_details WHERE ref_line_id = quotelineeo.quote_line_id AND rownum < 2) ,NULL ,'FALSE' ,'TRUE') leaf_node_yn ,DECODE(items.ITEM_TYPE, 'ATO', 'SHOWCOST', 'PTO', 'SHOWCOST', 'AOC', 'SHOWCOST', DECODE(quotelineeo.attribute10, NULL, 'UPDCOST', 0, 'UPDCOST', 'SHOWCOST')) item_cost_switcher ,'SHOWTYPE' adj_type_switcher ,'SHOWAMT' adj_amt_switcher ,'SHOWPER' adj_per_switcher ,'SHOWSP' selling_price_switcher ,'SHOWLP' list_price_switcher ,'SHOWMARGIN' margin_switcher ,'SHOWMARGINPER' margin_per_switcher ,'SHOWTOTAL' total_price_switcher ,qte_line_det.service_ref_type_code ,quotelineeo.serviceable_product_flag ,quotelineeo.service_item_flag ,NVL((SELECT SUM(quoteline.line_quote_price*quoteline.quantity) FROM aso_quote_lines_all quoteline ,aso_quote_line_details quotedetail WHERE quoteline.quote_line_id = quotedetail.quote_line_id AND quotedetail.ref_line_id = quotelineeo.quote_line_id), (quotelineeo.line_quote_price*quotelineeo.quantity)) total_price ,SYSDATE creation_date ,fnd_global.USER_ID created_by ,SYSDATE last_update_date ,fnd_global.USER_ID last_updated_by ,fnd_global.LOGIN_ID last_update_login ,/*(SELECT SUM(NVL(to_number(qotline.attribute10), 0)) FROM aso_quote_lines_all qotline ,aso_quote_line_details qotdet WHERE qotdet.ref_line_id = quotelineeo.quote_line_id AND qotline.quote_line_id = qotdet.quote_line_id) rollup_cost--*/quote_rollups.tot_cost rollup_cost FROM aso_oa_quote_lines_all_v quotelineeo ,aso_quote_line_details qte_line_det ,mtl_system_items_vl items ,mtl_units_of_measure_vl muv ,oe_transaction_types_tl ottt ,fnd_lookup_values cat_lok ,cst_item_costs cic ,cst_cost_types cct ,aso_quote_headers_all qoh ,(SELECT ql.quote_header_id ,ql.quote_line_id ,ref_line_id ,SUM(NVL(to_number(ql.attribute10), 0)) tot_cost ,SUM(NVL(ql.line_list_price, 0)) tot_list_prc ,SUM(NVL(ql.line_quote_price, 0)) tot_sell_prc ,GROUPING(ql.quote_line_id) AS qlid ,GROUPING(qld.ref_line_id) AS refid FROM aso_oa_quote_lines_all_v ql ,aso_quote_line_details qld WHERE ql.quote_line_id = qld.quote_line_id(+) AND ql.quote_header_id = 120318 AND (NOT regexp_like(ql.attribute10,'[^0-9.]+') OR ql.attribute10 IS NULL) GROUP BY CUBE (ql.quote_header_id, ql.quote_line_id, qld.ref_line_id)) quote_rollups WHERE quotelineeo.quote_header_id = :1 AND quotelineeo.quote_line_id = qte_line_det.quote_line_id(+) AND quotelineeo.inventory_item_id = items.inventory_item_id AND quotelineeo.organization_id = items.organization_id AND quotelineeo.line_category_code = cat_lok.lookup_code(+) AND quotelineeo.uom_code = muv.uom_code AND cat_lok.lookup_type(+) = 'LINE_CATEGORY' AND cat_lok.LANGUAGE(+) = userenv('LANG') AND quotelineeo.order_line_type_id = ottt.transaction_type_id(+) AND ottt.LANGUAGE(+) = userenv('LANG') AND cic.inventory_item_id(+) = quotelineeo.inventory_item_id AND cic.cost_type_id(+) = 1 --default cost type AND cic.organization_id(+) = nvl(quotelineeo.attribute11, 284) --quotelineeo.organization_id AND cct.cost_type_id(+) = cic.cost_type_id AND quotelineeo.quote_header_id = qoh.quote_header_id AND ((items.ITEM_TYPE NOT IN ('PTO', 'ATO', 'AOC') AND quote_rollups.quote_header_id = quotelineeo.quote_header_id AND quote_rollups.quote_line_id = quotelineeo.quote_line_id AND quote_rollups.ref_line_id IS NULL AND quote_rollups.refid = 1) OR(items.ITEM_TYPE IN ('ATO', 'AOC') AND quote_rollups.quote_header_id = quotelineeo.quote_header_id AND quote_rollups.ref_line_id = quotelineeo.quote_line_id AND quote_rollups.quote_line_id IS NULL AND quote_rollups.refid = 0) OR(items.ITEM_TYPE = 'PTO' AND quote_rollups.quote_header_id = quotelineeo.quote_header_id AND quote_rollups.ref_line_id IS NULL AND quote_rollups.qlid = 1 AND quote_rollups.refid = 1)) ORDER BY LINE_NUMBER) QRSLT WHERE REF_LINE_ID = :1
  2. 0

    Unknown Macro: "Existsroute" (File: Drivers\Kinetis\Sdhc_Ldd.Rgi)

    wpthm.com | 1 year ago
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 0
  3. 0

    Users Getting "Unknown User" In Pre-Boot Despite Log/Epo Showing Otherwise

    wpthm.com | 1 year ago
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 0
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    db:: 5.06::error exception unknown 3d

    hivmr.com | 11 months ago
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 0
  6. 0

    db:: 4.21::Exception from "Unknown Source" using swing component, any debug tip ? p7

    hivmr.com | 8 months ago
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 0

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. oracle.apps.fnd.framework.OAException

      oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT quotelineeo.quote_line_id ,quotelineeo.quote_header_id ,quotelineeo.org_id ,quotelineeo.item_type_code ,aso_line_num_int.ASO_QUOTE_LINE_NUMBER(p_quote_line_id => quotelineeo.quote_line_id ,p_item_type_code => quotelineeo.item_type_code ,p_serviceable_product_flag => quotelineeo.serviceable_product_flag ,p_service_item_flag => quotelineeo.service_item_flag ,p_service_ref_type_code => qte_line_det.service_ref_type_code ,p_config_header_id => qte_line_det.config_header_id ,p_config_revision_num => qte_line_det.config_revision_num) ui_line_number ,quotelineeo.organization_id ,quotelineeo.inventory_item_id ,quotelineeo.quantity ,quotelineeo.uom_code ,quotelineeo.currency_code ,quote_rollups.tot_list_prc line_list_price--round((quotelineeo.line_list_price * quotelineeo.quantity), 2) line_list_price ,round(quotelineeo.line_adjusted_amount, 2) line_adjusted_amount ,round(quotelineeo.line_adjusted_percent, 2) line_adjusted_percent ,quote_rollups.tot_sell_prc line_quote_price--round(quotelineeo.line_quote_price, 2) line_quote_price ,nvl(to_number(quotelineeo.attribute10) ,DECODE(items.ITEM_TYPE,'ATO' ,(SELECT SUM(nvl(cicd.item_cost, 0)) FROM cst_item_cost_details_v cicd WHERE quotelineeo.inventory_item_id = cicd.inventory_item_id AND NVL(quotelineeo.attribute11, 284) = cicd.organization_id AND cicd.cost_type_id = 1 AND cicd.resource_id IN (28, 29)) ,'PTO' ,NULL ,(SELECT to_char(round(nvl(cic.item_cost, 0), 2)) FROM cst_item_costs cic WHERE cic.inventory_item_id = quotelineeo.inventory_item_id AND cic.organization_id = nvl(quotelineeo.attribute11, 284) AND cic.cost_type_id = 1))) att10_cost ,quotelineeo.attribute10 ,quotelineeo.attribute11 ,quotelineeo.attribute12 ,quotelineeo.attribute13 ,quotelineeo.attribute14 ,quotelineeo.attribute15 ,qte_line_det.ref_type_code ,qte_line_det.ref_line_id ,qte_line_det.top_model_line_id ,qte_line_det.ato_line_id ,items.concatenated_segments inventory_item ,items.description item_description ,items.long_description long_description ,round((quotelineeo.line_adjusted_amount * quotelineeo.quantity), 2) extended_adjusted_amount ,round((quotelineeo.line_list_price * quotelineeo.quantity), 2) extended_list_price ,round((quotelineeo.line_quote_price * quotelineeo.quantity), 2) extended_selling_price ,(CASE WHEN (quotelineeo.item_type_code = 'MDL' AND qte_line_det.complete_configuration_flag IS NOT NULL AND nvl(items.config_model_type, 'XX') <> 'N') THEN 'TOTAL' ELSE 'NOTOTAL' END) description_switcher ,(CASE WHEN (quotelineeo.item_type_code = 'MDL' AND qte_line_det.complete_configuration_flag IS NOT NULL AND nvl(items.config_model_type, 'XX') <> 'N') THEN round(aso_quote_pub_w.get_model_rollup_quote_price(quotelineeo.quote_line_id), 2) ELSE 0 END) rollup_price ,round((quotelineeo.quantity * quote_rollups.tot_sell_prc), 2) line_total_price ,decode(nvl(quotelineeo.line_list_price, 0), 0, 'A', 'P') line_discount_flag --,NULL ui_line_number ,cat_lok.meaning line_category ,0 line_discount ,ottt.NAME line_type ,'LN_DET_IMAGE' line_det_image_switcher ,muv.UNIT_OF_MEASURE --,to_char(round(nvl(cic.item_cost, 0), 2)) item_cost ,decode(item_type_code, 'MDL', 'ORG_UPDATE', 'STD', 'ORG_UPDATE', 'ORG_READONLY') org_switcher ,nvl(quotelineeo.attribute11, nvl(cic.organization_id, 284)) cost_org_id ,0 margin ,0 margin_percent ,decode((SELECT 'x' FROM aso_quote_line_details WHERE ref_line_id = quotelineeo.quote_line_id AND rownum < 2) ,NULL ,'FALSE' ,'TRUE') leaf_node_yn ,DECODE(items.ITEM_TYPE, 'ATO', 'SHOWCOST', 'PTO', 'SHOWCOST', 'AOC', 'SHOWCOST', DECODE(quotelineeo.attribute10, NULL, 'UPDCOST', 0, 'UPDCOST', 'SHOWCOST')) item_cost_switcher ,'SHOWTYPE' adj_type_switcher ,'SHOWAMT' adj_amt_switcher ,'SHOWPER' adj_per_switcher ,'SHOWSP' selling_price_switcher ,'SHOWLP' list_price_switcher ,'SHOWMARGIN' margin_switcher ,'SHOWMARGINPER' margin_per_switcher ,'SHOWTOTAL' total_price_switcher ,qte_line_det.service_ref_type_code ,quotelineeo.serviceable_product_flag ,quotelineeo.service_item_flag ,NVL((SELECT SUM(quoteline.line_quote_price*quoteline.quantity) FROM aso_quote_lines_all quoteline ,aso_quote_line_details quotedetail WHERE quoteline.quote_line_id = quotedetail.quote_line_id AND quotedetail.ref_line_id = quotelineeo.quote_line_id), (quotelineeo.line_quote_price*quotelineeo.quantity)) total_price ,SYSDATE creation_date ,fnd_global.USER_ID created_by ,SYSDATE last_update_date ,fnd_global.USER_ID last_updated_by ,fnd_global.LOGIN_ID last_update_login ,/*(SELECT SUM(NVL(to_number(qotline.attribute10), 0)) FROM aso_quote_lines_all qotline ,aso_quote_line_details qotdet WHERE qotdet.ref_line_id = quotelineeo.quote_line_id AND qotline.quote_line_id = qotdet.quote_line_id) rollup_cost--*/quote_rollups.tot_cost rollup_cost FROM aso_oa_quote_lines_all_v quotelineeo ,aso_quote_line_details qte_line_det ,mtl_system_items_vl items ,mtl_units_of_measure_vl muv ,oe_transaction_types_tl ottt ,fnd_lookup_values cat_lok ,cst_item_costs cic ,cst_cost_types cct ,aso_quote_headers_all qoh ,(SELECT ql.quote_header_id ,ql.quote_line_id ,ref_line_id ,SUM(NVL(to_number(ql.attribute10), 0)) tot_cost ,SUM(NVL(ql.line_list_price, 0)) tot_list_prc ,SUM(NVL(ql.line_quote_price, 0)) tot_sell_prc ,GROUPING(ql.quote_line_id) AS qlid ,GROUPING(qld.ref_line_id) AS refid FROM aso_oa_quote_lines_all_v ql ,aso_quote_line_details qld WHERE ql.quote_line_id = qld.quote_line_id(+) AND ql.quote_header_id = 120318 AND (NOT regexp_like(ql.attribute10,'[^0-9.]+') OR ql.attribute10 IS NULL) GROUP BY CUBE (ql.quote_header_id, ql.quote_line_id, qld.ref_line_id)) quote_rollups WHERE quotelineeo.quote_header_id = :1 AND quotelineeo.quote_line_id = qte_line_det.quote_line_id(+) AND quotelineeo.inventory_item_id = items.inventory_item_id AND quotelineeo.organization_id = items.organization_id AND quotelineeo.line_category_code = cat_lok.lookup_code(+) AND quotelineeo.uom_code = muv.uom_code AND cat_lok.lookup_type(+) = 'LINE_CATEGORY' AND cat_lok.LANGUAGE(+) = userenv('LANG') AND quotelineeo.order_line_type_id = ottt.transaction_type_id(+) AND ottt.LANGUAGE(+) = userenv('LANG') AND cic.inventory_item_id(+) = quotelineeo.inventory_item_id AND cic.cost_type_id(+) = 1 --default cost type AND cic.organization_id(+) = nvl(quotelineeo.attribute11, 284) --quotelineeo.organization_id AND cct.cost_type_id(+) = cic.cost_type_id AND quotelineeo.quote_header_id = qoh.quote_header_id AND ((items.ITEM_TYPE NOT IN ('PTO', 'ATO', 'AOC') AND quote_rollups.quote_header_id = quotelineeo.quote_header_id AND quote_rollups.quote_line_id = quotelineeo.quote_line_id AND quote_rollups.ref_line_id IS NULL AND quote_rollups.refid = 1) OR(items.ITEM_TYPE IN ('ATO', 'AOC') AND quote_rollups.quote_header_id = quotelineeo.quote_header_id AND quote_rollups.ref_line_id = quotelineeo.quote_line_id AND quote_rollups.quote_line_id IS NULL AND quote_rollups.refid = 0) OR(items.ITEM_TYPE = 'PTO' AND quote_rollups.quote_header_id = quotelineeo.quote_header_id AND quote_rollups.ref_line_id IS NULL AND quote_rollups.qlid = 1 AND quote_rollups.refid = 1)) ORDER BY LINE_NUMBER) QRSLT WHERE REF_LINE_ID = :1

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAPageBean.renderDocument
      1. oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source)
      3. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source)
      4. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source)
      4 frames