VIEW: APPS.IGI_AR_SYSTEM_OPTIONS_V

Source

View Text - Preformatted

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.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.dunning_receivables_trx_id, decode(iaso.dunning_receivables_trx_id, NULL, NULL, art.name), iaso.org_id, iaso.rowid FROM ar_receivables_trx_all art, igi_ar_system_options iaso WHERE 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 iaso.org_id = art.org_id

View Text - HTML Formatted

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.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.DUNNING_RECEIVABLES_TRX_ID
, DECODE(IASO.DUNNING_RECEIVABLES_TRX_ID
, NULL
, NULL
, ART.NAME)
, IASO.ORG_ID
, IASO.ROWID
FROM AR_RECEIVABLES_TRX_ALL ART
, IGI_AR_SYSTEM_OPTIONS IASO
WHERE 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 IASO.ORG_ID = ART.ORG_ID