APPS.MSC_CL_RPO_PRE_PROCESS dependencies on MSC_LOCAL_ID_SUPPLY

Line 380: ||' FROM msc_local_id_supply mls'

376: MSC_CL_PRE_PROCESS.v_sql_stmt := 09;
377: lv_sql_stmt :=
378: 'UPDATE msc_st_supplies mss'
379: ||' SET disposition_id = (SELECT local_id'
380: ||' FROM msc_local_id_supply mls'
381: ||' WHERE mls.char4 = mss.repair_number'
382: ||' AND mls.char3 = mss.organization_code'
383: ||' AND mls.char1 = mss.sr_instance_code'
384: ||' AND mls.entity_name = ''REPAIR_NUMBER'' )'

Line 483: INSERT INTO msc_local_id_supply

479: WHERE rowid = lb_rowid(j);
480:
481: MSC_CL_PRE_PROCESS.v_sql_stmt := 13;
482: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
483: INSERT INTO msc_local_id_supply
484: (local_id,
485: st_transaction_id,
486: instance_id,
487: entity_name,

Line 970: ||' FROM msc_local_id_supply mls'

966: MSC_CL_PRE_PROCESS.v_sql_stmt := 08;
967: lv_sql_stmt :=
968: 'UPDATE msc_st_demands msd'
969: ||' SET repair_line_id = (SELECT local_id'
970: ||' FROM msc_local_id_supply mls'
971: ||' WHERE mls.char4 = msd.wip_entity_name'
972: ||' AND mls.char3 = msd.organization_code'
973: ||' AND mls.char1 = msd.sr_instance_code'
974: ||' AND mls.entity_name = ''REPAIR_NUMBER'' )'

Line 1779: ||' FROM msc_local_id_supply mls'

1775: MSC_CL_PRE_PROCESS.v_sql_stmt := 09;
1776: lv_sql_stmt :=
1777: 'UPDATE msc_st_supplies mss'
1778: ||' SET schedule_group_id = (SELECT local_id'
1779: ||' FROM msc_local_id_supply mls'
1780: ||' WHERE mls.char4 = mss.schedule_group_name'
1781: ||' AND mls.char3 = mss.organization_code'
1782: ||' AND NVL(mls.char2, '||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') = '
1783: ||' NVL(mss.company_name,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '

Line 1862: ||' FROM msc_local_id_supply mls'

1858: MSC_CL_PRE_PROCESS.v_sql_stmt := 10;
1859: lv_sql_stmt :=
1860: 'UPDATE msc_st_supplies mss'
1861: ||' SET wip_entity_id = (SELECT local_id'
1862: ||' FROM msc_local_id_supply mls'
1863: ||' WHERE mls.char4 = mss.wip_entity_name'
1864: ||' AND mls.char3 = mss.organization_code'
1865: ||' AND NVL(mls.char2, '||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') = '
1866: ||' NVL(mss.company_name,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '

Line 1991: INSERT INTO msc_local_id_supply

1987: WHERE rowid = lb_rowid(j);
1988:
1989: MSC_CL_PRE_PROCESS.v_sql_stmt := 13;
1990: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1991: INSERT INTO msc_local_id_supply
1992: (local_id,
1993: st_transaction_id,
1994: instance_id,
1995: entity_name,

Line 2050: INSERT INTO msc_local_id_supply

2046: WHERE rowid = lb_rowid(j);
2047:
2048: MSC_CL_PRE_PROCESS.v_sql_stmt := 15;
2049: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
2050: INSERT INTO msc_local_id_supply
2051: (local_id,
2052: st_transaction_id,
2053: instance_id,
2054: entity_name,

Line 2176: ||' FROM msc_local_id_supply mls'

2172: MSC_CL_PRE_PROCESS.v_sql_stmt := 17;
2173: lv_sql_stmt :=
2174: 'UPDATE msc_st_supplies mss '
2175: ||' SET schedule_group_id = (SELECT local_id'
2176: ||' FROM msc_local_id_supply mls'
2177: ||' WHERE mls.char4 = mss.schedule_group_name'
2178: ||' AND mls.char3 = mss.organization_code'
2179: ||' AND NVL(mls.char2, '||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') = '
2180: ||' NVL(mss.company_name,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '

Line 2606: ||' FROM msc_local_id_supply mlid'

2602:
2603: lv_sql_stmt :=
2604: 'UPDATE msc_st_demands msd'
2605: ||' SET wip_entity_id = ( SELECT local_id '
2606: ||' FROM msc_local_id_supply mlid'
2607: ||' WHERE mlid.char1 = msd.sr_instance_code'
2608: ||' AND NVL(mlid.char2,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '
2609: ||' = NVL(msd.company_name,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '
2610: ||' AND mlid.char3 = msd.organization_code'