APPS.MSC_CL_PRE_PROCESS dependencies on MSC_LOCAL_ID_ITEM

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

1829: WHEN OTHERS THEN
1830: 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));
1831: END;
1832:
1833: msc_analyse_tables_pk.analyse_table( 'MSC_LOCAL_ID_ITEM', v_instance_id, -1);
1834:
1835: END IF;
1836:
1837: IF v_mat_sup_enabled = SYS_YES THEN

Line 20653: ||' FROM msc_local_id_item mli'

20649: --Update inventory_item_id
20650: lv_sql_stmt :=
20651: 'UPDATE msc_st_uom_class_conversions mcc '
20652: ||' SET inventory_item_id = (SELECT local_id'
20653: ||' FROM msc_local_id_item mli'
20654: ||' WHERE mli.char1 = mcc.sr_instance_code '
20655: ||' AND NVL(mli.char2, '||''''||NULL_CHAR||''''||')='
20656: ||' NVL(mcc.company_name,'||''''||NULL_CHAR||''''||')'
20657: ||' AND mli.char4 = mcc.item_name'

Line 21180: ||' FROM msc_local_id_item mli'

21176: --Update inventory_item_id
21177: lv_sql_stmt :=
21178: 'UPDATE msc_st_uom_conversions mcc '
21179: ||' SET inventory_item_id = (SELECT local_id'
21180: ||' FROM msc_local_id_item mli'
21181: ||' WHERE mli.char1 = mcc.sr_instance_code '
21182: ||' AND NVL(mli.char2, '||''''||NULL_CHAR||''''||')='
21183: ||' NVL(mcc.company_name,'||''''||NULL_CHAR||''''||')'
21184: ||' AND mli.char4 = mcc.item_name'

Line 22478: ||' FROM msc_local_id_item mli'

22474: v_sql_stmt := 08;
22475: lv_sql_stmt :=
22476: 'UPDATE msc_st_system_items msi'
22477: ||' SET sr_inventory_item_id = (SELECT local_id'
22478: ||' FROM msc_local_id_item mli'
22479: ||' WHERE mli.char1 = msi.sr_instance_code '
22480: ||' AND NVL(mli.char2, '||''''||NULL_CHAR||''''||')='
22481: ||' NVL(msi.company_name,'||''''||NULL_CHAR||''''||')'
22482: ||' AND mli.char4 = msi.item_name'

Line 22983: INSERT INTO msc_local_id_item

22979:
22980: v_sql_stmt := 10;
22981:
22982: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
22983: INSERT INTO msc_local_id_item
22984: (local_id,
22985: st_transaction_id,
22986: instance_id,
22987: entity_name,

Line 23029: ||' FROM msc_local_id_item mli'

23025: v_sql_stmt := 17;
23026: lv_sql_stmt :=
23027: 'UPDATE msc_st_system_items msi'
23028: ||' SET sr_inventory_item_id = (SELECT local_id'
23029: ||' FROM msc_local_id_item mli'
23030: ||' WHERE mli.char1 = msi.sr_instance_code '
23031: ||' AND NVL(mli.char2, '||''''||NULL_CHAR||''''||')='
23032: ||' NVL(msi.company_name,'||''''||NULL_CHAR||''''||')'
23033: ||' AND mli.char4 = msi.item_name'

Line 23052: 'INSERT INTO msc_local_id_item '

23048: lv_batch_id;
23049:
23050: v_sql_stmt := 18;
23051: lv_sql_stmt :=
23052: 'INSERT INTO msc_local_id_item '
23053: ||' (local_id,'
23054: ||' st_transaction_id,'
23055: ||' instance_id,'
23056: ||' entity_name,'

Line 23090: ||' FROM msc_local_id_item'

23086: ||' creation_date,'
23087: ||' created_by '
23088: ||' FROM msc_st_system_items'
23089: ||' WHERE NOT EXISTS( SELECT 1'
23090: ||' FROM msc_local_id_item'
23091: ||' WHERE char1 = sr_instance_code '
23092: ||' AND NVL(char2, '||''''||NULL_CHAR||''''||')='
23093: ||' NVL(company_name,'||''''||NULL_CHAR||''''||')'
23094: ||' AND char3 = organization_code'

Line 56875: ||' FROM msc_local_id_item mli'

56871:
56872: lv_sql_stmt :=
56873: 'UPDATE msc_st_system_items msi'
56874: ||' SET product_family_id = (SELECT local_id'
56875: ||' FROM msc_local_id_item mli'
56876: ||' WHERE mli.char1 = msi.sr_instance_code '
56877: ||' AND NVL(mli.char2, '||''''||NULL_CHAR||''''||')='
56878: ||' NVL(msi.company_name,'||''''||NULL_CHAR||''''||')'
56879: ||' AND mli.char4 = msi.product_family_item_name'

Line 56897: ||' FROM msc_local_id_item mli'

56893:
56894: lv_sql_stmt :=
56895: 'UPDATE msc_st_system_items msi'
56896: ||' SET BASE_ITEM_ID = (SELECT local_id'
56897: ||' FROM msc_local_id_item mli'
56898: ||' WHERE mli.char1 = msi.sr_instance_code '
56899: ||' AND NVL(mli.char2, '||''''||NULL_CHAR||''''||')='
56900: ||' NVL(msi.company_name,'||''''||NULL_CHAR||''''||')'
56901: ||' AND mli.char4 = msi.BASE_ITEM_NAME'