View: IGS_FI_CONTROL

View Text

SELECT ROWID
, REC_INSTALLED
, LAST_ACCOUNT_TRANS
, LAST_PAY_TERM_TRANS
, LAST_PAYMENT_TRANS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ACCOUNTING_METHOD
, INTERFACE_LINE_CONTEXT
, INTERFACE_LINE_ATTRIBUTE
, LOCKBOX_CONTEXT
, LOCKBOX_NUMBER_ATTRIBUTE
, NEXT_INVOICE_NUMBER
, CUST_TRX_TYPE_ID
, TERM_ID
, BATCH_SOURCE_ID
, SET_OF_BOOKS_ID
, REFUND_DR_GL_CCID
, REFUND_CR_GL_CCID
, REFUND_DR_ACCOUNT_CD
, REFUND_CR_ACCOUNT_CD
, REFUND_DT_ALIAS
, ORG_ID
, NULL
, FEE_CALC_MTHD_CODE
, AR_INT_ORG_ID
, PLANNED_CREDITS_IND
, REC_GL_CCID
, CASH_GL_CCID
, UNAPP_GL_CCID
, REC_ACCOUNT_CD
, REV_ACCOUNT_CD
, CASH_ACCOUNT_CD
, UNAPP_ACCOUNT_CD
, CONV_PROCESS_RUN_IND
, CURRENCY_CD
, RFND_DESTINATION
, AP_ORG_ID
, DFLT_SUPPLIER_SITE_NAME
, MANAGE_ACCOUNTS
, ACCT_CONV_FLAG
, NULL
, POST_WAIVER_GL_FLAG
, WAIVER_NOTIFY_FINAID_FLAG
FROM IGS_FI_CONTROL_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns