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.MSC_CL_EAM_PULL dependencies on MSC_UTIL

Line 10: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN

6:
7: PROCEDURE LOAD_EAM_INFO IS
8: BEGIN
9:
10: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
11: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_EAM_INFO ');
12:
13: MSC_CL_PULL.v_table_name:= 'MSC_ST_EAM_ACT_ASSOCIATIONS';
14: MSC_CL_PULL.v_view_name := 'MRP_AD_EAM_ACT_ASSOC_V';

Line 11: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_EAM_INFO ');

7: PROCEDURE LOAD_EAM_INFO IS
8: BEGIN
9:
10: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
11: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_EAM_INFO ');
12:
13: MSC_CL_PULL.v_table_name:= 'MSC_ST_EAM_ACT_ASSOCIATIONS';
14: MSC_CL_PULL.v_view_name := 'MRP_AD_EAM_ACT_ASSOC_V';
15:

Line 34: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

30: ||':v_instance_id'
31: ||' FROM MRP_AD_EAM_ACT_ASSOC_V'
32: ||MSC_CL_PULL.V_DBLINK||' x'
33: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
34: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
35:
36: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'EAM info. --lv_sql_stmt' ||v_sql_stmt);
37: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
38: MSC_CL_PULL.v_instance_id;

Line 36: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'EAM info. --lv_sql_stmt' ||v_sql_stmt);

32: ||MSC_CL_PULL.V_DBLINK||' x'
33: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
34: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
35:
36: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'EAM info. --lv_sql_stmt' ||v_sql_stmt);
37: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
38: MSC_CL_PULL.v_instance_id;
39: COMMIT;
40: END IF;

Line 71: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

67: ||':v_instance_id'
68: ||' FROM MRP_AP_EAM_ACT_ASSOC_V'
69: ||MSC_CL_PULL.V_DBLINK||' x'
70: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
71: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
72: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'EAM info. --lv_sql_stmt' ||v_sql_stmt);
73:
74: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
75: MSC_CL_PULL.v_instance_id;

Line 72: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'EAM info. --lv_sql_stmt' ||v_sql_stmt);

68: ||' FROM MRP_AP_EAM_ACT_ASSOC_V'
69: ||MSC_CL_PULL.V_DBLINK||' x'
70: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
71: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
72: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'EAM info. --lv_sql_stmt' ||v_sql_stmt);
73:
74: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
75: MSC_CL_PULL.v_instance_id;
76:

Line 104: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

100: ||':v_instance_id'
101: ||' FROM MRP_AD_EAM_ASSET_EQUIP_V'
102: ||MSC_CL_PULL.V_DBLINK||' x'
103: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
104: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
105:
106: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'EAM asset info. --lv_sql_stmt' ||v_sql_stmt);
107: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
108: MSC_CL_PULL.v_instance_id;

Line 106: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'EAM asset info. --lv_sql_stmt' ||v_sql_stmt);

102: ||MSC_CL_PULL.V_DBLINK||' x'
103: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
104: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
105:
106: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'EAM asset info. --lv_sql_stmt' ||v_sql_stmt);
107: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
108: MSC_CL_PULL.v_instance_id;
109: COMMIT;
110: END IF;

Line 151: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str

147: ||MSC_CL_PULL.V_DBLINK||' x,'
148: ||' MTL_EAM_EQUIP_RESOURCES_V'
149: ||MSC_CL_PULL.V_DBLINK||' y'
150: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
151: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
152: ||' AND x.ORGANIZATION_ID = y.ORGANIZATION_ID (+)'
153: ||' AND x.EQUIPMENT_SERIAL_NUMBER = y.SERIAL_NUMBER (+)'
154: ||' AND x.EQUIPMENT_ITEM_ID = y.INVENTORY_ITEM_ID (+)';
155:

Line 156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'EAM asset info. --lv_sql_stmt' ||v_sql_stmt);

152: ||' AND x.ORGANIZATION_ID = y.ORGANIZATION_ID (+)'
153: ||' AND x.EQUIPMENT_SERIAL_NUMBER = y.SERIAL_NUMBER (+)'
154: ||' AND x.EQUIPMENT_ITEM_ID = y.INVENTORY_ITEM_ID (+)';
155:
156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'EAM asset info. --lv_sql_stmt' ||v_sql_stmt);
157:
158: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
159: MSC_CL_PULL.v_instance_id;
160: END IF;

Line 178: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_EAM_FORECASTS ');

174:
175: lv_eam_fc_st_date := eam_fc_st_date;
176: lv_eam_fc_end_date := eam_fc_end_date ;
177:
178: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_EAM_FORECASTS ');
179: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
180:
181:
182: MSC_CL_PULL.v_table_name:= 'MSC_ST_DESIGNATORS';

Line 179: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN

175: lv_eam_fc_st_date := eam_fc_st_date;
176: lv_eam_fc_end_date := eam_fc_end_date ;
177:
178: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_EAM_FORECASTS ');
179: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
180:
181:
182: MSC_CL_PULL.v_table_name:= 'MSC_ST_DESIGNATORS';
183: MSC_CL_PULL.V_VIEW_NAME := 'MRP_AP_EAM_FORECAST_DESIGS_V';

Line 212: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

208: ||':v_instance_id'
209: ||' FROM MRP_AP_EAM_FORECAST_DESIGS_V'
210: ||MSC_CL_PULL.V_DBLINK||' x'
211: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
212: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
213:
214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt' ||v_sql_stmt);
215:
216: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

Line 214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt' ||v_sql_stmt);

210: ||MSC_CL_PULL.V_DBLINK||' x'
211: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
212: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
213:
214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt' ||v_sql_stmt);
215:
216: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
217: MSC_CL_PULL.v_instance_id ;
218:

Line 265: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

261: ||' :v_refresh_id,'
262: ||' :v_instance_id'
263: ||' from MRP_AP_EAM_FORECASTS_V '
264: ||MSC_CL_PULL.v_dblink||' x'
265: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
266: ||' and x.SCHEDULED_COMPLETION_DATE >= :lv_eam_fc_st_date'
267: ||' and x.SCHEDULED_COMPLETION_DATE <= :lv_eam_fc_end_date';
268: -- ||' AND x.RN1 > '||MSC_CL_PULL.v_lrn ;
269: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt ' ||v_sql_stmt);

Line 269: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt ' ||v_sql_stmt);

265: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
266: ||' and x.SCHEDULED_COMPLETION_DATE >= :lv_eam_fc_st_date'
267: ||' and x.SCHEDULED_COMPLETION_DATE <= :lv_eam_fc_end_date';
268: -- ||' AND x.RN1 > '||MSC_CL_PULL.v_lrn ;
269: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt ' ||v_sql_stmt);
270: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt ' ||v_sql_stmt);
271:
272: EXECUTE IMMEDIATE v_sql_stmt
273: USING MSC_CL_PULL.v_refresh_id,

Line 270: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt ' ||v_sql_stmt);

266: ||' and x.SCHEDULED_COMPLETION_DATE >= :lv_eam_fc_st_date'
267: ||' and x.SCHEDULED_COMPLETION_DATE <= :lv_eam_fc_end_date';
268: -- ||' AND x.RN1 > '||MSC_CL_PULL.v_lrn ;
269: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt ' ||v_sql_stmt);
270: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt ' ||v_sql_stmt);
271:
272: EXECUTE IMMEDIATE v_sql_stmt
273: USING MSC_CL_PULL.v_refresh_id,
274: MSC_CL_PULL.v_instance_id,

Line 280: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for eam forecast :' ||v_sql_stmt);

276: lv_eam_fc_end_date;
277:
278: COMMIT;
279:
280: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for eam forecast :' ||v_sql_stmt);
281: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
282: MSC_CL_PULL.v_view_name := 'MRP_AP_EAM_FC_MATREQ_V';
283:
284: v_sql_stmt:= ' INSERT INTO MSC_ST_DEMANDS ( '

Line 315: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str

311: ||'x. MAINTENANCE_OBJECT_SOURCE,'
312: ||':v_refresh_id,'
313: ||':v_instance_id'
314: ||' FROM MRP_AP_EAM_FC_MATREQ_V'||MSC_CL_PULL.v_dblink||' x'
315: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
316: ||' AND x.USING_ASSEMBLY_DEMAND_DATE >= :lv_eam_fc_st_date '
317: ||' AND x.USING_ASSEMBLY_DEMAND_DATE <= :lv_eam_fc_end_date '
318: -- ||' AND (x.RN1 >'||MSC_CL_PULL.v_lrn
319: -- ||' AND x.RN2 >'||MSC_CL_PULL.v_lrn||')'

Line 322: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for eam forecast demands :' ||v_sql_stmt);

318: -- ||' AND (x.RN1 >'||MSC_CL_PULL.v_lrn
319: -- ||' AND x.RN2 >'||MSC_CL_PULL.v_lrn||')'
320: ;
321:
322: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for eam forecast demands :' ||v_sql_stmt);
323:
324: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'SQL statement is '||v_sql_stmt||'-'||lv_eam_fc_st_date||'-'||lv_eam_fc_end_date);
325: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
326: MSC_CL_PULL.v_instance_id

Line 324: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'SQL statement is '||v_sql_stmt||'-'||lv_eam_fc_st_date||'-'||lv_eam_fc_end_date);

320: ;
321:
322: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for eam forecast demands :' ||v_sql_stmt);
323:
324: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'SQL statement is '||v_sql_stmt||'-'||lv_eam_fc_st_date||'-'||lv_eam_fc_end_date);
325: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
326: MSC_CL_PULL.v_instance_id
327: ,lv_eam_fc_st_date
328: ,lv_eam_fc_end_date;

Line 336: IF MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES THEN

332: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_REQUIREMENTS';
333: MSC_CL_PULL.v_view_name := 'MRP_AP_EAM_FC_RESREQ_V';
334:
335: /* check for inflation and add code here if it is in pull code*/
336: IF MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES THEN
337:
338: IF (nvl(fnd_profile.value('MSC_INFLATE_WIP') ,'N')= 'N') THEN
339: lv_inflate_wip := 2 ;
340: ELSE

Line 346: IF lv_inflate_wip = 1 AND MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN

342: END IF;
343: /* check for inflation and add code here if it is in pull code*/
344: -- if the profile MSC_INFLATE_WIP is set to YES then inflating the operation resource hours
345: -- and touch time by efficiency and utilization.
346: IF lv_inflate_wip = 1 AND MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
347: v_temp_sql := ' (x.TOTAL_QUANTITY *(1/x.utilization)*(1/x.efficiency)) OPERATION_HOURS_REQUIRED,'||
348: ' (x.TOTAL_QUANTITY * (1/x.efficiency)) TOUCH_TIME,';
349: v_temp_whr := ' AND (x.ENTITY_TYPE <>5 or ((x.TOTAL_QUANTITY * (1/x.utilization)* (1/x.efficiency)) - x.HOURS_EXPENDED) >0) ';
350: ELSE

Line 394: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str

390: ||'x.supply_type,'
391: ||':v_refresh_id,'
392: ||':v_instance_id'
393: ||' FROM MRP_AP_EAM_FC_RESREQ_V'||MSC_CL_PULL.v_dblink||' x'
394: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
395: ||' AND x.START_DATE >= :lv_eam_fc_st_date '
396: ||' AND x.START_DATE <= :lv_eam_fc_end_date '
397: || v_temp_whr
398: ;

Line 400: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for eam forecast resource :' ||v_sql_stmt);

396: ||' AND x.START_DATE <= :lv_eam_fc_end_date '
397: || v_temp_whr
398: ;
399:
400: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for eam forecast resource :' ||v_sql_stmt);
401:
402: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'SQL statement is '||v_sql_stmt||'-'||lv_eam_fc_st_date||'-'||lv_eam_fc_end_date);
403: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
404: MSC_CL_PULL.v_instance_id

Line 402: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'SQL statement is '||v_sql_stmt||'-'||lv_eam_fc_st_date||'-'||lv_eam_fc_end_date);

398: ;
399:
400: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for eam forecast resource :' ||v_sql_stmt);
401:
402: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'SQL statement is '||v_sql_stmt||'-'||lv_eam_fc_st_date||'-'||lv_eam_fc_end_date);
403: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
404: MSC_CL_PULL.v_instance_id
405: ,lv_eam_fc_st_date
406: ,lv_eam_fc_end_date;

Line 411: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */

407:
408: COMMIT;
409:
410:
411: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
412:
413: END LOAD_EAM_FORECASTS;
414:
415: