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

1999: WHEN OTHERS THEN
2000: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SO_N3_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2001: END;
2002:
2003: msc_analyse_tables_pk.analyse_table( 'MSC_LOCAL_ID_DEMAND', v_instance_id, -1);
2004:
2005: END IF;
2006:
2007: IF v_reserve_enabled = SYS_YES THEN

Line 35990: ||' FROM msc_local_id_demand mlid'

35986: v_sql_stmt := 2.0;
35987: lv_sql_stmt :=
35988: 'UPDATE msc_st_sales_orders mso '
35989: ||' SET demand_source_header_id = (SELECT local_id'
35990: ||' FROM msc_local_id_demand mlid'
35991: ||' WHERE mlid.char1 = mso.sr_instance_code'
35992: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
35993: ||' = NVL(mso.company_name,'||''''||NULL_CHAR||''''||') '
35994: ||' AND mlid.char3 = mso.organization_code'

Line 36020: INSERT INTO msc_local_id_demand

36016: AND demand_Source_header_id is null;
36017:
36018: v_sql_stmt := 2.2;
36019: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
36020: INSERT INTO msc_local_id_demand
36021: (local_id,
36022: st_transaction_id,
36023: instance_id,
36024: entity_name,

Line 36062: ||' FROM msc_local_id_demand mlid'

36058: v_sql_stmt := 2.4;
36059: lv_sql_stmt :=
36060: 'UPDATE msc_st_sales_orders mso '
36061: ||' SET demand_source_header_id = (SELECT local_id'
36062: ||' FROM msc_local_id_demand mlid'
36063: ||' WHERE mlid.char1 = mso.sr_instance_code'
36064: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
36065: ||' = NVL(mso.company_name,'||''''||NULL_CHAR||''''||') '
36066: ||' AND mlid.char3 = mso.organization_code'

Line 36092: -- Here, we will insert records into table msc_local_id_demand

36088: -- 12620427
36089: -- Logic to retain the demand source header id present
36090: -- in the staging table.
36091:
36092: -- Here, we will insert records into table msc_local_id_demand
36093: -- for entity_type = 'SALES_ORDER_ID'.
36094: -- for sales order number that do not already exist in this table.
36095:
36096: v_sql_stmt := 2.5;

Line 36387: ||' FROM msc_local_id_demand mlid'

36383: v_sql_stmt := 06;
36384: lv_sql_stmt :=
36385: 'UPDATE msc_st_sales_orders mso '
36386: ||' SET demand_id = (SELECT local_id'
36387: ||' FROM msc_local_id_demand mlid'
36388: ||' WHERE mlid.char1 = mso.sr_instance_code'
36389: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
36390: ||' = NVL(mso.company_name,'||''''||NULL_CHAR||''''||') '
36391: ||' AND mlid.char3 = mso.organization_code'

Line 37079: INSERT INTO msc_local_id_demand

37075: WHERE rowid = lb_rowid(j);
37076:
37077: v_sql_stmt := 14;
37078: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
37079: INSERT INTO msc_local_id_demand
37080: (local_id,
37081: st_transaction_id,
37082: instance_id,
37083: entity_name,

Line 37155: -- msc_local_id_demand for sales order lines that are not present

37151: -- 12620427
37152: -- Logic to retain the demand source line present
37153: -- in the staging table.
37154: -- Here, we will insert entity_type DEMAND_ID into
37155: -- msc_local_id_demand for sales order lines that are not present
37156: -- in the table already.
37157: -- Then, we will finally update msc_st_sales_orders.demand_id
37158: -- to be equal to demand_source_line
37159:

Line 37188: ||' FROM msc_local_id_demand mlid'

37184:
37185: lv_sql_stmt :=
37186: 'UPDATE msc_st_sales_orders mso '
37187: ||' SET ship_set_id = (SELECT local_id'
37188: ||' FROM msc_local_id_demand mlid'
37189: ||' WHERE mlid.char1 = mso.sr_instance_code'
37190: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
37191: ||' = NVL(mso.company_name,'||''''||NULL_CHAR||''''||') '
37192: ||' AND mlid.char3 = mso.organization_code'

Line 37220: INSERT INTO msc_local_id_demand

37216: AND ship_set_id is null;
37217:
37218: v_sql_stmt := 15.2;
37219: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
37220: INSERT INTO msc_local_id_demand
37221: (local_id,
37222: st_transaction_id,
37223: instance_id,
37224: entity_name,

Line 37262: ||' FROM msc_local_id_demand mlid'

37258: v_sql_stmt := 15.4;
37259: lv_sql_stmt :=
37260: 'UPDATE msc_st_sales_orders mso '
37261: ||' SET ship_set_id = (SELECT local_id'
37262: ||' FROM msc_local_id_demand mlid'
37263: ||' WHERE mlid.char1 = mso.sr_instance_code'
37264: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
37265: ||' = NVL(mso.company_name,'||''''||NULL_CHAR||''''||') '
37266: ||' AND mlid.char3 = mso.organization_code'

Line 37290: ||' FROM msc_local_id_demand mlid'

37286:
37287: lv_sql_stmt :=
37288: 'UPDATE msc_st_sales_orders mso '
37289: ||' SET arrival_set_id = (SELECT local_id'
37290: ||' FROM msc_local_id_demand mlid'
37291: ||' WHERE mlid.char1 = mso.sr_instance_code'
37292: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
37293: ||' = NVL(mso.company_name,'||''''||NULL_CHAR||''''||') '
37294: ||' AND mlid.char3 = mso.organization_code'

Line 37322: INSERT INTO msc_local_id_demand

37318: AND arrival_set_id is null;
37319:
37320: v_sql_stmt := 16.2;
37321: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
37322: INSERT INTO msc_local_id_demand
37323: (local_id,
37324: st_transaction_id,
37325: instance_id,
37326: entity_name,

Line 37364: ||' FROM msc_local_id_demand mlid'

37360: v_sql_stmt := 16.4;
37361: lv_sql_stmt :=
37362: 'UPDATE msc_st_sales_orders mso '
37363: ||' SET arrival_set_id = (SELECT local_id'
37364: ||' FROM msc_local_id_demand mlid'
37365: ||' WHERE mlid.char1 = mso.sr_instance_code'
37366: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
37367: ||' = NVL(mso.company_name,'||''''||NULL_CHAR||''''||') '
37368: ||' AND mlid.char3 = mso.organization_code'

Line 38127: ||' FROM msc_local_id_demand mlid'

38123: v_sql_stmt := 5.0;
38124: lv_sql_stmt :=
38125: 'UPDATE msc_st_reservations msr '
38126: ||' SET disposition_id = (SELECT local_id'
38127: ||' FROM msc_local_id_demand mlid'
38128: ||' WHERE mlid.char1 = msr.sr_instance_code'
38129: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
38130: ||' = NVL(msr.company_name,'||''''||NULL_CHAR||''''||') '
38131: ||' AND mlid.char3 = msr.organization_code'

Line 38151: ||' FROM msc_local_id_demand mlid'

38147: v_sql_stmt := 5.1;
38148: lv_sql_stmt :=
38149: 'UPDATE msc_st_reservations msr '
38150: ||' SET disposition_id = (SELECT local_id'
38151: ||' FROM msc_local_id_demand mlid'
38152: ||' WHERE mlid.char1 = msr.sr_instance_code'
38153: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
38154: ||' = NVL(msr.company_name,'||''''||NULL_CHAR||''''||') '
38155: ||' AND mlid.char3 = msr.organization_code'

Line 38313: ||' FROM msc_local_id_demand mlid'

38309: v_sql_stmt := 06;
38310: lv_sql_stmt :=
38311: 'UPDATE msc_st_reservations msr '
38312: ||' SET parent_demand_id = (SELECT local_id'
38313: ||' FROM msc_local_id_demand mlid'
38314: ||' WHERE mlid.char1 = msr.sr_instance_code'
38315: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
38316: ||' = NVL(msr.company_name,'||''''||NULL_CHAR||''''||') '
38317: ||' AND mlid.char3 = msr.organization_code'

Line 39000: ||' FROM msc_local_id_demand mlid'

38996: v_sql_stmt := 08;
38997: lv_sql_stmt :=
38998: 'UPDATE msc_st_demands msd '
38999: ||' SET disposition_id = (SELECT local_id'
39000: ||' FROM msc_local_id_demand mlid'
39001: ||' WHERE mlid.char1 = msd.sr_instance_code'
39002: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
39003: ||' = NVL(msd.company_name,'||''''||NULL_CHAR||''''||') '
39004: ||' AND mlid.char3 = msd.organization_code'

Line 39059: ||' FROM msc_local_id_demand mlid'

39055: v_sql_stmt := 10;
39056: lv_sql_stmt :=
39057: 'UPDATE msc_st_demands msd '
39058: ||' SET sales_order_line_id = (SELECT local_id'
39059: ||' FROM msc_local_id_demand mlid'
39060: ||' WHERE mlid.char1 = msd.sr_instance_code'
39061: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '
39062: ||' = NVL(msd.company_name,'||''''||NULL_CHAR||''''||') '
39063: ||' AND mlid.char3 = msd.organization_code'

Line 39618: INSERT INTO msc_local_id_demand

39614: WHERE rowid = lb_rowid(j);
39615:
39616: v_sql_stmt := 16;
39617: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
39618: INSERT INTO msc_local_id_demand
39619: (local_id,
39620: st_transaction_id,
39621: instance_id,
39622: entity_name,

Line 39693: INSERT INTO msc_local_id_demand

39689: WHERE rowid = lb_rowid(j);
39690:
39691: v_sql_stmt := 18;
39692: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
39693: INSERT INTO msc_local_id_demand
39694: (local_id,
39695: st_transaction_id,
39696: instance_id,
39697: entity_name,