APPS.MSC_CL_PRE_PROCESS dependencies on MSC_LOCAL_ID_ITEM

Line 1825: msc_analyse_tables_pk.analyse_table( 'MSC_LOCAL_ID_ITEM', v_instance_id, -1);

1821: WHEN OTHERS THEN
1822: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SYSTEM_ITEMS_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1823: END;
1824:
1825: msc_analyse_tables_pk.analyse_table( 'MSC_LOCAL_ID_ITEM', v_instance_id, -1);
1826:
1827: END IF;
1828:
1829: IF v_mat_sup_enabled = SYS_YES THEN

Line 17166: ||' FROM msc_local_id_item mli'

17162: --Update inventory_item_id
17163: lv_sql_stmt :=
17164: 'UPDATE msc_st_uom_class_conversions mcc '
17165: ||' SET inventory_item_id = (SELECT local_id'
17166: ||' FROM msc_local_id_item mli'
17167: ||' WHERE mli.char1 = mcc.sr_instance_code '
17168: ||' AND NVL(mli.char2, '||''''||NULL_CHAR||''''||')='
17169: ||' NVL(mcc.company_name,'||''''||NULL_CHAR||''''||')'
17170: ||' AND mli.char4 = mcc.item_name'

Line 17693: ||' FROM msc_local_id_item mli'

17689: --Update inventory_item_id
17690: lv_sql_stmt :=
17691: 'UPDATE msc_st_uom_conversions mcc '
17692: ||' SET inventory_item_id = (SELECT local_id'
17693: ||' FROM msc_local_id_item mli'
17694: ||' WHERE mli.char1 = mcc.sr_instance_code '
17695: ||' AND NVL(mli.char2, '||''''||NULL_CHAR||''''||')='
17696: ||' NVL(mcc.company_name,'||''''||NULL_CHAR||''''||')'
17697: ||' AND mli.char4 = mcc.item_name'

Line 18989: ||' FROM msc_local_id_item mli'

18985: v_sql_stmt := 08;
18986: lv_sql_stmt :=
18987: 'UPDATE msc_st_system_items msi'
18988: ||' SET sr_inventory_item_id = (SELECT local_id'
18989: ||' FROM msc_local_id_item mli'
18990: ||' WHERE mli.char1 = msi.sr_instance_code '
18991: ||' AND NVL(mli.char2, '||''''||NULL_CHAR||''''||')='
18992: ||' NVL(msi.company_name,'||''''||NULL_CHAR||''''||')'
18993: ||' AND mli.char4 = msi.item_name'

Line 19494: INSERT INTO msc_local_id_item

19490:
19491: v_sql_stmt := 10;
19492:
19493: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
19494: INSERT INTO msc_local_id_item
19495: (local_id,
19496: st_transaction_id,
19497: instance_id,
19498: entity_name,

Line 19540: ||' FROM msc_local_id_item mli'

19536: v_sql_stmt := 17;
19537: lv_sql_stmt :=
19538: 'UPDATE msc_st_system_items msi'
19539: ||' SET sr_inventory_item_id = (SELECT local_id'
19540: ||' FROM msc_local_id_item mli'
19541: ||' WHERE mli.char1 = msi.sr_instance_code '
19542: ||' AND NVL(mli.char2, '||''''||NULL_CHAR||''''||')='
19543: ||' NVL(msi.company_name,'||''''||NULL_CHAR||''''||')'
19544: ||' AND mli.char4 = msi.item_name'

Line 19563: 'INSERT INTO msc_local_id_item '

19559: lv_batch_id;
19560:
19561: v_sql_stmt := 18;
19562: lv_sql_stmt :=
19563: 'INSERT INTO msc_local_id_item '
19564: ||' (local_id,'
19565: ||' st_transaction_id,'
19566: ||' instance_id,'
19567: ||' entity_name,'

Line 19601: ||' FROM msc_local_id_item'

19597: ||' creation_date,'
19598: ||' created_by '
19599: ||' FROM msc_st_system_items'
19600: ||' WHERE NOT EXISTS( SELECT 1'
19601: ||' FROM msc_local_id_item'
19602: ||' WHERE char1 = sr_instance_code '
19603: ||' AND NVL(char2, '||''''||NULL_CHAR||''''||')='
19604: ||' NVL(company_name,'||''''||NULL_CHAR||''''||')'
19605: ||' AND char3 = organization_code'

Line 51851: ||' FROM msc_local_id_item mli'

51847:
51848: lv_sql_stmt :=
51849: 'UPDATE msc_st_system_items msi'
51850: ||' SET product_family_id = (SELECT local_id'
51851: ||' FROM msc_local_id_item mli'
51852: ||' WHERE mli.char1 = msi.sr_instance_code '
51853: ||' AND NVL(mli.char2, '||''''||NULL_CHAR||''''||')='
51854: ||' NVL(msi.company_name,'||''''||NULL_CHAR||''''||')'
51855: ||' AND mli.char4 = msi.product_family_item_name'

Line 51873: ||' FROM msc_local_id_item mli'

51869:
51870: lv_sql_stmt :=
51871: 'UPDATE msc_st_system_items msi'
51872: ||' SET BASE_ITEM_ID = (SELECT local_id'
51873: ||' FROM msc_local_id_item mli'
51874: ||' WHERE mli.char1 = msi.sr_instance_code '
51875: ||' AND NVL(mli.char2, '||''''||NULL_CHAR||''''||')='
51876: ||' NVL(msi.company_name,'||''''||NULL_CHAR||''''||')'
51877: ||' AND mli.char4 = msi.BASE_ITEM_NAME'