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 1911: msc_analyse_tables_pk.analyse_table( 'MSC_LOCAL_ID_SUPPLY', v_instance_id, -1);

1907: WHEN OTHERS THEN
1908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N5_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1909: END;
1910:
1911: msc_analyse_tables_pk.analyse_table( 'MSC_LOCAL_ID_SUPPLY', v_instance_id, -1);
1912:
1913: END IF;
1914:
1915: IF v_mat_dmd_enabled = SYS_YES THEN

Line 34086: ||' FROM msc_local_id_supply mls'

34082: v_sql_stmt := 2.1;
34083: lv_sql_stmt :=
34084: 'UPDATE msc_st_supplies mss '
34085: ||' SET disposition_id = (SELECT local_id'
34086: ||' FROM msc_local_id_supply mls'
34087: ||' WHERE mls.char3 = mss.order_number'
34088: ||' AND mls.number1 = mss.order_type'
34089: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
34090: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 34123: INSERT INTO msc_local_id_supply

34119: WHERE rowid = lb_rowid(j);
34120:
34121: v_sql_stmt := 3.1;
34122: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
34123: INSERT INTO msc_local_id_supply
34124: (local_id,
34125: st_transaction_id,
34126: instance_id,
34127: entity_name,

Line 34162: ||' FROM msc_local_id_supply mls'

34158: v_sql_stmt := 4.0;
34159: lv_sql_stmt :=
34160: 'UPDATE msc_st_supplies mss '
34161: ||' SET disposition_id = (SELECT local_id'
34162: ||' FROM msc_local_id_supply mls'
34163: ||' WHERE mls.char3 = mss.order_number'
34164: ||' AND mls.number1 = mss.order_type'
34165: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
34166: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 35131: ||' FROM msc_local_id_supply mls'

35127: v_sql_stmt := 16;
35128: lv_sql_stmt :=
35129: 'UPDATE msc_st_supplies mss '
35130: ||' SET disposition_id = (SELECT local_id'
35131: ||' FROM msc_local_id_supply mls'
35132: ||' WHERE mls.char3 = mss.order_number'
35133: ||' AND mls.number1 = mss.order_type'
35134: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
35135: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 35139: ||' FROM msc_local_id_supply mls'

35135: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '
35136: ||' AND mls.char1 = mss.sr_instance_code'
35137: ||' AND mls.entity_name = ''DISPOSITION_ID'' ),'
35138: ||' po_line_id = (SELECT local_id'
35139: ||' FROM msc_local_id_supply mls'
35140: ||' WHERE mls.number1 = mss.purch_line_num'
35141: ||' AND mls.number2 = mss.order_type'
35142: ||' AND mls.char3 = mss.order_number'
35143: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '

Line 35164: ||' FROM msc_local_id_supply mls'

35160: v_sql_stmt := 17;
35161: lv_sql_stmt :=
35162: 'UPDATE msc_st_supplies mss'
35163: ||' SET sr_mtl_supply_id = (SELECT local_id'
35164: ||' FROM msc_local_id_supply mls'
35165: ||' WHERE mls.char4 = mss.order_number'
35166: ||' AND mls.number1 = mss.purch_line_num'
35167: ||' AND mls.number2 = mss.order_type'
35168: ||' AND mls.char3 = mss.organization_code'

Line 35223: ||' FROM msc_local_id_supply mls'

35219: v_sql_stmt := 19;
35220: lv_sql_stmt :=
35221: 'UPDATE msc_st_supplies mss'
35222: ||' SET disposition_id = (SELECT local_id'
35223: ||' FROM msc_local_id_supply mls'
35224: ||' WHERE mls.char4 = mss.schedule_designator'
35225: ||' AND mls.char5 = mss.schedule_line_num'
35226: ||' AND mls.number1 = mss.order_type'
35227: ||' AND mls.char1 = mss.sr_instance_code'

Line 35252: ||' FROM msc_local_id_supply mls'

35248: v_sql_stmt := 19;
35249: lv_sql_stmt :=
35250: 'UPDATE msc_st_supplies mss'
35251: ||' SET disposition_id = (SELECT local_id'
35252: ||' FROM msc_local_id_supply mls'
35253: ||' WHERE mls.char4 = mss.schedule_designator'
35254: ||' AND mls.number1 = mss.order_type'
35255: ||' AND mls.char1 = mss.sr_instance_code'
35256: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '

Line 35324: INSERT INTO msc_local_id_supply

35320: WHERE rowid = lb_rowid(j);
35321:
35322: v_sql_stmt := 23;
35323: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
35324: INSERT INTO msc_local_id_supply
35325: (local_id,
35326: st_transaction_id,
35327: instance_id,
35328: entity_name,

Line 35393: INSERT INTO msc_local_id_supply

35389: WHERE rowid = lb_rowid(j);
35390:
35391: v_sql_stmt := 27;
35392: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
35393: INSERT INTO msc_local_id_supply
35394: (local_id,
35395: st_transaction_id,
35396: instance_id,
35397: entity_name,

Line 35460: INSERT INTO msc_local_id_supply

35456: WHERE rowid = lb_rowid(j);
35457:
35458: v_sql_stmt := 29;
35459: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
35460: INSERT INTO msc_local_id_supply
35461: (local_id,
35462: st_transaction_id,
35463: instance_id,
35464: entity_name,

Line 35537: ||' FROM msc_local_id_supply mls'

35533: v_sql_stmt := 31;
35534: lv_sql_stmt :=
35535: 'UPDATE msc_st_supplies mss '
35536: ||' SET disposition_id = (SELECT local_id'
35537: ||' FROM msc_local_id_supply mls'
35538: ||' WHERE mls.char3 = mss.order_number'
35539: ||' AND mls.number1 = mss.order_type'
35540: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
35541: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 38176: ||' FROM msc_local_id_supply mls'

38172: v_sql_stmt := 5.2;
38173: lv_sql_stmt :=
38174: 'UPDATE msc_st_reservations msr '
38175: ||' SET disposition_id =(SELECT local_id'
38176: ||' FROM msc_local_id_supply mls'
38177: ||' WHERE mls.char4 = msr.demand_order_number'
38178: ||' AND mls.char3 = msr.organization_code'
38179: ||' AND mls.char1 = msr.sr_instance_code'
38180: ||' AND mls.entity_name = ''REPAIR_NUMBER'' )'

Line 38197: ||' FROM msc_local_id_supply mls'

38193: v_sql_stmt := 5.3;
38194: lv_sql_stmt :=
38195: 'UPDATE msc_st_reservations msr '
38196: ||' SET disposition_id =(SELECT local_id'
38197: ||' FROM msc_local_id_supply mls'
38198: ||' WHERE mls.char3 = msr.demand_order_number'
38199: ||' AND mls.number1 = 74' -- order_type
38200: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
38201: ||' NVL(msr.company_name,'||''''||NULL_CHAR||''''||') '

Line 38221: ||' FROM msc_local_id_supply mls'

38217: v_sql_stmt := 5.5;
38218: lv_sql_stmt :=
38219: 'UPDATE msc_st_reservations msr '
38220: ||' SET transaction_id =(SELECT local_id'
38221: ||' FROM msc_local_id_supply mls'
38222: ||' WHERE mls.char4 = msr.supply_order_number'
38223: ||' AND mls.char3 = msr.organization_code'
38224: ||' AND mls.char1 = msr.sr_instance_code'
38225: ||' AND mls.entity_name = ''REPAIR_NUMBER'' )'

Line 38242: ||' FROM msc_local_id_supply mls'

38238: v_sql_stmt := 5.5;
38239: lv_sql_stmt :=
38240: 'UPDATE msc_st_reservations msr '
38241: ||' SET transaction_id =(SELECT local_id'
38242: ||' FROM msc_local_id_supply mls'
38243: ||' WHERE mls.number1 = msr.purch_line_num'
38244: ||' AND mls.number2 =2' -- order_type
38245: ||' AND mls.char3 = msr.supply_order_number'
38246: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '

Line 38266: ||' FROM msc_local_id_supply mls'

38262: v_sql_stmt := 5.6;
38263: lv_sql_stmt :=
38264: 'UPDATE msc_st_reservations msr '
38265: ||' SET transaction_id =(SELECT local_id'
38266: ||' FROM msc_local_id_supply mls'
38267: ||' WHERE mls.char4 = msr.supply_order_number'
38268: ||' AND mls.char3 = msr.supply_org_code'
38269: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
38270: ||' NVL(msr.company_name,'||''''||NULL_CHAR||''''||') '

Line 38289: ||' FROM msc_local_id_supply mls'

38285: v_sql_stmt := 5.6;
38286: lv_sql_stmt :=
38287: 'UPDATE msc_st_reservations msr '
38288: ||' SET transaction_id =(SELECT local_id'
38289: ||' FROM msc_local_id_supply mls'
38290: ||' WHERE mls.char3 = msr.supply_order_number'
38291: ||' AND mls.number1 = 74' -- order_type
38292: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
38293: ||' NVL(msr.company_name,'||''''||NULL_CHAR||''''||') '

Line 47904: ||' FROM msc_local_id_supply mls'

47900: v_sql_stmt := 09;
47901: lv_sql_stmt :=
47902: 'UPDATE msc_st_supplies mss'
47903: ||' SET schedule_group_id = (SELECT local_id'
47904: ||' FROM msc_local_id_supply mls'
47905: ||' WHERE mls.char4 = mss.schedule_group_name'
47906: ||' AND mls.char3 = mss.organization_code'
47907: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
47908: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 47986: ||' FROM msc_local_id_supply mls'

47982: v_sql_stmt := 10;
47983: lv_sql_stmt :=
47984: 'UPDATE msc_st_supplies mss'
47985: ||' SET wip_entity_id = (SELECT local_id'
47986: ||' FROM msc_local_id_supply mls'
47987: ||' WHERE mls.char4 = mss.wip_entity_name'
47988: ||' AND mls.char3 = mss.organization_code'
47989: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
47990: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 48111: INSERT INTO msc_local_id_supply

48107: WHERE rowid = lb_rowid(j);
48108:
48109: v_sql_stmt := 13;
48110: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
48111: INSERT INTO msc_local_id_supply
48112: (local_id,
48113: st_transaction_id,
48114: instance_id,
48115: entity_name,

Line 48170: INSERT INTO msc_local_id_supply

48166: WHERE rowid = lb_rowid(j);
48167:
48168: v_sql_stmt := 15;
48169: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
48170: INSERT INTO msc_local_id_supply
48171: (local_id,
48172: st_transaction_id,
48173: instance_id,
48174: entity_name,

Line 48296: ||' FROM msc_local_id_supply mls'

48292: v_sql_stmt := 17;
48293: lv_sql_stmt :=
48294: 'UPDATE msc_st_supplies mss '
48295: ||' SET schedule_group_id = (SELECT local_id'
48296: ||' FROM msc_local_id_supply mls'
48297: ||' WHERE mls.char4 = mss.schedule_group_name'
48298: ||' AND mls.char3 = mss.organization_code'
48299: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
48300: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 48663: ||' FROM msc_local_id_supply mlis'

48659: v_sql_stmt := 06;
48660: lv_sql_stmt:=
48661: 'UPDATE msc_st_resource_requirements msrr'
48662: ||' SET wip_entity_id = (SELECT local_id '
48663: ||' FROM msc_local_id_supply mlis'
48664: ||' WHERE mlis.char1 = msrr.sr_instance_code'
48665: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
48666: ||' = NVL(msrr.company_name,'||''''||NULL_CHAR||''''||') '
48667: ||' AND mlis.char3 = msrr.organization_code'

Line 49984: ||' FROM msc_local_id_supply mlid'

49980:
49981: lv_sql_stmt :=
49982: 'UPDATE msc_st_demands msd'
49983: ||' SET wip_entity_id = ( SELECT local_id '
49984: ||' FROM msc_local_id_supply mlid'
49985: ||' WHERE mlid.char1 = msd.sr_instance_code'
49986: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
49987: ||' = NVL(msd.company_name,'||''''||NULL_CHAR||''''||') '
49988: ||' AND mlid.char3 = msd.organization_code'

Line 51190: ||' FROM msc_local_id_supply mls'

51186: v_sql_stmt := 10;
51187: lv_sql_stmt :=
51188: 'UPDATE msc_st_job_operation_networks mss'
51189: ||' SET wip_entity_id = (SELECT local_id'
51190: ||' FROM msc_local_id_supply mls'
51191: ||' WHERE mls.char4 = mss.wip_entity_name'
51192: ||' AND mls.char3 = mss.organization_code'
51193: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
51194: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 52002: ||' FROM msc_local_id_supply mls'

51998: v_sql_stmt := 10;
51999: lv_sql_stmt :=
52000: 'UPDATE msc_st_job_operations mss'
52001: ||' SET wip_entity_id = (SELECT local_id'
52002: ||' FROM msc_local_id_supply mls'
52003: ||' WHERE mls.char4 = mss.wip_entity_name'
52004: ||' AND mls.char3 = mss.organization_code'
52005: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
52006: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 52592: ||' FROM msc_local_id_supply mls'

52588: v_sql_stmt := 10;
52589: lv_sql_stmt :=
52590: 'UPDATE msc_st_job_requirement_ops mss'
52591: ||' SET wip_entity_id = (SELECT local_id'
52592: ||' FROM msc_local_id_supply mls'
52593: ||' WHERE mls.char4 = mss.wip_entity_name'
52594: ||' AND mls.char3 = mss.organization_code'
52595: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
52596: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 53419: ||' FROM msc_local_id_supply mlis'

53415: v_sql_stmt := 06;
53416: lv_sql_stmt:=
53417: 'UPDATE msc_st_job_op_resources msrr'
53418: ||' SET wip_entity_id = (SELECT local_id '
53419: ||' FROM msc_local_id_supply mlis'
53420: ||' WHERE mlis.char1 = msrr.sr_instance_code'
53421: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
53422: ||' = NVL(msrr.company_name,'||''''||NULL_CHAR||''''||') '
53423: ||' AND mlis.char3 = msrr.organization_code'