Product: | IGI - Public Sector Financials International |
---|---|
Description: | Based on IGI_COM_SOB_LINK and GL_SETS_OF_BOOKS |
Implementation/DBA Data: | APPS.IGI_COM_SOB_LINK_V |
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 SOURCE
, IGI_COM_SOB_LINK LINK
, GL_SETS_OF_BOOKS 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