APPS.MSC_ST_UTIL dependencies on DUAL

Line 2155: FROM dual;

2151: lv_return number;
2152: BEGIN
2153: SELECT DECODE(NVL(UPPER(p_syncind),'A'),'D',1,2)
2154: INTO p_return
2155: FROM dual;
2156: EXCEPTION
2157: WHEN others THEN
2158: p_return := -1;
2159: END retn_delete_flag ;

Line 2172: FROM dual;

2168: BEGIN
2169: SELECT DECODE(NVL(UPPER(p_schedule_type),'MDS'),'MDS',1,'MPS',2,'FORECAST',6,
2170: 'SUPPLY FORECAST',2,'DEMAND_FORECAST',6,1)
2171: INTO p_schid
2172: FROM dual;
2173: EXCEPTION
2174: WHEN others THEN
2175: p_schid := -1;
2176: END retn_schedule_id;

Line 2770: ||' FROM dual';

2766: BEGIN
2767:
2768: lv_sql_stmt:=
2769: 'SELECT DECODE(SUBSTR(UPPER(NVL(:p_yes_no_code,''N'')),1,1),''Y'',1,2)'
2770: ||' FROM dual';
2771:
2772: OPEN c_cur FOR lv_sql_stmt
2773: USING p_yes_no_code;
2774: FETCH c_cur INTO p_yes_no_value;

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

3687: select decode(upper(x),'TOTAL_BACKLOG','MSD_TOTAL_BACKLOG','PASTDUE_BACKLOG','MSD_PASTDUE_BACKLOG'
3688: ,'PRODUCTION_PLAN','MSD_PRODUCTION_PLAN','ACTUAL_PRODUCTION','MSD_ACTUAL_PRODUCTION','ONHAND_INVENTORY','MSD_ONHAND_INVENTORY'
3689: ,'SUPPLY_PLANS','MSD_SUPPLY_PLANS','CONSTRAINED_FORECAST','MSD_CONSTRAINED_FORECAST','SAFETY_STOCKS','MSD_SAFETY_STOCKS'
3690: ,'AVAIL_RESOURCE_CAPACITY','MSD_AVAIL_RESOURCE_CAPACITY','AVAIL_SUPPLIER_CAPACITY','MSD_AVAIL_SUPPLIER_CAPACITY'
3691: ,'WORK_IN_PROCESS','MSD_WORK_IN_PROCESS',x) into stream_name from dual;
3692:
3693: return stream_name;
3694: end get_stream_name;
3695: