151: l_customer_name as_party_customers_v.CUSTOMER_NAME%TYPE;
152: l_party_type as_party_customers_v.party_type%TYPE;
153: l_sales_stage as_sales_stages.name%TYPE;
154: l_status as_statuses_tl.meaning%TYPE;
155: l_win_loss_indicator as_statuses_b.win_loss_indicator%Type;
156: l_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;
157: l_opp_open_status_flag as_statuses_b.opp_open_status_flag%Type;
158: l_customer_category ar_lookups.meaning%TYPE;
159: l_customer_category_code as_party_customers_v.customer_category_code%TYPE;
152: l_party_type as_party_customers_v.party_type%TYPE;
153: l_sales_stage as_sales_stages.name%TYPE;
154: l_status as_statuses_tl.meaning%TYPE;
155: l_win_loss_indicator as_statuses_b.win_loss_indicator%Type;
156: l_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;
157: l_opp_open_status_flag as_statuses_b.opp_open_status_flag%Type;
158: l_customer_category ar_lookups.meaning%TYPE;
159: l_customer_category_code as_party_customers_v.customer_category_code%TYPE;
160: l_total_amount NUMBER;
153: l_sales_stage as_sales_stages.name%TYPE;
154: l_status as_statuses_tl.meaning%TYPE;
155: l_win_loss_indicator as_statuses_b.win_loss_indicator%Type;
156: l_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;
157: l_opp_open_status_flag as_statuses_b.opp_open_status_flag%Type;
158: l_customer_category ar_lookups.meaning%TYPE;
159: l_customer_category_code as_party_customers_v.customer_category_code%TYPE;
160: l_total_amount NUMBER;
161: l_sc_amount NUMBER;
709: l_converted_weighted_amount NUMBER;
710: l_conversion_rate_found VARCHAR2(1);
711: l_conversion_status_flag NUMBER;
712: l_sales_credit_amount NUMBER;
713: l_win_loss_indicator as_statuses_b.win_loss_indicator%Type;
714: l_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;
715: l_opp_open_status_flag as_statuses_b.opp_open_status_flag%Type;
716: l_quantity as_lead_lines.quantity%Type;
717: l_uom_code as_lead_lines.uom_code%Type;
710: l_conversion_rate_found VARCHAR2(1);
711: l_conversion_status_flag NUMBER;
712: l_sales_credit_amount NUMBER;
713: l_win_loss_indicator as_statuses_b.win_loss_indicator%Type;
714: l_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;
715: l_opp_open_status_flag as_statuses_b.opp_open_status_flag%Type;
716: l_quantity as_lead_lines.quantity%Type;
717: l_uom_code as_lead_lines.uom_code%Type;
718: l_uom_description as_sales_credits_denorm.uom_description%Type;
711: l_conversion_status_flag NUMBER;
712: l_sales_credit_amount NUMBER;
713: l_win_loss_indicator as_statuses_b.win_loss_indicator%Type;
714: l_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;
715: l_opp_open_status_flag as_statuses_b.opp_open_status_flag%Type;
716: l_quantity as_lead_lines.quantity%Type;
717: l_uom_code as_lead_lines.uom_code%Type;
718: l_uom_description as_sales_credits_denorm.uom_description%Type;
719: l_item_id as_lead_lines.inventory_item_id%Type;