APPS.MSD_DEM_UPLOAD_FORECAST dependencies on MSC_TP_ID_LID

Line 600: msc_tp_id_lid mtil

596:
597: SELECT mtil.sr_tp_id
598: INTO x_sr_customer_pk
599: FROM
600: msc_tp_id_lid mtil
601: WHERE
602: mtil.sr_cust_account_number = x_account_number
603: and mtil.sr_instance_id = p_sr_instance_id;
604:

Line 929: x_from_clause := x_from_clause || ' msc_tp_id_lid mtil, ';

925: x_cust_zone_level := get_level_column (x_profile_id, C_CUSTOMER_ZONE);
926: IF (x_cust_level IS NOT NULL)
927: THEN
928: x_sr_customer_id := ' mtil.sr_tp_id ';
929: x_from_clause := x_from_clause || ' msc_tp_id_lid mtil, ';
930: ELSIF (x_ship_to_level IS NOT NULL)
931: THEN
932: x_sr_customer_id := ' mtpsil.sr_cust_acct_id ';
933: ELSIF (x_cust_zone_level IS NOT NULL)