APPS.MSC_PUBLISH_SAFETY_STOCK_PKG dependencies on MFG_LOOKUPS

Line 1942: l_order_type_desc mfg_lookups.meaning%type;

1938: b_bkt_start_date dateList;
1939: b_bkt_end_date dateList;
1940: b_bkt_type numberList;
1941:
1942: l_order_type_desc mfg_lookups.meaning%type;
1943: l_log_message VARCHAR2(1000);
1944: l_rowcount number;
1945: l_qty number;
1946: l_exp_qty number;

Line 1950: l_bucket_type_desc mfg_lookups.meaning%type;

1946: l_exp_qty number;
1947: l_record_inserted number;
1948: l_next_work_date msc_calendar_dates.calendar_date%type;
1949: l_prev_work_date date;
1950: l_bucket_type_desc mfg_lookups.meaning%type;
1951: l_date date;
1952: l_total number;
1953: l_plan_start_date date;
1954:

Line 3437: from mfg_lookups

3433: --Get the order type desc. Takes care of order type renaming.
3434: BEGIN
3435: select meaning
3436: into l_order_type_desc
3437: from mfg_lookups
3438: where lookup_type = 'MSC_X_ORDER_TYPE'
3439: and lookup_code = p_order_type_code;
3440:
3441: return l_order_type_desc;