eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_SC_DENORM_TRG dependencies on AS_PARTY_CUSTOMERS_V

Line 151: l_customer_name as_party_customers_v.CUSTOMER_NAME%TYPE;

147: From as_lead_lines_all
148: Where lead_id = p_lead_id AND forecast_date IS NULL;
149:
150: l_customer_id as_leads_all.customer_id%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;

Line 152: l_party_type as_party_customers_v.party_type%TYPE;

148: Where lead_id = p_lead_id AND forecast_date IS NULL;
149:
150: l_customer_id as_leads_all.customer_id%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;

Line 159: l_customer_category_code as_party_customers_v.customer_category_code%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;
162: l_won_amount NUMBER;
163: l_weighted_amount NUMBER;

Line 668: l_customer_name as_party_customers_v.CUSTOMER_NAME%TYPE;

664: --l_interest_type as_interest_types_tl.interest_type%TYPE;
665: --l_primary_interest_code as_interest_codes_tl.code%TYPE;
666: --l_secondary_interest_code as_interest_codes_tl.code%TYPE;
667: l_customer_id as_leads_all.customer_id%TYPE;
668: l_customer_name as_party_customers_v.CUSTOMER_NAME%TYPE;
669: l_party_type as_party_customers_v.party_type%TYPE;
670: l_address_id as_leads_all.address_id%TYPE;
671: l_lead_number as_leads_all.lead_number%TYPE;
672: l_opp_description as_leads_all.description%TYPE;

Line 669: l_party_type as_party_customers_v.party_type%TYPE;

665: --l_primary_interest_code as_interest_codes_tl.code%TYPE;
666: --l_secondary_interest_code as_interest_codes_tl.code%TYPE;
667: l_customer_id as_leads_all.customer_id%TYPE;
668: l_customer_name as_party_customers_v.CUSTOMER_NAME%TYPE;
669: l_party_type as_party_customers_v.party_type%TYPE;
670: l_address_id as_leads_all.address_id%TYPE;
671: l_lead_number as_leads_all.lead_number%TYPE;
672: l_opp_description as_leads_all.description%TYPE;
673: l_decision_date as_leads_all.decision_date%TYPE;

Line 701: l_customer_category_code as_party_customers_v.customer_category_code%TYPE;

697: l_product_category_id as_lead_lines_all.PRODUCT_CATEGORY_ID%TYPE;
698: l_product_cat_set_id as_lead_lines_all.PRODUCT_CAT_SET_ID%TYPE;
699: l_currency_code as_leads_all.currency_code%TYPE;
700: l_customer_category ar_lookups.meaning%TYPE;
701: l_customer_category_code as_party_customers_v.customer_category_code%TYPE;
702: l_leadline_total_amount as_lead_lines_all.total_amount%TYPE;
703: l_lead_total_amount as_leads_all.total_amount%TYPE;
704: l_total_amount NUMBER;
705: l_sc_amount NUMBER;