VIEW: APPS.IGI_COM_SOB_LINK_V

Source

View Text - Preformatted

SELECT link.ROWID ROW_ID, source.NAME SOURCE_SOB_NAME, target.NAME TARGET_SOB_NAME, link.ENCUMBRANCE_FLAG ENCUMBRANCE_FLAG, link.SOURCE_SET_OF_BOOKS_ID SOURCE_SOB_ID, link.TARGET_SET_OF_BOOKS_ID TARGET_SOB_ID, link.CREATION_DATE CREATION_DATE, link.CREATED_BY CREATED_BY, link.LAST_UPDATE_DATE LAST_UPDATE_DATE, link.LAST_UPDATED_BY LAST_UPDATED_BY, link.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, source.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID, source.CURRENCY_CODE CURRENCY_CODE, source.PERIOD_SET_NAME PERIOD_SET_NAME FROM GL_SETS_OF_BOOKS_11I SOURCE,IGI_COM_SOB_LINK LINK,GL_SETS_OF_BOOKS_11I TARGET,IGI_COM_SOB_LINK LINK2 WHERE target.SET_OF_BOOKS_ID = link.TARGET_SET_OF_BOOKS_ID AND source.SET_OF_BOOKS_ID = link.SOURCE_SET_OF_BOOKS_ID AND link2.SOURCE_SET_OF_BOOKS_ID = link.TARGET_SET_OF_BOOKS_ID

View Text - HTML Formatted

SELECT LINK.ROWID ROW_ID
, SOURCE.NAME SOURCE_SOB_NAME
, TARGET.NAME TARGET_SOB_NAME
, LINK.ENCUMBRANCE_FLAG ENCUMBRANCE_FLAG
, LINK.SOURCE_SET_OF_BOOKS_ID SOURCE_SOB_ID
, LINK.TARGET_SET_OF_BOOKS_ID TARGET_SOB_ID
, LINK.CREATION_DATE CREATION_DATE
, LINK.CREATED_BY CREATED_BY
, LINK.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LINK.LAST_UPDATED_BY LAST_UPDATED_BY
, LINK.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SOURCE.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, SOURCE.CURRENCY_CODE CURRENCY_CODE
, SOURCE.PERIOD_SET_NAME PERIOD_SET_NAME
FROM GL_SETS_OF_BOOKS_11I SOURCE
, IGI_COM_SOB_LINK LINK
, GL_SETS_OF_BOOKS_11I TARGET
, IGI_COM_SOB_LINK LINK2
WHERE TARGET.SET_OF_BOOKS_ID = LINK.TARGET_SET_OF_BOOKS_ID
AND SOURCE.SET_OF_BOOKS_ID = LINK.SOURCE_SET_OF_BOOKS_ID
AND LINK2.SOURCE_SET_OF_BOOKS_ID = LINK.TARGET_SET_OF_BOOKS_ID