DBA Data[Home] [Help]

APPS.MSC_PUBLISH_SAFETY_STOCK_PKG dependencies on MFG_LOOKUPS

Line 1926: l_order_type_desc mfg_lookups.meaning%type;

1922: b_bkt_start_date dateList;
1923: b_bkt_end_date dateList;
1924: b_bkt_type numberList;
1925:
1926: l_order_type_desc mfg_lookups.meaning%type;
1927: l_log_message VARCHAR2(1000);
1928: l_rowcount number;
1929: l_qty number;
1930: l_exp_qty number;

Line 1934: l_bucket_type_desc mfg_lookups.meaning%type;

1930: l_exp_qty number;
1931: l_record_inserted number;
1932: l_next_work_date msc_calendar_dates.calendar_date%type;
1933: l_prev_work_date date;
1934: l_bucket_type_desc mfg_lookups.meaning%type;
1935: l_date date;
1936: l_total number;
1937: l_plan_start_date date;
1938:

Line 3421: from mfg_lookups

3417: --Get the order type desc. Takes care of order type renaming.
3418: BEGIN
3419: select meaning
3420: into l_order_type_desc
3421: from mfg_lookups
3422: where lookup_type = 'MSC_X_ORDER_TYPE'
3423: and lookup_code = p_order_type_code;
3424:
3425: return l_order_type_desc;