APPS.MSC_SDA_UTILS dependencies on MFG_LOOKUPS

Line 1085: from mfg_lookups

1081:
1082: procedure sendSDRowTypes(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) is
1083: cursor c_sd_rowtypes_cur is
1084: select lookup_code, meaning
1085: from mfg_lookups
1086: where lookup_type = c_sdview_rowtype_lookup
1087: order by 1;
1088: l_one_record varchar2(32000) := null;
1089: l_token varchar2(1000);

Line 1154: from mfg_lookups

1150:
1151: procedure sendFcstRowTypes(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) is
1152: cursor c_fcst_rowtypes_cur is
1153: select lookup_code, meaning
1154: from mfg_lookups
1155: where lookup_type = c_fcstview_rowtype_lookup
1156: order by 1;
1157: l_one_record varchar2(32000) := null;
1158: l_token varchar2(1000);

Line 1198: from mfg_lookups

1194:
1195: procedure sendHistRowTypes(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) is
1196: cursor c_hist_rowtypes_cur is
1197: select lookup_code, meaning
1198: from mfg_lookups
1199: where lookup_type = c_histview_rowtype_lookup
1200: order by 1;
1201: l_one_record varchar2(32000) := null;
1202: l_token varchar2(1000);

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

1311: l_sql_stmt4 varchar2(200);
1312: l_lookup_code number;
1313: l_meaning varchar2(250);
1314: begin
1315: l_sql_stmt1 := 'select lookup_code, meaning from mfg_lookups where lookup_type = :1 ';
1316: l_sql_stmt4 := ' and lookup_code not in (8,13,16) ';
1317: l_sql_stmt2 := 'and lookup_code not in ('|| p_lookup_code_list ||') order by 1';
1318: l_sql_stmt3 := 'and lookup_code in ('|| p_lookup_code_list ||') order by 1';
1319: