APPS.MSD_DEM_COMMON_UTILITIES dependencies on DUAL

Line 1172: from dual;

1168: and language = 'US';
1169:
1170: cursor get_schema_name is
1171: select fnd_profile.value('MSD_DEM_SCHEMA')
1172: from dual;
1173:
1174: CURSOR c_is_mdp_matrix_present (p_schema_name VARCHAR2)
1175: IS
1176: SELECT table_name

Line 2429: dual';

2425: ,1 C_PRED
2426: ,1 ACTUAL_ON_HAND
2427: ,1 EBS_BH_BOOK_QTY_RD
2428: from '||x_dem_schema||'.inputs,
2429: dual';
2430: x_syn_base := x_dem_schema||'.BIEO_OBI_MV';
2431: EXECUTE IMMEDIATE x_create_view_sql;
2432:
2433:

Line 2468: FROM '||x_dem_schema||'.BIEO_OBI_MV,DUAL';

2464: ,NULL FCST_HYP_FINANCIAL
2465: ,NULL C_PRED
2466: ,NULL ACTUAL_ON_HAND
2467: ,NULL EBS_BH_BOOK_QTY_RD
2468: FROM '||x_dem_schema||'.BIEO_OBI_MV,DUAL';
2469: EXECUTE IMMEDIATE x_create_view_sql;
2470: x_syn_base := 'MSD_DEM_BIEO_OBI_MV_V';
2471: ELSIF (x_dmtra_version >= 7.3) THEN
2472: x_create_view_sql:= 'CREATE OR REPLACE VIEW MSD_DEM_BIEO_OBI_MV_V AS

Line 2503: FROM '||x_dem_schema||'.BIEO_OBI_MV,DUAL';

2499: ,FCST_HYP_FINANCIAL
2500: ,C_PRED
2501: ,ACTUAL_ON_HAND
2502: ,EBS_BH_BOOK_QTY_RD
2503: FROM '||x_dem_schema||'.BIEO_OBI_MV,DUAL';
2504: EXECUTE IMMEDIATE x_create_view_sql;
2505: x_syn_base := 'MSD_DEM_BIEO_OBI_MV_V';
2506: END IF;
2507:

Line 3056: l_sql := 'SELECT utl_http.request('''||l_url||'/WorkflowServer?action=run_proc&user='||l_user_name||'&password='||l_password||'&schema='|| replace(l_schema_name, ' ', '%20') ||'&sync=no'') FROM dual';

3052: THEN
3053: l_url := fnd_profile.value('MSD_DEM_HOST_URL');
3054: l_schema_name := trim(msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID', p_workflow_lookup_code, 1, 'schema_name'));
3055: l_sql := null;
3056: l_sql := 'SELECT utl_http.request('''||l_url||'/WorkflowServer?action=run_proc&user='||l_user_name||'&password='||l_password||'&schema='|| replace(l_schema_name, ' ', '%20') ||'&sync=no'') FROM dual';
3057:
3058: msd_dem_common_utilities.log_message('Launching Demantra workflow - ' || l_schema_name);
3059: msd_dem_common_utilities.log_debug ( ' ');
3060: msd_dem_common_utilities.log_debug('Workflow Calling sql - ');