eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSD_DEM_UPLOAD_FORECAST dependencies on FND_GLOBAL

Line 1185: ' FND_GLOBAL.USER_ID, ' ||

1181: x_select_clause := x_select_clause || ' exp.spf_glob_prop, ';
1182: END IF;
1183:
1184: x_select_clause := x_select_clause || ' sysdate, ' ||
1185: ' FND_GLOBAL.USER_ID, ' ||
1186: ' FND_GLOBAL.LOGIN_ID ';
1187:
1188: /* BUILD WHERE CLAUSE */
1189: IF (x_is_global_fcst = 2)

Line 1186: ' FND_GLOBAL.LOGIN_ID ';

1182: END IF;
1183:
1184: x_select_clause := x_select_clause || ' sysdate, ' ||
1185: ' FND_GLOBAL.USER_ID, ' ||
1186: ' FND_GLOBAL.LOGIN_ID ';
1187:
1188: /* BUILD WHERE CLAUSE */
1189: IF (x_is_global_fcst = 2)
1190: THEN

Line 1502: FND_GLOBAL.USER_ID,

1498: null,
1499: null,
1500: null,
1501: sysdate,
1502: FND_GLOBAL.USER_ID,
1503: FND_GLOBAL.LOGIN_ID
1504: FROM (SELECT
1505: sr_instance_id,
1506: pf_name,

Line 1503: FND_GLOBAL.LOGIN_ID

1499: null,
1500: null,
1501: sysdate,
1502: FND_GLOBAL.USER_ID,
1503: FND_GLOBAL.LOGIN_ID
1504: FROM (SELECT
1505: sr_instance_id,
1506: pf_name,
1507: sr_organization_id,

Line 1584: FND_GLOBAL.USER_ID,

1580: null,
1581: null,
1582: null,
1583: sysdate,
1584: FND_GLOBAL.USER_ID,
1585: FND_GLOBAL.LOGIN_ID
1586: FROM (SELECT
1587: sr_instance_id,
1588: pf_name,

Line 1585: FND_GLOBAL.LOGIN_ID

1581: null,
1582: null,
1583: sysdate,
1584: FND_GLOBAL.USER_ID,
1585: FND_GLOBAL.LOGIN_ID
1586: FROM (SELECT
1587: sr_instance_id,
1588: pf_name,
1589: sr_organization_id,

Line 1648: FND_GLOBAL.USER_ID, systimestamp, systimestamp, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID

1644: CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN )
1645: SELECT
1646: -1, x_scenario_id, exp.inventory_item_id, exp.sr_organization_id, exp.sr_instance_id,
1647: avg(exp.mape_in_sample), avg(exp.mape_out_sample), avg(exp.forecast_volatility), avg(exp.avg_demand),
1648: FND_GLOBAL.USER_ID, systimestamp, systimestamp, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID
1649: FROM msd_dp_scn_entries_denorm exp
1650: WHERE exp.scenario_id = x_scenario_id
1651: GROUP BY exp.inventory_item_id, exp.sr_organization_id, exp.sr_instance_id;
1652:

Line 2018: ' FND_GLOBAL.USER_ID, ' ||

2014: x_select_clause := x_select_clause || x_pctg_column || ' , ';
2015: x_select_clause := x_select_clause || '1, ';
2016:
2017: x_select_clause := x_select_clause || ' sysdate, ' ||
2018: ' FND_GLOBAL.USER_ID, ' ||
2019: ' FND_GLOBAL.LOGIN_ID ';
2020:
2021: /* BUILD WHERE CLAUSE */
2022: IF (x_is_global_fcst = 2)

Line 2019: ' FND_GLOBAL.LOGIN_ID ';

2015: x_select_clause := x_select_clause || '1, ';
2016:
2017: x_select_clause := x_select_clause || ' sysdate, ' ||
2018: ' FND_GLOBAL.USER_ID, ' ||
2019: ' FND_GLOBAL.LOGIN_ID ';
2020:
2021: /* BUILD WHERE CLAUSE */
2022: IF (x_is_global_fcst = 2)
2023: THEN

Line 2913: ':3,:4, 1, sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID ';

2909: 'MSD_DP_PLANNING_PERCENTAGES_S.nextval, ' ||
2910: 'mbc.component_sequence_id, ' ||
2911: 'mb.bill_sequence_id, ' ||
2912: 'pitem.inventory_item_id, ' ||
2913: ':3,:4, 1, sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID ';
2914: x_from_clause := 'FROM msc_system_items msi, ' ||
2915: case when x_is_global_fcst = 2 then ' msc_trading_partners mtp_org, ' end ||
2916: ' msc_system_items pitem, msc_boms mb, msc_bom_components mbc, msc_apps_instances mai ';
2917:

Line 3373: x_fnd_user_id number := FND_GLOBAL.USER_ID();

3369:
3370: x_sql VARCHAR2(2000) := NULL;
3371: x_table_name VARCHAR2(50) := NULL;
3372: x_schema VARCHAR(50) := NULL;
3373: x_fnd_user_id number := FND_GLOBAL.USER_ID();
3374:
3375: x_metrics_profile_id NUMBER := NULL;
3376: x_final_forecast_profile_id NUMBER := NULL;
3377: x_dp_metrics_appid VARCHAR2(50) := NULL;

Line 3519: || ' FND_GLOBAL.LOGIN_ID ' ;

3515: || x_fnd_user_id || ', '
3516: || ' SYSTIMESTAMP, '
3517: || ' SYSTIMESTAMP, '
3518: || x_fnd_user_id || ', '
3519: || ' FND_GLOBAL.LOGIN_ID ' ;
3520:
3521:
3522: x_from_clause := ' FROM ( SELECT '
3523: || ' msi.inventory_item_id inventory_item_id, '

Line 3652: x_fnd_user_id NUMBER := FND_GLOBAL.USER_ID();

3648: x_table_name VARCHAR2(50) := NULL;
3649: x_schema VARCHAR2(50) := NULL;
3650: x_fcst_start_date VARCHAR2(50) := null;
3651: x_fcst_last_date VARCHAR2(50) := null;
3652: x_fnd_user_id NUMBER := FND_GLOBAL.USER_ID();
3653: x_fnd_login_id NUMBER := FND_GLOBAL.LOGIN_ID();
3654:
3655:
3656: x_dp_metrics_appid VARCHAR2(50) := NULL;

Line 3653: x_fnd_login_id NUMBER := FND_GLOBAL.LOGIN_ID();

3649: x_schema VARCHAR2(50) := NULL;
3650: x_fcst_start_date VARCHAR2(50) := null;
3651: x_fcst_last_date VARCHAR2(50) := null;
3652: x_fnd_user_id NUMBER := FND_GLOBAL.USER_ID();
3653: x_fnd_login_id NUMBER := FND_GLOBAL.LOGIN_ID();
3654:
3655:
3656: x_dp_metrics_appid VARCHAR2(50) := NULL;
3657: x_dp_final_forecast_appid VARCHAR2(50) := NULL;

Line 4515: x_fnd_user_id NUMBER := FND_GLOBAL.USER_ID();

4511: x_small_sql VARCHAR2(200);
4512: x_lvl_count NUMBER := 0;
4513: x_dem_schema VARCHAR2(100) := fnd_profile.value('MSD_DEM_SCHEMA');
4514: x_table_name VARCHAR2(100) := NULL ;
4515: x_fnd_user_id NUMBER := FND_GLOBAL.USER_ID();
4516: x_wo_item VARCHAR2(50) := MSD_DEM_COMMON_UTILITIES.GET_WORKORDER_ITEM();
4517: x_spf_master_org NUMBER := NULL;
4518: x_series_name VARCHAR2(50) := NULL ;
4519: x_count NUMBER := 0;

Line 4883: || ' fnd_global.login_id ' ;

4879: || ' systimestamp LAST_UPDATE_DATE, '
4880: || x_fnd_user_id || ' LAST_UPDATED_BY, '
4881: || ' systimestamp CREATION_DATE, '
4882: || x_fnd_user_id || ' CREATED_BY, '
4883: || ' fnd_global.login_id ' ;
4884:
4885: x_from_clause := ' FROM ' || x_dem_schema || '.' || x_view_name || ' exp, '
4886: || ' msc_system_items msi, '
4887: || ' (select meaning,lookup_code from fnd_lookup_values_vl' || var_D2S_dblink ||' where lookup_type = ''AHL_MAINTENANCE_SOURCE_TYPE'') lkup_MT '