eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_FI_POSTING_INT

Product:	IGS - Student System (Obsolete)
Description:	This view is created to filter multi-org from table IGS_FI_POSTING_INT_ALL .
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ROWID
, POSTING_ID
, BATCH_NAME
, ACCOUNTING_DATE
, TRANSACTION_DATE
, CURRENCY_CD
, DR_ACCOUNT_CD
, CR_ACCOUNT_CD
, DR_GL_CODE_CCID
, CR_GL_CODE_CCID
, AMOUNT
, SOURCE_TRANSACTION_ID
, SOURCE_TRANSACTION_TYPE
, STATUS
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
, ORIG_APPL_FEE_REF
, POSTING_CONTROL_ID
FROM IGS_FI_POSTING_INT_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

Name
ROW_ID
POSTING_ID
BATCH_NAME
ACCOUNTING_DATE
TRANSACTION_DATE
CURRENCY_CD
DR_ACCOUNT_CD
CR_ACCOUNT_CD
DR_GL_CODE_CCID
CR_GL_CODE_CCID
AMOUNT
SOURCE_TRANSACTION_ID
SOURCE_TRANSACTION_TYPE
STATUS
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ORG_ID
ORIG_APPL_FEE_REF
POSTING_CONTROL_ID