View: IGI_AR_SYSTEM_OPTIONS_V

Product:	IGI - Public Sector Financials International
Description:	View for the system options form based on IGI_AR_SYSTEM_OPTIONS view
Implementation/DBA Data:	APPS.IGI_AR_SYSTEM_OPTIONS_V

View Text

SELECT DISTINCT IASO.SET_OF_BOOKS_ID
, IASO.CREATED_BY
, IASO.CREATION_DATE
, IASO.LAST_UPDATED_BY
, IASO.LAST_UPDATE_DATE
, IASO.LAST_UPDATE_LOGIN
, IASO.ACCOUNTING_METHOD
, IASO.ARC_CASH_SOB_ID
, DECODE(IASO.ARC_CASH_SOB_ID
, NULL
, NULL
, GSOB2.NAME)
, GSOB.CHART_OF_ACCOUNTS_ID
, IASO.ARC_UNALLOC_REV_CCID
, IASO.RPI_HEADER_CONTEXT_CODE
, IASO.RPI_HEADER_CHARGE_ID
, IASO.RPI_HEADER_GENERATE_SEQ
, IASO.RPI_LINE_CONTEXT_CODE
, IASO.RPI_LINE_CHARGE_ID
, IASO.RPI_LINE_GENERATE_SEQ
, IASO.RPI_LINE_CHARGE_LINE_NUM
, IASO.RPI_LINE_PRICE_BREAK_NUM
, IASO.ARC_AUTO_GL_IMPORT_FLAG
, IASO.DUNNING_RECEIVABLES_TRX_ID
, DECODE(IASO.DUNNING_RECEIVABLES_TRX_ID
, NULL
, NULL
, ART.NAME)
, IASO.ARC_JE_SOURCE_NAME
, IASO.ORG_ID
, IASO.ROWID
FROM AR_RECEIVABLES_TRX ART
, GL_SETS_OF_BOOKS GSOB
, IGI_AR_SYSTEM_OPTIONS IASO
, GL_SETS_OF_BOOKS GSOB2
WHERE IASO.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID
AND DECODE(IASO.DUNNING_RECEIVABLES_TRX_ID
, NULL
, -1
, IASO.DUNNING_RECEIVABLES_TRX_ID ) = DECODE(IASO.DUNNING_RECEIVABLES_TRX_ID
, NULL
, -1
, ART.RECEIVABLES_TRX_ID )
AND NVL(IASO.ARC_CASH_SOB_ID
, IASO.SET_OF_BOOKS_ID) = GSOB2.SET_OF_BOOKS_ID

Columns