DBA Data[Home] [Help]

APPS.FND_DM_PRODUCTS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 9

  insert into FND_DM_PRODUCTS_TL (
    PRODUCT_ID,
    DISPLAY_NAME,
    PRODUCT_DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select
    M.PRODUCT_ID,
    M.DISPLAY_NAME,
    M.PRODUCT_DESCRIPTION,
    L.LANGUAGE_CODE,
    M.SOURCE_LANG
  from FND_DM_PRODUCTS_TL M, FND_LANGUAGES B, FND_LANGUAGES L
  where B.INSTALLED_FLAG = 'B'
  and L.INSTALLED_FLAG in ('I', 'B')
  and M.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from FND_DM_PRODUCTS_TL T
    where T.PRODUCT_ID = M.PRODUCT_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);