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_AHL_PULL dependencies on MSC_UTIL

Line 8: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS ');

4: v_union_sql VARCHAR2(32767);
5: PROCEDURE LOAD_VISITS IS
6: BEGIN
7:
8: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS ');
9:
10: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
11: MSC_CL_PULL.v_table_name:= 'MSC_ST_VISITS';
12: MSC_CL_PULL.v_view_name := 'MRP_AD_AHL_VISITS_V';

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

6: BEGIN
7:
8: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS ');
9:
10: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
11: MSC_CL_PULL.v_table_name:= 'MSC_ST_VISITS';
12: MSC_CL_PULL.v_view_name := 'MRP_AD_AHL_VISITS_V';
13: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS in IF1');
14:

Line 13: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS in IF1');

9:
10: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
11: MSC_CL_PULL.v_table_name:= 'MSC_ST_VISITS';
12: MSC_CL_PULL.v_view_name := 'MRP_AD_AHL_VISITS_V';
13: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS in IF1');
14:
15: -- insert into MSC_ST_VISITS from MRP_AD_AHL_VISITS_V
16: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
17: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS in v_lrnn'||MSC_CL_PULL.v_lrnn);

Line 17: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS in v_lrnn'||MSC_CL_PULL.v_lrnn);

13: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS in IF1');
14:
15: -- insert into MSC_ST_VISITS from MRP_AD_AHL_VISITS_V
16: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
17: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS in v_lrnn'||MSC_CL_PULL.v_lrnn);
18:
19: v_sql_stmt:= ' INSERT INTO MSC_ST_VISITS'
20: ||'(VISIT_ID,'
21: ||'ORGANIZATION_ID,'

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

30: ||':v_instance_id'
31: ||' FROM MRP_AD_AHL_VISITS_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: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
37: MSC_CL_PULL.v_instance_id;
38: COMMIT;

Line 75: ||MSC_UTIL.v_in_org_str;

71: ||' :v_instance_id'
72: ||' FROM MRP_AP_VISITS_V'||MSC_CL_PULL.v_dblink||' x'
73: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
74: ||' AND x.ORGANIZATION_ID '
75: ||MSC_UTIL.v_in_org_str;
76:
77: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
78: MSC_CL_PULL.v_instance_id ;
79: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */

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

75: ||MSC_UTIL.v_in_org_str;
76:
77: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
78: MSC_CL_PULL.v_instance_id ;
79: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
80: END LOAD_VISITS;
81:
82: PROCEDURE LOAD_WO_ATTRIBUTES IS
83: BEGIN

Line 85: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_ATTRIBUTES ');

81:
82: PROCEDURE LOAD_WO_ATTRIBUTES IS
83: BEGIN
84:
85: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_ATTRIBUTES ');
86:
87: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
88: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_ATTRIBUTES';
89: MSC_CL_PULL.v_view_name := 'MRP_AD_WO_ATTRIBUTES_V';

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

83: BEGIN
84:
85: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_ATTRIBUTES ');
86:
87: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
88: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_ATTRIBUTES';
89: MSC_CL_PULL.v_view_name := 'MRP_AD_WO_ATTRIBUTES_V';
90:
91: -- insert into MSC_ST_WO_ATTRIBUTES from MRP_AD_WO_ATTRIBUTES_V

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

104: ||':v_instance_id'
105: ||' FROM MRP_AD_WO_ATTRIBUTES_V'
106: ||MSC_CL_PULL.V_DBLINK||' x'
107: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
108: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
109:
110: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
111: MSC_CL_PULL.v_instance_id;
112: COMMIT;

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

146: ||':v_instance_id'
147: ||' FROM MRP_AP_WO_ATTRIBUTES_V'
148: ||MSC_CL_PULL.V_DBLINK||' x'
149: ||' WHERE x.RN2> '||MSC_CL_PULL.v_lrn
150: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
151: ELSE
152: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn
153: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
154: END IF;

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

208: ||':v_refresh_id,'
209: ||':v_instance_id'
210: ||' FROM MRP_AP_WO_ATTRIBUTES_V'
211: ||MSC_CL_PULL.V_DBLINK||' x'
212: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
213: || v_union_sql ;
214:
215: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
216: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

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

219: ELSE
220: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
221: MSC_CL_PULL.v_instance_id;
222: END IF;
223: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
224:
225: END LOAD_WO_ATTRIBUTES;
226:
227: PROCEDURE LOAD_WO_TASK_HRY IS

Line 230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_TASK_HRY ');

226:
227: PROCEDURE LOAD_WO_TASK_HRY IS
228: BEGIN
229:
230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_TASK_HRY ');
231:
232: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
233: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_TASK_HIERARCHY';
234: MSC_CL_PULL.v_view_name := 'MRP_AD_WO_TASK_HIERARCHY_V';

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

228: BEGIN
229:
230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_TASK_HRY ');
231:
232: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
233: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_TASK_HIERARCHY';
234: MSC_CL_PULL.v_view_name := 'MRP_AD_WO_TASK_HIERARCHY_V';
235:
236: -- insert into MSC_ST_WO_TASK_HIERARCHY from MRP_AD_WO_TASK_HRY_V

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

249: ||':v_instance_id'
250: ||' FROM MRP_AD_WO_TASK_HIERARCHY_V'
251: ||MSC_CL_PULL.v_dblink||' x'
252: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
253: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
254:
255: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
256: MSC_CL_PULL.v_instance_id;
257: COMMIT;

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

276: ||':v_refresh_id,'
277: ||':v_instance_id'
278: ||' from MRP_AP_WO_TASK_HRY_V'||MSC_CL_PULL.V_DBLINK||' x'
279: ||' WHERE x.RN2> '||MSC_CL_PULL.v_lrn
280: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
281: ||' UNION '
282: ||' SELECT '
283: ||'x.TASK_LINK_ID,'
284: ||'x.CURRENT_WIP_ENTITY_ID,'

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

293: ||':v_refresh_id,'
294: ||':v_instance_id'
295: ||' from MRP_AP_WO_TASK_HRY_V'||MSC_CL_PULL.V_DBLINK||' x'
296: ||' WHERE x.RN3> '||MSC_CL_PULL.v_lrn
297: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
298: ELSE
299: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn
300: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
301: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';

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

327: ||'2,'
328: ||':v_refresh_id,'
329: ||':v_instance_id'
330: ||' from MRP_AP_WO_TASK_HRY_V'||MSC_CL_PULL.V_DBLINK||' x'
331: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
332: || v_union_sql ;
333:
334: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

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

341: ELSE
342: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
343: MSC_CL_PULL.v_instance_id;
344: END IF;
345: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
346:
347: END LOAD_WO_TASK_HRY;
348:
349: PROCEDURE LOAD_MILESTONES IS

Line 352: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_MILESTONES ');

348:
349: PROCEDURE LOAD_MILESTONES IS
350: BEGIN
351:
352: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_MILESTONES ');
353:
354: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
355: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_MILESTONES';
356: MSC_CL_PULL.v_view_name := 'MRP_AD_MILESTONES_V';

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

350: BEGIN
351:
352: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_MILESTONES ');
353:
354: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
355: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_MILESTONES';
356: MSC_CL_PULL.v_view_name := 'MRP_AD_MILESTONES_V';
357:
358: -- insert into MSC_ST_WO_MILESTONES from MRP_AD_MILESTONES_V

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

373: ||':v_instance_id'
374: ||' FROM MRP_AD_MILESTONES_V'
375: ||MSC_CL_PULL.v_dblink||' x'
376: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
377: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
378:
379: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
380: MSC_CL_PULL.v_instance_id;
381: COMMIT;

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

405: ||':v_refresh_id,'
406: ||':v_instance_id'
407: ||' from MRP_AP_MILESTONES_V'||MSC_CL_PULL.V_DBLINK||' x'
408: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
409: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
410:
411: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
412: MSC_CL_PULL.v_instance_id;
413: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */

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

409: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
410:
411: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
412: MSC_CL_PULL.v_instance_id;
413: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
414:
415: END LOAD_MILESTONES;
416:
417: PROCEDURE LOAD_WO_OPER_RELN IS

Line 420: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_OPER_RELN');

416:
417: PROCEDURE LOAD_WO_OPER_RELN IS
418: BEGIN
419:
420: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_OPER_RELN');
421:
422: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
423: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_OPERATION_REL';
424: MSC_CL_PULL.v_view_name := 'MRP_AD_WO_OPERATIONS_REL_V';

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

418: BEGIN
419:
420: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_OPER_RELN');
421:
422: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
423: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_OPERATION_REL';
424: MSC_CL_PULL.v_view_name := 'MRP_AD_WO_OPERATIONS_REL_V';
425:
426: -- insert into MSC_ST_WO_OPERATION_REL from MRP_AD_WO_OPERATIONS_REL_V

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

443: ||':v_instance_id'
444: ||' FROM MRP_AD_WO_OPERATIONS_REL_V'
445: ||MSC_CL_PULL.v_dblink||' x'
446: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
447: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
448:
449: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
450: MSC_CL_PULL.v_instance_id;
451: COMMIT;

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

472: ||':v_instance_id'
473: ||' from MRP_AP_WO_OPER_RELN_V'
474: ||MSC_CL_PULL.V_DBLINK||' x'
475: ||' WHERE x.RN2> '||MSC_CL_PULL.v_lrn
476: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
477: ELSE
478: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn
479: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
480: END IF;

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

508: ||':v_refresh_id,'
509: ||':v_instance_id'
510: ||' from MRP_AP_WO_OPER_RELN_V'
511: ||MSC_CL_PULL.V_DBLINK||' x'
512: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
513: || v_union_sql ;
514:
515: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
516: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

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

521: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
522: MSC_CL_PULL.v_instance_id;
523: END IF;
524:
525: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
526:
527: END LOAD_WO_OPER_RELN;
528:
529: PROCEDURE LOAD_WORK_BREAKDOWN IS

Line 532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

528:
529: PROCEDURE LOAD_WORK_BREAKDOWN IS
530: BEGIN
531:
532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
533: 'In Procedure LOAD_WORK_BREAKDOWN ');
534:
535: IF MSC_CL_PULL.V_APPS_VER >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
536:

Line 535: IF MSC_CL_PULL.V_APPS_VER >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN

531:
532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
533: 'In Procedure LOAD_WORK_BREAKDOWN ');
534:
535: IF MSC_CL_PULL.V_APPS_VER >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
536:
537: MSC_CL_PULL.v_table_name:= 'MSC_ST_WORK_BREAKDOWN_STRUCT';
538: MSC_CL_PULL.v_view_name := 'MRP_AP_WORK_BREAKDOWN_V';
539:

Line 556: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

552: ||':v_refresh_id,'
553: ||':v_instance_id'
554: ||' from MRP_AP_WORK_BREAKDOWN_V'
555: ||MSC_CL_PULL.v_dblink||' x'
556: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
557:
558: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
559: MSC_CL_PULL.v_instance_id;
560:

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

557:
558: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
559: MSC_CL_PULL.v_instance_id;
560:
561: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
562:
563: END LOAD_WORK_BREAKDOWN;
564:
565: PROCEDURE LOAD_WO_SUB_COMP IS

Line 567: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_SUB_COMP ');

563: END LOAD_WORK_BREAKDOWN;
564:
565: PROCEDURE LOAD_WO_SUB_COMP IS
566: BEGIN
567: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_SUB_COMP ');
568:
569: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
570: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_SUB_COMP';
571: MSC_CL_PULL.V_VIEW_NAME := 'MRP_AP_WO_SUB_COMP_V';

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

565: PROCEDURE LOAD_WO_SUB_COMP IS
566: BEGIN
567: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_SUB_COMP ');
568:
569: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
570: MSC_CL_PULL.v_table_name:= 'MSC_ST_WO_SUB_COMP';
571: MSC_CL_PULL.V_VIEW_NAME := 'MRP_AP_WO_SUB_COMP_V';
572:
573: v_sql_stmt:= ' INSERT INTO MSC_ST_WO_SUB_COMP'

Line 598: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

594: ||'x.REQUEST_ID,'
595: ||':v_refresh_id,'
596: ||':v_instance_id'
597: ||' FROM MRP_AP_WO_SUB_COMP_V'||MSC_CL_PULL.v_dblink||' x'
598: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
599:
600: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
601: MSC_CL_PULL.v_instance_id ;
602: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */

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

598: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
599:
600: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
601: MSC_CL_PULL.v_instance_id ;
602: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
603:
604: END LOAD_WO_SUB_COMP;
605:
606: PROCEDURE LOAD_CMRO_FORECASTS (p_eam_cmro_st_date IN DATE,

Line 614: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

610: v_temp_whr VARCHAR2(300);
611:
612: BEGIN
613:
614: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
615: 'In Procedure LOAD_CMRO_FORECASTS ');
616: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
617:
618: /*--incremental refresh is not to be supported for CMRO forecasts

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

612: BEGIN
613:
614: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
615: 'In Procedure LOAD_CMRO_FORECASTS ');
616: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
617:
618: /*--incremental refresh is not to be supported for CMRO forecasts
619:
620: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 621: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_CMRO_FORECASTS and v_lrnn= '||MSC_CL_PULL.v_lrnn);

617:
618: /*--incremental refresh is not to be supported for CMRO forecasts
619:
620: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
621: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_CMRO_FORECASTS and v_lrnn= '||MSC_CL_PULL.v_lrnn);
622:
623: v_sql_stmt:= ' INSERT INTO MSC_ST_SUPPLIES'
624: ||'(DISPOSITION_ID,'
625: ||'OBJECT_TYPE,'

Line 775: ||' WHERE x.OPERATING_ORG_ID '|| MSC_UTIL.v_in_org_str

771: ||' x.INVENTORY_ITEM_ID,'
772: ||':v_refresh_id,'
773: ||':v_instance_id'
774: ||' FROM MRP_AP_UMP_MAINT_REQMNTS_V'||MSC_CL_PULL.v_dblink||' x'
775: ||' WHERE x.OPERATING_ORG_ID '|| MSC_UTIL.v_in_org_str
776: ||' AND x.DUE_DATE >= :p_eam_cmro_st_date '
777: ||' AND x.DUE_DATE <= :p_eam_cmro_end_date '
778: -- ||' AND x.RN > '||MSC_CL_PULL.v_lrn
779: ;

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

778: -- ||' AND x.RN > '||MSC_CL_PULL.v_lrn
779: ;
780:
781:
782: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for cmro forecast :' ||v_sql_stmt);
783: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'SQL statement is '||v_sql_stmt||'-'||p_eam_cmro_st_date||'-'||p_eam_cmro_end_date);
784:
785: EXECUTE IMMEDIATE v_sql_stmt USING
786: MSC_CL_PULL.v_refresh_id,

Line 783: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'SQL statement is '||v_sql_stmt||'-'||p_eam_cmro_st_date||'-'||p_eam_cmro_end_date);

779: ;
780:
781:
782: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for cmro forecast :' ||v_sql_stmt);
783: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'SQL statement is '||v_sql_stmt||'-'||p_eam_cmro_st_date||'-'||p_eam_cmro_end_date);
784:
785: EXECUTE IMMEDIATE v_sql_stmt USING
786: MSC_CL_PULL.v_refresh_id,
787: MSC_CL_PULL.v_instance_id

Line 827: ||' WHERE x.OPERATING_ORG_ID '||MSC_UTIL.v_in_org_str

823: ||'x.USING_ASSEMBLY_ITEM_ID,'
824: ||':v_refresh_id,'
825: ||':v_instance_id'
826: ||' FROM MRP_AP_UMP_MATERIAL_REQMNTS_V'||MSC_CL_PULL.v_dblink||' x'
827: ||' WHERE x.OPERATING_ORG_ID '||MSC_UTIL.v_in_org_str
828:
829: ||' AND x.USING_ASSEMBLY_DEMAND_DATE >= :p_eam_cmro_st_date '
830: ||' AND x.USING_ASSEMBLY_DEMAND_DATE <= :p_eam_cmro_end_date '
831: -- ||' AND (x.RN1 >'||MSC_CL_PULL.v_lrn

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

830: ||' AND x.USING_ASSEMBLY_DEMAND_DATE <= :p_eam_cmro_end_date '
831: -- ||' AND (x.RN1 >'||MSC_CL_PULL.v_lrn
832: -- ||' AND x.RN2 >'||MSC_CL_PULL.v_lrn||')'
833: ;
834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for cmro forecast demands :' ||v_sql_stmt);
835:
836: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'SQL statement is '||v_sql_stmt||'-'||p_eam_cmro_st_date||'-'||p_eam_cmro_end_date);
837: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
838: MSC_CL_PULL.v_instance_id

Line 836: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'SQL statement is '||v_sql_stmt||'-'||p_eam_cmro_st_date||'-'||p_eam_cmro_end_date);

832: -- ||' AND x.RN2 >'||MSC_CL_PULL.v_lrn||')'
833: ;
834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for cmro forecast demands :' ||v_sql_stmt);
835:
836: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'SQL statement is '||v_sql_stmt||'-'||p_eam_cmro_st_date||'-'||p_eam_cmro_end_date);
837: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
838: MSC_CL_PULL.v_instance_id
839: ,p_eam_cmro_st_date
840: ,p_eam_cmro_end_date;

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

850: END IF;
851:
852: -- if the profile MSC_INFLATE_WIP is set to YES then inflating the operation resource hours
853: -- and touch time by efficiency and utilization.
854: IF lv_inflate_wip = 1 AND MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
855: v_temp_sql := ' (x.TOTAL_QUANTITY *(1/x.utilization)*(1/x.efficiency)) OPERATION_HOURS_REQUIRED,'||
856: ' (x.TOTAL_QUANTITY * (1/x.efficiency)) TOUCH_TIME,';
857: v_temp_whr := ' AND (x.ENTITY_TYPE <>5 or ((x.TOTAL_QUANTITY * (1/x.utilization)* (1/x.efficiency)) - x.HOURS_EXPENDED) >0) ';
858: ELSE

Line 900: ||' WHERE x.OPERATING_ORG_ID '||MSC_UTIL.v_in_org_str

896: ||'x.due_date,'
897: ||':v_refresh_id,'
898: ||':v_instance_id'
899: ||' FROM MRP_AP_UMP_RESOURCE_REQMNTS_V'||MSC_CL_PULL.v_dblink||' x'
900: ||' WHERE x.OPERATING_ORG_ID '||MSC_UTIL.v_in_org_str
901: ||' AND x.DUE_DATE >= :p_eam_cmro_st_date '
902: ||' AND x.DUE_DATE <= :p_eam_cmro_end_date '
903: || v_temp_whr
904: ;

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

902: ||' AND x.DUE_DATE <= :p_eam_cmro_end_date '
903: || v_temp_whr
904: ;
905:
906: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for eam forecast resource :' ||v_sql_stmt);
907:
908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'SQL statement is '||v_sql_stmt||'-'||p_eam_cmro_st_date||'-'||p_eam_cmro_end_date);
909: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
910: MSC_CL_PULL.v_instance_id

Line 908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'SQL statement is '||v_sql_stmt||'-'||p_eam_cmro_st_date||'-'||p_eam_cmro_end_date);

904: ;
905:
906: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt for eam forecast resource :' ||v_sql_stmt);
907:
908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'SQL statement is '||v_sql_stmt||'-'||p_eam_cmro_st_date||'-'||p_eam_cmro_end_date);
909: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
910: MSC_CL_PULL.v_instance_id
911: ,p_eam_cmro_st_date
912: ,p_eam_cmro_end_date;

Line 948: --||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

944: ||':v_refresh_id,'
945: ||':v_instance_id '
946: ||' FROM '
947: ||' MRP_AP_AHL_DESIGNATORS_V'||MSC_CL_PULL.v_dblink||' x';
948: --||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
949:
950:
951: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id ;
952:

Line 963: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_SUPPLY_RESERVATIONS ');

959:
960: PROCEDURE LOAD_SUPPLY_RESERVATIONS IS
961: BEGIN
962:
963: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_SUPPLY_RESERVATIONS ');
964:
965: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
966: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';
967: MSC_CL_PULL.v_view_name := 'MRP_AD_HARD_RESERVATIONS_V';

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

961: BEGIN
962:
963: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_SUPPLY_RESERVATIONS ');
964:
965: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
966: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';
967: MSC_CL_PULL.v_view_name := 'MRP_AD_HARD_RESERVATIONS_V';
968:
969: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 970: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_SUPPLY_RESERVATIONS in v_lrnn'||MSC_CL_PULL.v_lrnn);

966: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';
967: MSC_CL_PULL.v_view_name := 'MRP_AD_HARD_RESERVATIONS_V';
968:
969: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
970: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_SUPPLY_RESERVATIONS in v_lrnn'||MSC_CL_PULL.v_lrnn);
971:
972: v_sql_stmt:= ' INSERT INTO MSC_ST_RESERVATIONS'
973: ||' ( TRANSACTION_ID,'
974: ||' ORGANIZATION_ID,'

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

983: ||' :v_instance_id'
984: ||' FROM MRP_AD_HARD_RESERVATIONS_V'
985: ||MSC_CL_PULL.V_DBLINK||' x'
986: ||' WHERE x.RN> '||MSC_CL_PULL.v_lrn
987: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
988:
989: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
990: MSC_CL_PULL.v_instance_id;
991: COMMIT;

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

1015: ||' :v_refresh_id,'
1016: ||' :v_instance_id'
1017: ||' FROM MRP_AP_CMRO_RESERVATIONS_V'
1018: ||MSC_CL_PULL.v_dblink||' x'
1019: ||' WHERE x.ORGANIZATION_ID '|| MSC_UTIL.v_in_org_str
1020: ||' AND x.RN2> '||MSC_CL_PULL.v_lrn;
1021: ELSE
1022: v_union_sql :=' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1023: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';

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

1060: ||' :v_refresh_id,'
1061: ||' :v_instance_id'
1062: ||' FROM MRP_AP_CMRO_RESERVATIONS_V'
1063: ||MSC_CL_PULL.v_dblink||' x'
1064: ||' WHERE x.ORGANIZATION_ID '|| MSC_UTIL.v_in_org_str
1065: ||v_union_sql;
1066:
1067: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1068: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

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

1072: ELSE
1073: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1074: MSC_CL_PULL.v_instance_id;
1075: END IF;
1076: END IF; /* MSC_UTIL.G_EAM_CMRO_SUP_VER */
1077:
1078: END LOAD_SUPPLY_RESERVATIONS;
1079:
1080: PROCEDURE LOAD_CLOSED_CMRO_WOS IS

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

1103: ||' :v_refresh_id,'
1104: ||' :v_instance_id'
1105: ||' from MRP_AD_CMRO_CLOSED_JOBS_V'||MSC_CL_PULL.v_dblink||' x'
1106: ||' WHERE x.RN> :v_lrn '
1107: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1108:
1109: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1110:
1111: COMMIT;

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

1152: ||' x.maintenance_object_type,'
1153: ||' :v_refresh_id,'
1154: ||' :v_instance_id'
1155: ||' from MRP_AP_CMRO_CLOSED_JOBS_V'||MSC_CL_PULL.v_dblink||' x'
1156: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1157: ||' AND x.RN2 > :v_lrn ';
1158:
1159: ELSE
1160:

Line 1242: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

1238: ||' x.maintenance_object_type,'
1239: ||' :v_refresh_id,'
1240: ||' :v_instance_id'
1241: ||' from MRP_AP_CMRO_CLOSED_JOBS_V '||MSC_CL_PULL.v_dblink||' x'
1242: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
1243:
1244: v_sql_stmt:= v_sql_stmt || v_union_sql;
1245:
1246: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 1247: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply incr = '||v_sql_stmt);

1243:
1244: v_sql_stmt:= v_sql_stmt || v_union_sql;
1245:
1246: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1247: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply incr = '||v_sql_stmt);
1248: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt,
1249: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1250: MSC_CL_PULL.v_lrn,
1251: MSC_CL_PULL.v_dgmt,

Line 1259: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_CMRO_CLOSED_JOBS_V = '|| SQL%ROWCOUNT);

1255: ELSE -- For COmplete Refresh
1256: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt,
1257: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1258: END IF;
1259: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_CMRO_CLOSED_JOBS_V = '|| SQL%ROWCOUNT);
1260: COMMIT;
1261: -- ===================end Closed CMRO jobs =====================
1262: END LOAD_CLOSED_CMRO_WOS;
1263:

Line 1266: v_item_type_id NUMBER := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;

1262: END LOAD_CLOSED_CMRO_WOS;
1263:
1264: PROCEDURE LOAD_OSP_SUPPLY IS
1265:
1266: v_item_type_id NUMBER := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
1267: v_item_type_good NUMBER := MSC_UTIL.G_PARTCONDN_GOOD;
1268: --v_item_type_bad NUMBER := MSC_UTIL.G_PARTCONDN_BAD;
1269:
1270: BEGIN

Line 1267: v_item_type_good NUMBER := MSC_UTIL.G_PARTCONDN_GOOD;

1263:
1264: PROCEDURE LOAD_OSP_SUPPLY IS
1265:
1266: v_item_type_id NUMBER := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
1267: v_item_type_good NUMBER := MSC_UTIL.G_PARTCONDN_GOOD;
1268: --v_item_type_bad NUMBER := MSC_UTIL.G_PARTCONDN_BAD;
1269:
1270: BEGIN
1271:

Line 1268: --v_item_type_bad NUMBER := MSC_UTIL.G_PARTCONDN_BAD;

1264: PROCEDURE LOAD_OSP_SUPPLY IS
1265:
1266: v_item_type_id NUMBER := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
1267: v_item_type_good NUMBER := MSC_UTIL.G_PARTCONDN_GOOD;
1268: --v_item_type_bad NUMBER := MSC_UTIL.G_PARTCONDN_BAD;
1269:
1270: BEGIN
1271:
1272: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';

Line 1275: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 AND

1271:
1272: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1273: MSC_CL_PULL.v_view_name := 'MRP_AP_OSP_SUP_V';
1274:
1275: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 AND
1276: MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
1277:
1278: v_sql_stmt:=
1279: 'insert into MSC_ST_SUPPLIES'

Line 1276: MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN

1272: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1273: MSC_CL_PULL.v_view_name := 'MRP_AP_OSP_SUP_V';
1274:
1275: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 AND
1276: MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
1277:
1278: v_sql_stmt:=
1279: 'insert into MSC_ST_SUPPLIES'
1280: ||' ( SR_MTL_SUPPLY_ID,'

Line 1316: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str ;

1312: ||' 2,'
1313: ||' :v_refresh_id,'
1314: ||' :v_instance_id'
1315: ||' FROM MRP_AP_OSP_SUP_V '||MSC_CL_PULL.v_dblink||' x'
1316: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str ;
1317:
1318: EXECUTE IMMEDIATE v_sql_stmt USING v_item_type_id,v_item_type_good,
1319: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1320: