VIEW: APPS.IGS_FI_CONTROL

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)