Product: | IGI - Public Sector Financials International |
---|---|
Description: | Based on GL_INTERFACE and GL_PERIOD_STATUSES |
Implementation/DBA Data: | APPS.IGI_BUD_GL_INTERFACE_V |
SELECT GLI.STATUS
, GLI.SET_OF_BOOKS_ID
, GLI.ACCOUNTING_DATE
, GLI.CURRENCY_CODE
, GLI.DATE_CREATED
, GLI.CREATED_BY
, GLI.ACTUAL_FLAG
, GLI.USER_JE_CATEGORY_NAME
, GLI.USER_JE_SOURCE_NAME
, GLI.CURRENCY_CONVERSION_DATE
, GLI.ENCUMBRANCE_TYPE_ID
, GLI.BUDGET_VERSION_ID
, GLI.USER_CURRENCY_CONVERSION_TYPE
, GLI.CURRENCY_CONVERSION_RATE
, GLI.SEGMENT1
, GLI.SEGMENT2
, GLI.SEGMENT3
, GLI.SEGMENT4
, GLI.SEGMENT5
, GLI.SEGMENT6
, GLI.SEGMENT7
, GLI.SEGMENT8
, GLI.SEGMENT9
, GLI.SEGMENT10
, GLI.SEGMENT11
, GLI.SEGMENT12
, GLI.SEGMENT13
, GLI.SEGMENT14
, GLI.SEGMENT15
, GLI.SEGMENT16
, GLI.SEGMENT17
, GLI.SEGMENT18
, GLI.SEGMENT19
, GLI.SEGMENT20
, GLI.SEGMENT21
, GLI.SEGMENT22
, GLI.SEGMENT23
, GLI.SEGMENT24
, GLI.SEGMENT25
, GLI.SEGMENT26
, GLI.SEGMENT27
, GLI.SEGMENT28
, GLI.SEGMENT29
, GLI.SEGMENT30
, GLI.ENTERED_DR
, GLI.ENTERED_CR
, GLI.ACCOUNTED_DR
, GLI.ACCOUNTED_CR
, GLI.TRANSACTION_DATE
, GLI.REFERENCE1
, GLI.REFERENCE2
, GLI.REFERENCE3
, GLI.REFERENCE4
, GLI.REFERENCE5
, GLI.REFERENCE6
, GLI.REFERENCE7
, GLI.REFERENCE8
, GLI.REFERENCE9
, GLI.REFERENCE10
, GLI.REFERENCE11
, GLI.REFERENCE12
, GLI.REFERENCE13
, GLI.REFERENCE14
, GLI.REFERENCE15
, GLI.REFERENCE16
, GLI.REFERENCE17
, GLI.REFERENCE18
, GLI.REFERENCE19
, GLI.REFERENCE20
, GLI.REFERENCE21
, GLI.REFERENCE22
, GLI.REFERENCE23
, GLI.REFERENCE24
, GLI.REFERENCE25
, GLI.REFERENCE26
, GLI.REFERENCE27
, GLI.REFERENCE28
, GLI.REFERENCE29
, GLI.REFERENCE30
, GLI.JE_BATCH_ID
, GLI.PERIOD_NAME
, GLI.JE_HEADER_ID
, GLI.JE_LINE_NUM
, GLI.CHART_OF_ACCOUNTS_ID
, GLI.FUNCTIONAL_CURRENCY_CODE
, GLI.CODE_COMBINATION_ID
, GLI.DATE_CREATED_IN_GL
, GLI.WARNING_CODE
, GLI.STATUS_DESCRIPTION
, GLI.STAT_AMOUNT
, GLI.GROUP_ID
, GLI.REQUEST_ID
, GLI.SUBLEDGER_DOC_SEQUENCE_ID
, GLI.SUBLEDGER_DOC_SEQUENCE_VALUE
, GLI.ATTRIBUTE1
, GLI.ATTRIBUTE2
, GLI.ATTRIBUTE3
, GLI.ATTRIBUTE4
, GLI.ATTRIBUTE5
, GLI.ATTRIBUTE6
, GLI.ATTRIBUTE7
, GLI.ATTRIBUTE8
, GLI.ATTRIBUTE9
, GLI.ATTRIBUTE10
, GLI.ATTRIBUTE11
, GLI.ATTRIBUTE12
, GLI.ATTRIBUTE13
, GLI.ATTRIBUTE14
, GLI.ATTRIBUTE15
, GLI.ATTRIBUTE16
, GLI.ATTRIBUTE17
, GLI.ATTRIBUTE18
, GLI.ATTRIBUTE19
, GLI.ATTRIBUTE20
, GLI.CONTEXT
, GLI.CONTEXT2
, GLI.INVOICE_DATE
, GLI.TAX_CODE
, GLI.INVOICE_IDENTIFIER
, GLI.INVOICE_AMOUNT
, GLI.CONTEXT3
, GLI.USSGL_TRANSACTION_CODE
, GLI.DESCR_FLEX_ERROR_MESSAGE
, GLI.JGZZ_RECON_REF
, NVL(GLI.ACCOUNTED_DR
, 0) - NVL(GLI.ACCOUNTED_CR
, 0) START_BUDGET
, NVL(GLI.ENTERED_DR
, 0) - NVL(GLI.ENTERED_CR
, 0) BUDGET_CHANGE
, NVL(GLI.ACCOUNTED_DR
, 0) - NVL(GLI.ACCOUNTED_CR
, 0) + NVL(GLI.ENTERED_DR
, 0) - NVL(GLI.ENTERED_CR
, 0) RESULTING_BUDGET
, GLPS.PERIOD_NUM
FROM GL_INTERFACE GLI
, GL_PERIOD_STATUSES GLPS
WHERE GLI.PERIOD_NAME = GLPS.PERIOD_NAME
AND GLI.SET_OF_BOOKS_ID = GLPS.SET_OF_BOOKS_ID
AND GLPS.APPLICATION_ID = (SELECT APPLICATION_ID
FROM FND_APPLICATION
WHERE APPLICATION_SHORT_NAME = 'SQLGL')