APPS.INV_OPM_ITEM_MIGRATION dependencies on GMI_OBSOLETE_ITEM_COLUMNS

Line 1716: FROM gmi_obsolete_item_columns

1712: -- Check if the obsolete column is already mapped / migrated.
1713: BEGIN
1714: SELECT flexfield_column_name, migrated_ind
1715: INTO l_flexfield_column_name, l_migrated_ind
1716: FROM gmi_obsolete_item_columns
1717: WHERE
1718: obsolete_column_name = p_obsolete_column_name AND
1719: migrated_ind = 1;
1720:

Line 1894: UPDATE gmi_obsolete_item_columns

1890:
1891: l_migrate_count := l_migrate_count + 1;
1892:
1893: -- Update the mig table.
1894: UPDATE gmi_obsolete_item_columns
1895: SET
1896: migrated_ind = 1,
1897: last_update_date = sysdate,
1898: last_updated_by = 0

Line 1903: INSERT INTO gmi_obsolete_item_columns(

1899: WHERE
1900: obsolete_column_name = p_obsolete_column_name;
1901:
1902: IF SQL%ROWCOUNT = 0 THEN
1903: INSERT INTO gmi_obsolete_item_columns(
1904: obsolete_column_name,
1905: flexfield_column_name,
1906: migrated_ind,
1907: creation_date,