APPS.INV_OPM_ITEM_MIGRATION dependencies on GMI_OBSOLETE_ITEM_COLUMNS

Line 1814: FROM gmi_obsolete_item_columns

1810: -- Check if the obsolete column is already mapped / migrated.
1811: BEGIN
1812: SELECT flexfield_column_name, migrated_ind
1813: INTO l_flexfield_column_name, l_migrated_ind
1814: FROM gmi_obsolete_item_columns
1815: WHERE
1816: obsolete_column_name = p_obsolete_column_name AND
1817: migrated_ind = 1;
1818:

Line 1992: UPDATE gmi_obsolete_item_columns

1988:
1989: l_migrate_count := l_migrate_count + 1;
1990:
1991: -- Update the mig table.
1992: UPDATE gmi_obsolete_item_columns
1993: SET
1994: migrated_ind = 1,
1995: last_update_date = sysdate,
1996: last_updated_by = 0

Line 2001: INSERT INTO gmi_obsolete_item_columns(

1997: WHERE
1998: obsolete_column_name = p_obsolete_column_name;
1999:
2000: IF SQL%ROWCOUNT = 0 THEN
2001: INSERT INTO gmi_obsolete_item_columns(
2002: obsolete_column_name,
2003: flexfield_column_name,
2004: migrated_ind,
2005: creation_date,