APPS.MSC_ST_UTIL dependencies on DUAL

Line 2115: FROM dual;

2111: lv_return number;
2112: BEGIN
2113: SELECT DECODE(NVL(UPPER(p_syncind),'A'),'D',1,2)
2114: INTO p_return
2115: FROM dual;
2116: EXCEPTION
2117: WHEN others THEN
2118: p_return := -1;
2119: END retn_delete_flag ;

Line 2132: FROM dual;

2128: BEGIN
2129: SELECT DECODE(NVL(UPPER(p_schedule_type),'MDS'),'MDS',1,'MPS',2,'FORECAST',6,
2130: 'SUPPLY FORECAST',2,'DEMAND_FORECAST',6,1)
2131: INTO p_schid
2132: FROM dual;
2133: EXCEPTION
2134: WHEN others THEN
2135: p_schid := -1;
2136: END retn_schedule_id;

Line 2730: ||' FROM dual';

2726: BEGIN
2727:
2728: lv_sql_stmt:=
2729: 'SELECT DECODE(SUBSTR(UPPER(NVL(:p_yes_no_code,''N'')),1,1),''Y'',1,2)'
2730: ||' FROM dual';
2731:
2732: OPEN c_cur FOR lv_sql_stmt
2733: USING p_yes_no_code;
2734: FETCH c_cur INTO p_yes_no_value;

Line 3651: ,'WORK_IN_PROCESS','MSD_WORK_IN_PROCESS',x) into stream_name from dual;

3647: select decode(upper(x),'TOTAL_BACKLOG','MSD_TOTAL_BACKLOG','PASTDUE_BACKLOG','MSD_PASTDUE_BACKLOG'
3648: ,'PRODUCTION_PLAN','MSD_PRODUCTION_PLAN','ACTUAL_PRODUCTION','MSD_ACTUAL_PRODUCTION','ONHAND_INVENTORY','MSD_ONHAND_INVENTORY'
3649: ,'SUPPLY_PLANS','MSD_SUPPLY_PLANS','CONSTRAINED_FORECAST','MSD_CONSTRAINED_FORECAST','SAFETY_STOCKS','MSD_SAFETY_STOCKS'
3650: ,'AVAIL_RESOURCE_CAPACITY','MSD_AVAIL_RESOURCE_CAPACITY','AVAIL_SUPPLIER_CAPACITY','MSD_AVAIL_SUPPLIER_CAPACITY'
3651: ,'WORK_IN_PROCESS','MSD_WORK_IN_PROCESS',x) into stream_name from dual;
3652:
3653: return stream_name;
3654: end get_stream_name;
3655: