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 969: ||' FROM msc_local_id_supply mls'

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

Line 1748: ||' FROM msc_local_id_supply mls'

1744: MSC_CL_PRE_PROCESS.v_sql_stmt := 09;
1745: lv_sql_stmt :=
1746: 'UPDATE msc_st_supplies mss'
1747: ||' SET schedule_group_id = (SELECT local_id'
1748: ||' FROM msc_local_id_supply mls'
1749: ||' WHERE mls.char4 = mss.schedule_group_name'
1750: ||' AND mls.char3 = mss.organization_code'
1751: ||' AND NVL(mls.char2, '||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') = '
1752: ||' NVL(mss.company_name,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '

Line 1831: ||' FROM msc_local_id_supply mls'

1827: MSC_CL_PRE_PROCESS.v_sql_stmt := 10;
1828: lv_sql_stmt :=
1829: 'UPDATE msc_st_supplies mss'
1830: ||' SET wip_entity_id = (SELECT local_id'
1831: ||' FROM msc_local_id_supply mls'
1832: ||' WHERE mls.char4 = mss.wip_entity_name'
1833: ||' AND mls.char3 = mss.organization_code'
1834: ||' AND NVL(mls.char2, '||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') = '
1835: ||' NVL(mss.company_name,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '

Line 1960: INSERT INTO msc_local_id_supply

1956: WHERE rowid = lb_rowid(j);
1957:
1958: MSC_CL_PRE_PROCESS.v_sql_stmt := 13;
1959: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1960: INSERT INTO msc_local_id_supply
1961: (local_id,
1962: st_transaction_id,
1963: instance_id,
1964: entity_name,

Line 2019: INSERT INTO msc_local_id_supply

2015: WHERE rowid = lb_rowid(j);
2016:
2017: MSC_CL_PRE_PROCESS.v_sql_stmt := 15;
2018: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
2019: INSERT INTO msc_local_id_supply
2020: (local_id,
2021: st_transaction_id,
2022: instance_id,
2023: entity_name,

Line 2145: ||' FROM msc_local_id_supply mls'

2141: MSC_CL_PRE_PROCESS.v_sql_stmt := 17;
2142: lv_sql_stmt :=
2143: 'UPDATE msc_st_supplies mss '
2144: ||' SET schedule_group_id = (SELECT local_id'
2145: ||' FROM msc_local_id_supply mls'
2146: ||' WHERE mls.char4 = mss.schedule_group_name'
2147: ||' AND mls.char3 = mss.organization_code'
2148: ||' AND NVL(mls.char2, '||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') = '
2149: ||' NVL(mss.company_name,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '

Line 2575: ||' FROM msc_local_id_supply mlid'

2571:
2572: lv_sql_stmt :=
2573: 'UPDATE msc_st_demands msd'
2574: ||' SET wip_entity_id = ( SELECT local_id '
2575: ||' FROM msc_local_id_supply mlid'
2576: ||' WHERE mlid.char1 = msd.sr_instance_code'
2577: ||' AND NVL(mlid.char2,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '
2578: ||' = NVL(msd.company_name,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '
2579: ||' AND mlid.char3 = msd.organization_code'