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 1756: ||' FROM msc_local_id_setup mls'

1752: ||' NVL(mss.company_name,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '
1753: ||' AND mls.char1 = mss.sr_instance_code'
1754: ||' AND mls.entity_name = ''SCHEDULE_GROUP_ID'' ),'
1755: ||' line_id = (SELECT local_id'
1756: ||' FROM msc_local_id_setup mls'
1757: ||' WHERE mls.char4 = mss.line_code'
1758: ||' AND mls.char3 = mss.organization_code'
1759: ||' AND NVL(mls.char2, '||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') = '
1760: ||' NVL(mss.company_name,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '

Line 1764: ||' FROM msc_local_id_setup mls'

1760: ||' NVL(mss.company_name,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '
1761: ||' AND mls.char1 = mss.sr_instance_code'
1762: ||' AND mls.entity_name = ''LINE_ID''),'
1763: ||' operation_seq_num = (SELECT number1'
1764: ||' FROM msc_local_id_setup mls'
1765: ||' WHERE mls.char5 = mss.operation_seq_code'
1766: ||' AND mls.char4 = mss.routing_name'
1767: ||' AND NVL(mls.char6, '||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') = '
1768: ||' NVL(mss.alternate_routing_designator,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '

Line 1906: ||' FROM msc_local_id_setup mls'

1902:
1903: lv_sql_stmt :=
1904: 'UPDATE msc_st_supplies mss'
1905: ||' SET jump_op_seq_num = (SELECT number1'
1906: ||' FROM msc_local_id_setup mls'
1907: ||' WHERE NVL(mls.char5,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') = '
1908: ||' NVL(mss.jump_op_seq_code,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '
1909: ||' AND mls.char4 = mss.routing_name'
1910: ||' AND NVL(mls.char6, '||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') = '

Line 2909: ||' FROM msc_local_id_setup mlis'

2905: MSC_CL_PRE_PROCESS.v_sql_stmt := 12;
2906: lv_sql_stmt:=
2907: 'UPDATE msc_st_demands msd'
2908: ||' SET operation_seq_num= (SELECT number1'
2909: ||' FROM msc_local_id_setup mlis'
2910: ||' WHERE mlis.char1 = msd.sr_instance_code'
2911: ||' AND NVL(mlis.char2,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '
2912: ||' = NVL(msd.company_name,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '
2913: ||' AND mlis.char3 = msd.organization_code'

Line 3187: INSERT INTO msc_local_id_setup

3183: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
3184:
3185: -- Insert into the LID table
3186:
3187: INSERT INTO msc_local_id_setup
3188: (local_id,
3189: st_transaction_id,
3190: instance_id,
3191: entity_name,

Line 3249: ||' FROM msc_local_id_setup mlis'

3245: MSC_CL_PRE_PROCESS.v_sql_stmt := 12;
3246: lv_sql_stmt:=
3247: 'UPDATE msc_st_demands msd'
3248: ||' SET operation_seq_num= (SELECT number1'
3249: ||' FROM msc_local_id_setup mlis'
3250: ||' WHERE mlis.char1 = msd.sr_instance_code'
3251: ||' AND NVL(mlis.char2,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '
3252: ||' = NVL(msd.company_name,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '
3253: ||' AND mlis.char3 = msd.organization_code'