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_PRE_PROCESS dependencies on MSC_LOCAL_ID_SUPPLY

Line 1903: msc_analyse_tables_pk.analyse_table( 'MSC_LOCAL_ID_SUPPLY', v_instance_id, -1);

1899: WHEN OTHERS THEN
1900: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N5_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1901: END;
1902:
1903: msc_analyse_tables_pk.analyse_table( 'MSC_LOCAL_ID_SUPPLY', v_instance_id, -1);
1904:
1905: END IF;
1906:
1907: IF v_mat_dmd_enabled = SYS_YES THEN

Line 29755: ||' FROM msc_local_id_supply mls'

29751: v_sql_stmt := 2.1;
29752: lv_sql_stmt :=
29753: 'UPDATE msc_st_supplies mss '
29754: ||' SET disposition_id = (SELECT local_id'
29755: ||' FROM msc_local_id_supply mls'
29756: ||' WHERE mls.char3 = mss.order_number'
29757: ||' AND mls.number1 = mss.order_type'
29758: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
29759: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 29790: INSERT INTO msc_local_id_supply

29786: WHERE rowid = lb_rowid(j);
29787:
29788: v_sql_stmt := 3.1;
29789: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
29790: INSERT INTO msc_local_id_supply
29791: (local_id,
29792: st_transaction_id,
29793: instance_id,
29794: entity_name,

Line 29829: ||' FROM msc_local_id_supply mls'

29825: v_sql_stmt := 4.0;
29826: lv_sql_stmt :=
29827: 'UPDATE msc_st_supplies mss '
29828: ||' SET disposition_id = (SELECT local_id'
29829: ||' FROM msc_local_id_supply mls'
29830: ||' WHERE mls.char3 = mss.order_number'
29831: ||' AND mls.number1 = mss.order_type'
29832: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
29833: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 30651: ||' FROM msc_local_id_supply mls'

30647: v_sql_stmt := 16;
30648: lv_sql_stmt :=
30649: 'UPDATE msc_st_supplies mss '
30650: ||' SET disposition_id = (SELECT local_id'
30651: ||' FROM msc_local_id_supply mls'
30652: ||' WHERE mls.char3 = mss.order_number'
30653: ||' AND mls.number1 = mss.order_type'
30654: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
30655: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 30659: ||' FROM msc_local_id_supply mls'

30655: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '
30656: ||' AND mls.char1 = mss.sr_instance_code'
30657: ||' AND mls.entity_name = ''DISPOSITION_ID'' ),'
30658: ||' po_line_id = (SELECT local_id'
30659: ||' FROM msc_local_id_supply mls'
30660: ||' WHERE mls.number1 = mss.purch_line_num'
30661: ||' AND mls.number2 = mss.order_type'
30662: ||' AND mls.char3 = mss.order_number'
30663: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '

Line 30684: ||' FROM msc_local_id_supply mls'

30680: v_sql_stmt := 17;
30681: lv_sql_stmt :=
30682: 'UPDATE msc_st_supplies mss'
30683: ||' SET sr_mtl_supply_id = (SELECT local_id'
30684: ||' FROM msc_local_id_supply mls'
30685: ||' WHERE mls.char4 = mss.order_number'
30686: ||' AND mls.number1 = mss.purch_line_num'
30687: ||' AND mls.number2 = mss.order_type'
30688: ||' AND mls.char3 = mss.organization_code'

Line 30743: ||' FROM msc_local_id_supply mls'

30739: v_sql_stmt := 19;
30740: lv_sql_stmt :=
30741: 'UPDATE msc_st_supplies mss'
30742: ||' SET disposition_id = (SELECT local_id'
30743: ||' FROM msc_local_id_supply mls'
30744: ||' WHERE mls.char4 = mss.schedule_designator'
30745: ||' AND mls.char5 = mss.schedule_line_num'
30746: ||' AND mls.number1 = mss.order_type'
30747: ||' AND mls.char1 = mss.sr_instance_code'

Line 30815: INSERT INTO msc_local_id_supply

30811: WHERE rowid = lb_rowid(j);
30812:
30813: v_sql_stmt := 23;
30814: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
30815: INSERT INTO msc_local_id_supply
30816: (local_id,
30817: st_transaction_id,
30818: instance_id,
30819: entity_name,

Line 30884: INSERT INTO msc_local_id_supply

30880: WHERE rowid = lb_rowid(j);
30881:
30882: v_sql_stmt := 27;
30883: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
30884: INSERT INTO msc_local_id_supply
30885: (local_id,
30886: st_transaction_id,
30887: instance_id,
30888: entity_name,

Line 30951: INSERT INTO msc_local_id_supply

30947: WHERE rowid = lb_rowid(j);
30948:
30949: v_sql_stmt := 29;
30950: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
30951: INSERT INTO msc_local_id_supply
30952: (local_id,
30953: st_transaction_id,
30954: instance_id,
30955: entity_name,

Line 31029: ||' FROM msc_local_id_supply mls'

31025: v_sql_stmt := 31;
31026: lv_sql_stmt :=
31027: 'UPDATE msc_st_supplies mss '
31028: ||' SET disposition_id = (SELECT local_id'
31029: ||' FROM msc_local_id_supply mls'
31030: ||' WHERE mls.char3 = mss.order_number'
31031: ||' AND mls.number1 = mss.order_type'
31032: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
31033: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 33461: ||' FROM msc_local_id_supply mls'

33457: v_sql_stmt := 5.2;
33458: lv_sql_stmt :=
33459: 'UPDATE msc_st_reservations msr '
33460: ||' SET disposition_id =(SELECT local_id'
33461: ||' FROM msc_local_id_supply mls'
33462: ||' WHERE mls.char4 = msr.demand_order_number'
33463: ||' AND mls.char3 = msr.organization_code'
33464: ||' AND mls.char1 = msr.sr_instance_code'
33465: ||' AND mls.entity_name = ''REPAIR_NUMBER'' )'

Line 33482: ||' FROM msc_local_id_supply mls'

33478: v_sql_stmt := 5.3;
33479: lv_sql_stmt :=
33480: 'UPDATE msc_st_reservations msr '
33481: ||' SET disposition_id =(SELECT local_id'
33482: ||' FROM msc_local_id_supply mls'
33483: ||' WHERE mls.char3 = msr.demand_order_number'
33484: ||' AND mls.number1 = 74' -- order_type
33485: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
33486: ||' NVL(msr.company_name,'||''''||NULL_CHAR||''''||') '

Line 33506: ||' FROM msc_local_id_supply mls'

33502: v_sql_stmt := 5.5;
33503: lv_sql_stmt :=
33504: 'UPDATE msc_st_reservations msr '
33505: ||' SET transaction_id =(SELECT local_id'
33506: ||' FROM msc_local_id_supply mls'
33507: ||' WHERE mls.char4 = msr.supply_order_number'
33508: ||' AND mls.char3 = msr.organization_code'
33509: ||' AND mls.char1 = msr.sr_instance_code'
33510: ||' AND mls.entity_name = ''REPAIR_NUMBER'' )'

Line 33527: ||' FROM msc_local_id_supply mls'

33523: v_sql_stmt := 5.5;
33524: lv_sql_stmt :=
33525: 'UPDATE msc_st_reservations msr '
33526: ||' SET transaction_id =(SELECT local_id'
33527: ||' FROM msc_local_id_supply mls'
33528: ||' WHERE mls.number1 = msr.purch_line_num'
33529: ||' AND mls.number2 =2' -- order_type
33530: ||' AND mls.char3 = msr.supply_order_number'
33531: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '

Line 33551: ||' FROM msc_local_id_supply mls'

33547: v_sql_stmt := 5.6;
33548: lv_sql_stmt :=
33549: 'UPDATE msc_st_reservations msr '
33550: ||' SET transaction_id =(SELECT local_id'
33551: ||' FROM msc_local_id_supply mls'
33552: ||' WHERE mls.char4 = msr.supply_order_number'
33553: ||' AND mls.char3 = msr.supply_org_code'
33554: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
33555: ||' NVL(msr.company_name,'||''''||NULL_CHAR||''''||') '

Line 33574: ||' FROM msc_local_id_supply mls'

33570: v_sql_stmt := 5.6;
33571: lv_sql_stmt :=
33572: 'UPDATE msc_st_reservations msr '
33573: ||' SET transaction_id =(SELECT local_id'
33574: ||' FROM msc_local_id_supply mls'
33575: ||' WHERE mls.char3 = msr.supply_order_number'
33576: ||' AND mls.number1 = 74' -- order_type
33577: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
33578: ||' NVL(msr.company_name,'||''''||NULL_CHAR||''''||') '

Line 43027: ||' FROM msc_local_id_supply mls'

43023: v_sql_stmt := 09;
43024: lv_sql_stmt :=
43025: 'UPDATE msc_st_supplies mss'
43026: ||' SET schedule_group_id = (SELECT local_id'
43027: ||' FROM msc_local_id_supply mls'
43028: ||' WHERE mls.char4 = mss.schedule_group_name'
43029: ||' AND mls.char3 = mss.organization_code'
43030: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
43031: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 43109: ||' FROM msc_local_id_supply mls'

43105: v_sql_stmt := 10;
43106: lv_sql_stmt :=
43107: 'UPDATE msc_st_supplies mss'
43108: ||' SET wip_entity_id = (SELECT local_id'
43109: ||' FROM msc_local_id_supply mls'
43110: ||' WHERE mls.char4 = mss.wip_entity_name'
43111: ||' AND mls.char3 = mss.organization_code'
43112: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
43113: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 43234: INSERT INTO msc_local_id_supply

43230: WHERE rowid = lb_rowid(j);
43231:
43232: v_sql_stmt := 13;
43233: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
43234: INSERT INTO msc_local_id_supply
43235: (local_id,
43236: st_transaction_id,
43237: instance_id,
43238: entity_name,

Line 43293: INSERT INTO msc_local_id_supply

43289: WHERE rowid = lb_rowid(j);
43290:
43291: v_sql_stmt := 15;
43292: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
43293: INSERT INTO msc_local_id_supply
43294: (local_id,
43295: st_transaction_id,
43296: instance_id,
43297: entity_name,

Line 43419: ||' FROM msc_local_id_supply mls'

43415: v_sql_stmt := 17;
43416: lv_sql_stmt :=
43417: 'UPDATE msc_st_supplies mss '
43418: ||' SET schedule_group_id = (SELECT local_id'
43419: ||' FROM msc_local_id_supply mls'
43420: ||' WHERE mls.char4 = mss.schedule_group_name'
43421: ||' AND mls.char3 = mss.organization_code'
43422: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
43423: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 43786: ||' FROM msc_local_id_supply mlis'

43782: v_sql_stmt := 06;
43783: lv_sql_stmt:=
43784: 'UPDATE msc_st_resource_requirements msrr'
43785: ||' SET wip_entity_id = (SELECT local_id '
43786: ||' FROM msc_local_id_supply mlis'
43787: ||' WHERE mlis.char1 = msrr.sr_instance_code'
43788: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
43789: ||' = NVL(msrr.company_name,'||''''||NULL_CHAR||''''||') '
43790: ||' AND mlis.char3 = msrr.organization_code'

Line 45100: ||' FROM msc_local_id_supply mlid'

45096:
45097: lv_sql_stmt :=
45098: 'UPDATE msc_st_demands msd'
45099: ||' SET wip_entity_id = ( SELECT local_id '
45100: ||' FROM msc_local_id_supply mlid'
45101: ||' WHERE mlid.char1 = msd.sr_instance_code'
45102: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
45103: ||' = NVL(msd.company_name,'||''''||NULL_CHAR||''''||') '
45104: ||' AND mlid.char3 = msd.organization_code'

Line 46306: ||' FROM msc_local_id_supply mls'

46302: v_sql_stmt := 10;
46303: lv_sql_stmt :=
46304: 'UPDATE msc_st_job_operation_networks mss'
46305: ||' SET wip_entity_id = (SELECT local_id'
46306: ||' FROM msc_local_id_supply mls'
46307: ||' WHERE mls.char4 = mss.wip_entity_name'
46308: ||' AND mls.char3 = mss.organization_code'
46309: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
46310: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 47118: ||' FROM msc_local_id_supply mls'

47114: v_sql_stmt := 10;
47115: lv_sql_stmt :=
47116: 'UPDATE msc_st_job_operations mss'
47117: ||' SET wip_entity_id = (SELECT local_id'
47118: ||' FROM msc_local_id_supply mls'
47119: ||' WHERE mls.char4 = mss.wip_entity_name'
47120: ||' AND mls.char3 = mss.organization_code'
47121: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
47122: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 47708: ||' FROM msc_local_id_supply mls'

47704: v_sql_stmt := 10;
47705: lv_sql_stmt :=
47706: 'UPDATE msc_st_job_requirement_ops mss'
47707: ||' SET wip_entity_id = (SELECT local_id'
47708: ||' FROM msc_local_id_supply mls'
47709: ||' WHERE mls.char4 = mss.wip_entity_name'
47710: ||' AND mls.char3 = mss.organization_code'
47711: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
47712: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 48535: ||' FROM msc_local_id_supply mlis'

48531: v_sql_stmt := 06;
48532: lv_sql_stmt:=
48533: 'UPDATE msc_st_job_op_resources msrr'
48534: ||' SET wip_entity_id = (SELECT local_id '
48535: ||' FROM msc_local_id_supply mlis'
48536: ||' WHERE mlis.char1 = msrr.sr_instance_code'
48537: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
48538: ||' = NVL(msrr.company_name,'||''''||NULL_CHAR||''''||') '
48539: ||' AND mlis.char3 = msrr.organization_code'