APPS.MSC_SDA_UTILS dependencies on MFG_LOOKUPS

Line 1543: from mfg_lookups

1539:
1540: procedure sendSDRowTypes(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) is
1541: cursor c_sd_rowtypes_cur is
1542: select lookup_code, meaning
1543: from mfg_lookups
1544: where lookup_type = c_sdview_rowtype_lookup
1545: order by 1;
1546: l_one_record varchar2(32000) := null;
1547: l_token varchar2(1000);

Line 1612: from mfg_lookups

1608:
1609: procedure sendFcstRowTypes(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) is
1610: cursor c_fcst_rowtypes_cur is
1611: select lookup_code, meaning
1612: from mfg_lookups
1613: where lookup_type = c_fcstview_rowtype_lookup
1614: order by 1;
1615: l_one_record varchar2(32000) := null;
1616: l_token varchar2(1000);

Line 1656: from mfg_lookups

1652:
1653: procedure sendHistRowTypes(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) is
1654: cursor c_hist_rowtypes_cur is
1655: select lookup_code, meaning
1656: from mfg_lookups
1657: where lookup_type = c_histview_rowtype_lookup
1658: order by 1;
1659: l_one_record varchar2(32000) := null;
1660: l_token varchar2(1000);

Line 1778: l_sql_stmt1 := 'select lookup_code, meaning from mfg_lookups where lookup_type = :1 ';

1774: l_sql_stmt4 varchar2(200);
1775: l_lookup_code number;
1776: l_meaning varchar2(250);
1777: begin
1778: l_sql_stmt1 := 'select lookup_code, meaning from mfg_lookups where lookup_type = :1 ';
1779: l_sql_stmt4 := ' and lookup_code not in (8,13,16) ';
1780: l_sql_stmt2 := 'and lookup_code not in ('|| p_lookup_code_list ||') order by 1';
1781: l_sql_stmt3 := 'and lookup_code in ('|| p_lookup_code_list ||') order by 1';
1782: