DBA Data[Home] [Help]

VIEW: APPS.FEM_DB_LINKS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.database_link, B.mig_wf_in_agent_in_linked_db, B.mig_wf_out_agent_in_local_db, T.DB_LINK_NAME, T.DESCRIPTION, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN from FEM_DB_LINKS_TL T, FEM_DB_LINKS_B B WHERE B.database_link = T.database_link and T.LANGUAGE = userenv('LANG')
View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.DATABASE_LINK
, B.MIG_WF_IN_AGENT_IN_LINKED_DB
, B.MIG_WF_OUT_AGENT_IN_LOCAL_DB
, T.DB_LINK_NAME
, T.DESCRIPTION
, B.OBJECT_VERSION_NUMBER
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM FEM_DB_LINKS_TL T
, FEM_DB_LINKS_B B
WHERE B.DATABASE_LINK = T.DATABASE_LINK
AND T.LANGUAGE = USERENV('LANG')