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_DEMAND

Line 1995: msc_analyse_tables_pk.analyse_table( 'MSC_LOCAL_ID_DEMAND', v_instance_id, -1);

1991: WHEN OTHERS THEN
1992: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SO_N3_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1993: END;
1994:
1995: msc_analyse_tables_pk.analyse_table( 'MSC_LOCAL_ID_DEMAND', v_instance_id, -1);
1996:
1997: END IF;
1998:
1999: IF v_reserve_enabled = SYS_YES THEN

Line 31404: ||' FROM msc_local_id_demand mlid'

31400: v_sql_stmt := 2.0;
31401: lv_sql_stmt :=
31402: 'UPDATE msc_st_sales_orders mso '
31403: ||' SET demand_source_header_id = (SELECT local_id'
31404: ||' FROM msc_local_id_demand mlid'
31405: ||' WHERE mlid.char1 = mso.sr_instance_code'
31406: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
31407: ||' = NVL(mso.company_name,'||''''||NULL_CHAR||''''||') '
31408: ||' AND mlid.char3 = mso.organization_code'

Line 31434: INSERT INTO msc_local_id_demand

31430: AND demand_Source_header_id is null;
31431:
31432: v_sql_stmt := 2.2;
31433: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
31434: INSERT INTO msc_local_id_demand
31435: (local_id,
31436: st_transaction_id,
31437: instance_id,
31438: entity_name,

Line 31476: ||' FROM msc_local_id_demand mlid'

31472: v_sql_stmt := 2.4;
31473: lv_sql_stmt :=
31474: 'UPDATE msc_st_sales_orders mso '
31475: ||' SET demand_source_header_id = (SELECT local_id'
31476: ||' FROM msc_local_id_demand mlid'
31477: ||' WHERE mlid.char1 = mso.sr_instance_code'
31478: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
31479: ||' = NVL(mso.company_name,'||''''||NULL_CHAR||''''||') '
31480: ||' AND mlid.char3 = mso.organization_code'

Line 31668: ||' FROM msc_local_id_demand mlid'

31664: v_sql_stmt := 06;
31665: lv_sql_stmt :=
31666: 'UPDATE msc_st_sales_orders mso '
31667: ||' SET demand_id = (SELECT local_id'
31668: ||' FROM msc_local_id_demand mlid'
31669: ||' WHERE mlid.char1 = mso.sr_instance_code'
31670: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
31671: ||' = NVL(mso.company_name,'||''''||NULL_CHAR||''''||') '
31672: ||' AND mlid.char3 = mso.organization_code'

Line 32395: INSERT INTO msc_local_id_demand

32391: WHERE rowid = lb_rowid(j);
32392:
32393: v_sql_stmt := 14;
32394: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
32395: INSERT INTO msc_local_id_demand
32396: (local_id,
32397: st_transaction_id,
32398: instance_id,
32399: entity_name,

Line 32473: ||' FROM msc_local_id_demand mlid'

32469:
32470: lv_sql_stmt :=
32471: 'UPDATE msc_st_sales_orders mso '
32472: ||' SET ship_set_id = (SELECT local_id'
32473: ||' FROM msc_local_id_demand mlid'
32474: ||' WHERE mlid.char1 = mso.sr_instance_code'
32475: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
32476: ||' = NVL(mso.company_name,'||''''||NULL_CHAR||''''||') '
32477: ||' AND mlid.char3 = mso.organization_code'

Line 32505: INSERT INTO msc_local_id_demand

32501: AND ship_set_id is null;
32502:
32503: v_sql_stmt := 15.2;
32504: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
32505: INSERT INTO msc_local_id_demand
32506: (local_id,
32507: st_transaction_id,
32508: instance_id,
32509: entity_name,

Line 32547: ||' FROM msc_local_id_demand mlid'

32543: v_sql_stmt := 15.4;
32544: lv_sql_stmt :=
32545: 'UPDATE msc_st_sales_orders mso '
32546: ||' SET ship_set_id = (SELECT local_id'
32547: ||' FROM msc_local_id_demand mlid'
32548: ||' WHERE mlid.char1 = mso.sr_instance_code'
32549: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
32550: ||' = NVL(mso.company_name,'||''''||NULL_CHAR||''''||') '
32551: ||' AND mlid.char3 = mso.organization_code'

Line 32575: ||' FROM msc_local_id_demand mlid'

32571:
32572: lv_sql_stmt :=
32573: 'UPDATE msc_st_sales_orders mso '
32574: ||' SET arrival_set_id = (SELECT local_id'
32575: ||' FROM msc_local_id_demand mlid'
32576: ||' WHERE mlid.char1 = mso.sr_instance_code'
32577: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
32578: ||' = NVL(mso.company_name,'||''''||NULL_CHAR||''''||') '
32579: ||' AND mlid.char3 = mso.organization_code'

Line 32607: INSERT INTO msc_local_id_demand

32603: AND arrival_set_id is null;
32604:
32605: v_sql_stmt := 16.2;
32606: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
32607: INSERT INTO msc_local_id_demand
32608: (local_id,
32609: st_transaction_id,
32610: instance_id,
32611: entity_name,

Line 32649: ||' FROM msc_local_id_demand mlid'

32645: v_sql_stmt := 16.4;
32646: lv_sql_stmt :=
32647: 'UPDATE msc_st_sales_orders mso '
32648: ||' SET arrival_set_id = (SELECT local_id'
32649: ||' FROM msc_local_id_demand mlid'
32650: ||' WHERE mlid.char1 = mso.sr_instance_code'
32651: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
32652: ||' = NVL(mso.company_name,'||''''||NULL_CHAR||''''||') '
32653: ||' AND mlid.char3 = mso.organization_code'

Line 33412: ||' FROM msc_local_id_demand mlid'

33408: v_sql_stmt := 5.0;
33409: lv_sql_stmt :=
33410: 'UPDATE msc_st_reservations msr '
33411: ||' SET disposition_id = (SELECT local_id'
33412: ||' FROM msc_local_id_demand mlid'
33413: ||' WHERE mlid.char1 = msr.sr_instance_code'
33414: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
33415: ||' = NVL(msr.company_name,'||''''||NULL_CHAR||''''||') '
33416: ||' AND mlid.char3 = msr.organization_code'

Line 33436: ||' FROM msc_local_id_demand mlid'

33432: v_sql_stmt := 5.1;
33433: lv_sql_stmt :=
33434: 'UPDATE msc_st_reservations msr '
33435: ||' SET disposition_id = (SELECT local_id'
33436: ||' FROM msc_local_id_demand mlid'
33437: ||' WHERE mlid.char1 = msr.sr_instance_code'
33438: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
33439: ||' = NVL(msr.company_name,'||''''||NULL_CHAR||''''||') '
33440: ||' AND mlid.char3 = msr.organization_code'

Line 33598: ||' FROM msc_local_id_demand mlid'

33594: v_sql_stmt := 06;
33595: lv_sql_stmt :=
33596: 'UPDATE msc_st_reservations msr '
33597: ||' SET parent_demand_id = (SELECT local_id'
33598: ||' FROM msc_local_id_demand mlid'
33599: ||' WHERE mlid.char1 = msr.sr_instance_code'
33600: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
33601: ||' = NVL(msr.company_name,'||''''||NULL_CHAR||''''||') '
33602: ||' AND mlid.char3 = msr.organization_code'

Line 34216: ||' FROM msc_local_id_demand mlid'

34212: v_sql_stmt := 08;
34213: lv_sql_stmt :=
34214: 'UPDATE msc_st_demands msd '
34215: ||' SET disposition_id = (SELECT local_id'
34216: ||' FROM msc_local_id_demand mlid'
34217: ||' WHERE mlid.char1 = msd.sr_instance_code'
34218: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
34219: ||' = NVL(msd.company_name,'||''''||NULL_CHAR||''''||') '
34220: ||' AND mlid.char3 = msd.organization_code'

Line 34275: ||' FROM msc_local_id_demand mlid'

34271: v_sql_stmt := 10;
34272: lv_sql_stmt :=
34273: 'UPDATE msc_st_demands msd '
34274: ||' SET sales_order_line_id = (SELECT local_id'
34275: ||' FROM msc_local_id_demand mlid'
34276: ||' WHERE mlid.char1 = msd.sr_instance_code'
34277: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
34278: ||' = NVL(msd.company_name,'||''''||NULL_CHAR||''''||') '
34279: ||' AND mlid.char3 = msd.organization_code'

Line 34834: INSERT INTO msc_local_id_demand

34830: WHERE rowid = lb_rowid(j);
34831:
34832: v_sql_stmt := 16;
34833: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
34834: INSERT INTO msc_local_id_demand
34835: (local_id,
34836: st_transaction_id,
34837: instance_id,
34838: entity_name,

Line 34909: INSERT INTO msc_local_id_demand

34905: WHERE rowid = lb_rowid(j);
34906:
34907: v_sql_stmt := 18;
34908: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
34909: INSERT INTO msc_local_id_demand
34910: (local_id,
34911: st_transaction_id,
34912: instance_id,
34913: entity_name,