APPS.MSD_DEM_UPLOAD_FORECAST dependencies on MSC_TP_ID_LID

Line 673: msc_tp_id_lid mtil

669:
670: SELECT mtil.sr_tp_id
671: INTO x_sr_customer_pk
672: FROM
673: msc_tp_id_lid mtil
674: WHERE
675: mtil.sr_cust_account_number = x_account_number
676: and mtil.sr_instance_id = p_sr_instance_id;
677:

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

1028: x_cust_zone_level := get_level_column (x_profile_id, C_CUSTOMER_ZONE);
1029: IF (x_cust_level IS NOT NULL)
1030: THEN
1031: x_sr_customer_id := ' mtil.sr_tp_id ';
1032: x_from_clause := x_from_clause || ' msc_tp_id_lid mtil, ';
1033: ELSIF (x_ship_to_level IS NOT NULL)
1034: THEN
1035: x_sr_customer_id := ' mtpsil.sr_cust_acct_id ';
1036: ELSIF (x_cust_zone_level IS NOT NULL)