DBA Data[Home] [Help]

APPS.AS_SC_DENORM_TRG dependencies on AS_STATUSES_B

Line 155: l_win_loss_indicator as_statuses_b.win_loss_indicator%Type;

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;

Line 156: l_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%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;

Line 157: l_opp_open_status_flag as_statuses_b.opp_open_status_flag%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;
161: l_sc_amount NUMBER;

Line 713: l_win_loss_indicator as_statuses_b.win_loss_indicator%Type;

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;

Line 714: l_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%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;

Line 715: l_opp_open_status_flag as_statuses_b.opp_open_status_flag%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;