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_RPO_PRE_PROCESS dependencies on MSC_LOCAL_ID_SETUP

Line 1787: ||' FROM msc_local_id_setup mls'

1783: ||' NVL(mss.company_name,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '
1784: ||' AND mls.char1 = mss.sr_instance_code'
1785: ||' AND mls.entity_name = ''SCHEDULE_GROUP_ID'' ),'
1786: ||' line_id = (SELECT local_id'
1787: ||' FROM msc_local_id_setup mls'
1788: ||' WHERE mls.char4 = mss.line_code'
1789: ||' AND mls.char3 = mss.organization_code'
1790: ||' AND NVL(mls.char2, '||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') = '
1791: ||' NVL(mss.company_name,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '

Line 1795: ||' FROM msc_local_id_setup mls'

1791: ||' NVL(mss.company_name,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '
1792: ||' AND mls.char1 = mss.sr_instance_code'
1793: ||' AND mls.entity_name = ''LINE_ID''),'
1794: ||' operation_seq_num = (SELECT number1'
1795: ||' FROM msc_local_id_setup mls'
1796: ||' WHERE mls.char5 = mss.operation_seq_code'
1797: ||' AND mls.char4 = mss.routing_name'
1798: ||' AND NVL(mls.char6, '||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') = '
1799: ||' NVL(mss.alternate_routing_designator,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '

Line 1937: ||' FROM msc_local_id_setup mls'

1933:
1934: lv_sql_stmt :=
1935: 'UPDATE msc_st_supplies mss'
1936: ||' SET jump_op_seq_num = (SELECT number1'
1937: ||' FROM msc_local_id_setup mls'
1938: ||' WHERE NVL(mls.char5,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') = '
1939: ||' NVL(mss.jump_op_seq_code,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '
1940: ||' AND mls.char4 = mss.routing_name'
1941: ||' AND NVL(mls.char6, '||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') = '

Line 2940: ||' FROM msc_local_id_setup mlis'

2936: MSC_CL_PRE_PROCESS.v_sql_stmt := 12;
2937: lv_sql_stmt:=
2938: 'UPDATE msc_st_demands msd'
2939: ||' SET operation_seq_num= (SELECT number1'
2940: ||' FROM msc_local_id_setup mlis'
2941: ||' WHERE mlis.char1 = msd.sr_instance_code'
2942: ||' AND NVL(mlis.char2,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '
2943: ||' = NVL(msd.company_name,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '
2944: ||' AND mlis.char3 = msd.organization_code'

Line 3218: INSERT INTO msc_local_id_setup

3214: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
3215:
3216: -- Insert into the LID table
3217:
3218: INSERT INTO msc_local_id_setup
3219: (local_id,
3220: st_transaction_id,
3221: instance_id,
3222: entity_name,

Line 3280: ||' FROM msc_local_id_setup mlis'

3276: MSC_CL_PRE_PROCESS.v_sql_stmt := 12;
3277: lv_sql_stmt:=
3278: 'UPDATE msc_st_demands msd'
3279: ||' SET operation_seq_num= (SELECT number1'
3280: ||' FROM msc_local_id_setup mlis'
3281: ||' WHERE mlis.char1 = msd.sr_instance_code'
3282: ||' AND NVL(mlis.char2,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '
3283: ||' = NVL(msd.company_name,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '
3284: ||' AND mlis.char3 = msd.organization_code'