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_CL_PULL

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 13: MSC_CL_PULL.v_table_name:= 'MSC_ST_EAM_ACT_ASSOCIATIONS';

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:
16: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
17: v_sql_stmt:= ' INSERT INTO MSC_ST_EAM_ACT_ASSOCIATIONS'

Line 14: MSC_CL_PULL.v_view_name := 'MRP_AD_EAM_ACT_ASSOC_V';

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:
16: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
17: v_sql_stmt:= ' INSERT INTO MSC_ST_EAM_ACT_ASSOCIATIONS'
18: ||'(ASSET_ACTIVITY_ID,'

Line 16: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

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:
16: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
17: v_sql_stmt:= ' INSERT INTO MSC_ST_EAM_ACT_ASSOCIATIONS'
18: ||'(ASSET_ACTIVITY_ID,'
19: ||'ORGANIZATION_ID,'
20: ||'ASSET_REBUILD_ITEM_ID,'

Line 32: ||MSC_CL_PULL.V_DBLINK||' x'

28: ||'1,'
29: ||':v_refresh_id,'
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);

Line 33: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn

29: ||':v_refresh_id,'
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,

Line 37: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

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;
41:

Line 38: MSC_CL_PULL.v_instance_id;

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;
41:
42:

Line 43: MSC_CL_PULL.v_table_name:= 'MSC_ST_EAM_ACT_ASSOCIATIONS';

39: COMMIT;
40: END IF;
41:
42:
43: MSC_CL_PULL.v_table_name:= 'MSC_ST_EAM_ACT_ASSOCIATIONS';
44: MSC_CL_PULL.v_view_name := 'MRP_AP_EAM_ACT_ASSOC_V';
45:
46: v_sql_stmt:= ' INSERT INTO MSC_ST_EAM_ACT_ASSOCIATIONS'
47: ||'(ASSET_ACTIVITY_ID,'

Line 44: MSC_CL_PULL.v_view_name := 'MRP_AP_EAM_ACT_ASSOC_V';

40: END IF;
41:
42:
43: MSC_CL_PULL.v_table_name:= 'MSC_ST_EAM_ACT_ASSOCIATIONS';
44: MSC_CL_PULL.v_view_name := 'MRP_AP_EAM_ACT_ASSOC_V';
45:
46: v_sql_stmt:= ' INSERT INTO MSC_ST_EAM_ACT_ASSOCIATIONS'
47: ||'(ASSET_ACTIVITY_ID,'
48: ||'ORGANIZATION_ID,'

Line 69: ||MSC_CL_PULL.V_DBLINK||' x'

65: ||'2,'
66: ||':v_refresh_id,'
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:

Line 70: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn

66: ||':v_refresh_id,'
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,

Line 74: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

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:
77: /*--------- PS requirements - New table to collect asset number details ---------*/
78:

Line 75: MSC_CL_PULL.v_instance_id;

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:
77: /*--------- PS requirements - New table to collect asset number details ---------*/
78:
79: MSC_CL_PULL.v_table_name:= 'MSC_ST_EAM_ASSET_EQUIP_DTLS';

Line 79: MSC_CL_PULL.v_table_name:= 'MSC_ST_EAM_ASSET_EQUIP_DTLS';

75: MSC_CL_PULL.v_instance_id;
76:
77: /*--------- PS requirements - New table to collect asset number details ---------*/
78:
79: MSC_CL_PULL.v_table_name:= 'MSC_ST_EAM_ASSET_EQUIP_DTLS';
80: MSC_CL_PULL.v_view_name := 'MRP_AD_EAM_ASSET_EQUIP_V';
81:
82: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
83: v_sql_stmt:= ' INSERT INTO MSC_ST_EAM_ASSET_EQUIP_DTLS'

Line 80: MSC_CL_PULL.v_view_name := 'MRP_AD_EAM_ASSET_EQUIP_V';

76:
77: /*--------- PS requirements - New table to collect asset number details ---------*/
78:
79: MSC_CL_PULL.v_table_name:= 'MSC_ST_EAM_ASSET_EQUIP_DTLS';
80: MSC_CL_PULL.v_view_name := 'MRP_AD_EAM_ASSET_EQUIP_V';
81:
82: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
83: v_sql_stmt:= ' INSERT INTO MSC_ST_EAM_ASSET_EQUIP_DTLS'
84: ||'(ASSET_GROUP_ITEM_ID,'

Line 82: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

78:
79: MSC_CL_PULL.v_table_name:= 'MSC_ST_EAM_ASSET_EQUIP_DTLS';
80: MSC_CL_PULL.v_view_name := 'MRP_AD_EAM_ASSET_EQUIP_V';
81:
82: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
83: v_sql_stmt:= ' INSERT INTO MSC_ST_EAM_ASSET_EQUIP_DTLS'
84: ||'(ASSET_GROUP_ITEM_ID,'
85: ||'ORGANIZATION_ID,'
86: ||'ASSET_ACTIVITY_ID,'

Line 102: ||MSC_CL_PULL.V_DBLINK||' x'

98: ||'1,'
99: ||':v_refresh_id,'
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);

Line 103: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn

99: ||':v_refresh_id,'
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,

Line 107: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

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;
111:

Line 108: MSC_CL_PULL.v_instance_id;

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;
111:
112:

Line 113: MSC_CL_PULL.v_table_name:= 'MSC_ST_EAM_ASSET_EQUIP_DTLS';

109: COMMIT;
110: END IF;
111:
112:
113: MSC_CL_PULL.v_table_name:= 'MSC_ST_EAM_ASSET_EQUIP_DTLS';
114: MSC_CL_PULL.v_view_name := 'MRP_AP_EAM_ASSET_EQUIP_V';
115:
116: v_sql_stmt:= ' INSERT INTO MSC_ST_EAM_ASSET_EQUIP_DTLS'
117: ||'(ASSET_GROUP_ITEM_ID,'

Line 114: MSC_CL_PULL.v_view_name := 'MRP_AP_EAM_ASSET_EQUIP_V';

110: END IF;
111:
112:
113: MSC_CL_PULL.v_table_name:= 'MSC_ST_EAM_ASSET_EQUIP_DTLS';
114: MSC_CL_PULL.v_view_name := 'MRP_AP_EAM_ASSET_EQUIP_V';
115:
116: v_sql_stmt:= ' INSERT INTO MSC_ST_EAM_ASSET_EQUIP_DTLS'
117: ||'(ASSET_GROUP_ITEM_ID,'
118: ||'ORGANIZATION_ID,'

Line 147: ||MSC_CL_PULL.V_DBLINK||' x,'

143: ||'2,'
144: ||':v_refresh_id,'
145: ||':v_instance_id'
146: ||' FROM MRP_AP_EAM_ASSET_EQUIP_V'
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

Line 149: ||MSC_CL_PULL.V_DBLINK||' y'

145: ||':v_instance_id'
146: ||' FROM MRP_AP_EAM_ASSET_EQUIP_V'
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 (+)'

Line 150: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn

146: ||' FROM MRP_AP_EAM_ASSET_EQUIP_V'
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 (+)';

Line 158: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

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;
161: COMMIT;
162: END LOAD_EAM_INFO;

Line 159: MSC_CL_PULL.v_instance_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;
161: COMMIT;
162: END LOAD_EAM_INFO;
163:

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 182: MSC_CL_PULL.v_table_name:= 'MSC_ST_DESIGNATORS';

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';
184:
185: v_sql_stmt:= ' INSERT INTO MSC_ST_DESIGNATORS'
186: ||'(SRC_SIM_FCST_ID,'

Line 183: MSC_CL_PULL.V_VIEW_NAME := 'MRP_AP_EAM_FORECAST_DESIGS_V';

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';
184:
185: v_sql_stmt:= ' INSERT INTO MSC_ST_DESIGNATORS'
186: ||'(SRC_SIM_FCST_ID,'
187: ||'ORGANIZATION_ID,'

Line 210: ||MSC_CL_PULL.V_DBLINK||' x'

206: ||'2,'
207: ||':v_refresh_id,'
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);

Line 211: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn

207: ||':v_refresh_id,'
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:

Line 216: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

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:
219: COMMIT;
220:

Line 217: MSC_CL_PULL.v_instance_id ;

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:
219: COMMIT;
220:
221:

Line 222: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';

218:
219: COMMIT;
220:
221:
222: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
223: MSC_CL_PULL.v_view_name := 'MRP_AP_EAM_FORECASTS_V';
224:
225: v_sql_stmt:= 'Insert into MSC_ST_SUPPLIES'
226: ||'( INVENTORY_ITEM_ID,'

Line 223: MSC_CL_PULL.v_view_name := 'MRP_AP_EAM_FORECASTS_V';

219: COMMIT;
220:
221:
222: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
223: MSC_CL_PULL.v_view_name := 'MRP_AP_EAM_FORECASTS_V';
224:
225: v_sql_stmt:= 'Insert into MSC_ST_SUPPLIES'
226: ||'( INVENTORY_ITEM_ID,'
227: ||'ORGANIZATION_ID,'

Line 264: ||MSC_CL_PULL.v_dblink||' x'

260: ||'x.ASSET_ITEM_ID,'
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 ;

Line 268: -- ||' AND x.RN1 > '||MSC_CL_PULL.v_lrn ;

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);
270: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt ' ||v_sql_stmt);
271:
272: EXECUTE IMMEDIATE v_sql_stmt

Line 273: USING MSC_CL_PULL.v_refresh_id,

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,
275: lv_eam_fc_st_date,
276: lv_eam_fc_end_date;
277:

Line 274: MSC_CL_PULL.v_instance_id,

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,
275: lv_eam_fc_st_date,
276: lv_eam_fc_end_date;
277:
278: COMMIT;

Line 281: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';

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 ( '
285: ||'SCHEDULE_DESIGNATOR_ID,'

Line 282: MSC_CL_PULL.v_view_name := 'MRP_AP_EAM_FC_MATREQ_V';

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 ( '
285: ||'SCHEDULE_DESIGNATOR_ID,'
286: ||'ORGANIZATION_ID,'

Line 314: ||' FROM MRP_AP_EAM_FC_MATREQ_V'||MSC_CL_PULL.v_dblink||' x'

310: ||'x.CLASS_CODE,'
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

Line 318: -- ||' AND (x.RN1 >'||MSC_CL_PULL.v_lrn

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||')'
320: ;
321:
322: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for eam forecast demands :' ||v_sql_stmt);

Line 319: -- ||' AND x.RN2 >'||MSC_CL_PULL.v_lrn||')'

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||')'
320: ;
321:
322: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for eam forecast demands :' ||v_sql_stmt);
323:

Line 325: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

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;
329: COMMIT;

Line 326: MSC_CL_PULL.v_instance_id

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;
329: COMMIT;
330:

Line 332: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_REQUIREMENTS';

328: ,lv_eam_fc_end_date;
329: COMMIT;
330:
331:
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

Line 333: MSC_CL_PULL.v_view_name := 'MRP_AP_EAM_FC_RESREQ_V';

329: COMMIT;
330:
331:
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:

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 393: ||' FROM MRP_AP_EAM_FC_RESREQ_V'||MSC_CL_PULL.v_dblink||' x'

389: ||'x. MAINTENANCE_OBJECT_SOURCE,'
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

Line 403: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

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;
407:

Line 404: MSC_CL_PULL.v_instance_id

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;
407:
408: COMMIT;