[Home] [Help]
1713: -- MK Need to get from Change Context
1714: l_change_b_table_name := 'EGO_MTL_SY_ITEMS_CHG_B' ;
1715: l_change_tl_table_name := 'EGO_MTL_SY_ITEMS_CHG_TL' ;
1716: -- l_production_b_table_name := 'MTL_SYSTEM_ITEMS_B' ;
1717: l_production_tl_table_name := 'MTL_SYSTEM_ITEMS_TL' ;
1718:
1719: ---------------------------------------------------------------
1720: -- Next, we add to the lists the rest of the columns that we --
1721: -- either want to get explicitly or don't want to get at all --
1759: l_tl_chg_cols_list := Get_Table_Columns_List(
1760: -- p_application_id => G_EGO_APPL_ID
1761: p_application_id => G_ITEM_APPL_ID
1762: -- ,p_from_table_name => l_change_tl_table_name
1763: ,p_from_table_name => 'MTL_SYSTEM_ITEMS_TL'
1764: ,p_from_cols_to_exclude_list => l_cols_to_exclude_list
1765: ,p_from_table_alias_prefix => 'TL'
1766: ,p_cast_date_cols_to_char => TRUE
1767: );
1791: l_history_tl_chg_cols_list := Get_Table_Columns_List(
1792: -- p_application_id => G_EGO_APPL_ID
1793: p_application_id => G_ITEM_APPL_ID
1794: -- ,p_from_table_name => l_change_tl_table_name
1795: ,p_from_table_name => 'MTL_SYSTEM_ITEMS_TL'
1796: ,p_from_table_alias_prefix => 'CT'
1797: ,p_from_cols_to_exclude_list => l_cols_to_exclude_list
1798: );
1799:
5725: -- Developer: CHECHAND - Bug# 9742219 - Begin
5726: -- Description: Implementation of ECO doesnot refelect regenerated item description at master org, in all organization item entries.
5727: -- Synching description of all org items to the description of the master item.
5728: BEGIN
5729: FOR rec IN (SELECT inventory_item_id, description , LANGUAGE FROM mtl_system_items_tl WHERE
5730: inventory_item_id = (SELECT DISTINCT INVENTORY_ITEM_ID FROM EGO_ITEMS_ATTRS_CHANGES_B WHERE change_line_id = p_change_line_id)
5731: AND ORGANIZATION_ID = (SELECT DISTINCT ORGANIZATION_ID FROM EGO_ITEMS_ATTRS_CHANGES_B WHERE change_line_id = p_change_line_id))
5732: LOOP
5733: Write_Debug('Synching Item description at all organization levels for item: ' || rec.inventory_item_id );
5731: AND ORGANIZATION_ID = (SELECT DISTINCT ORGANIZATION_ID FROM EGO_ITEMS_ATTRS_CHANGES_B WHERE change_line_id = p_change_line_id))
5732: LOOP
5733: Write_Debug('Synching Item description at all organization levels for item: ' || rec.inventory_item_id );
5734: Write_Debug('New Description: ' || rec.description );
5735: UPDATE mtl_system_items_tl
5736: SET description = rec.description
5737: WHERE inventory_item_id = rec.inventory_item_id
5738: AND LANGUAGE = rec.LANGUAGE;
5739: