VIEW: APPS.IGCFV_CBC_BALANCES

Source

View Text - Preformatted

SELECT IGC_CBC_JE_LINES_BAL_PTD_V.ACTUAL_FLAG ACTUAL_FLAG, '_KF:SQLGL:GL#:GL_CODE_COMBINATIONS' "_KF:GL_ACCOUNT", IGC_CBC_JE_LINES_BAL_PTD_V.AMOUNT_TYPE AMOUNT_TYPE, IGC_CBC_JE_LINES_BAL_PTD_V.PERIOD_YEAR PERIOD_YEAR, IGC_CBC_JE_LINES_BAL_PTD_V.ENTERED_DR ENTERED_DR, IGC_CBC_JE_LINES_BAL_PTD_V.ENTERED_CR ENTERED_CR, IGC_CBC_JE_LINES_BAL_PTD_V.PERIOD_NAME PERIOD_NAME, IGC_CBC_JE_LINES_BAL_PTD_V.PERIOD_SET_NAME PERIOD_SET_NAME, IGC_CBC_JE_LINES_BAL_PTD_V.QUARTER_NUM QUARTER_NUMBER, IGC_CBC_JE_LINES_BAL_PTD_V.PERIOD_NUM PERIOD_NUMBER, IGC_CBC_JE_LINES_BAL_PTD_V.STATUS STATUS, IGC_CBC_JE_LINES_BAL_PTD_V.DETAIL_SUMMARY_CODE DETAIL_SUMMARY_CODE, IGC_CBC_JE_LINES_BAL_PTD_V.PTD_BALANCE PERIOD_TO_DATE_BALANCE, GL_SETS_OF_BOOKS.NAME SETS_OF_BOOKS_NAME, GL_SETS_OF_BOOKS.SHORT_NAME SETS_OF_BOOKS_SHORT_NAME, GL_BUDGET_VERSIONS.BUDGET_NAME BUDGET_NAME, GL_ENCUMBRANCE_TYPES.ENCUMBRANCE_TYPE ENCUMBRANCE_TYPE_NAME, IGC_CBC_JE_LINES_BAL_PTD_V.CURRENCY_CODE CURRENCY_CODE, IGC_CBC_JE_LINES_BAL_PTD_V.CODE_COMBINATION_ID CODE_COMBINATION_ID, IGC_CBC_JE_LINES_BAL_PTD_V.SET_OF_BOOKS_ID SET_OF_BOOKS_ID, IGC_CBC_JE_LINES_BAL_PTD_V.ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, IGC_CBC_JE_LINES_BAL_PTD_V.BUDGET_VERSION_ID BUDGET_VERSION_ID FROM GL_CODE_COMBINATIONS GL_CODE_COMBINATIONS,GL_SETS_OF_BOOKS GL_SETS_OF_BOOKS,GL_BUDGET_VERSIONS GL_BUDGET_VERSIONS,GL_ENCUMBRANCE_TYPES GL_ENCUMBRANCE_TYPES,IGC_CBC_JE_LINES_BAL_PTD_V IGC_CBC_JE_LINES_BAL_PTD_V WHERE IGC_CBC_JE_LINES_BAL_PTD_V.SET_OF_BOOKS_ID = GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID (+) AND IGC_CBC_JE_LINES_BAL_PTD_V.CODE_COMBINATION_ID = GL_CODE_COMBINATIONS.CODE_COMBINATION_ID AND IGC_CBC_JE_LINES_BAL_PTD_V.ENCUMBRANCE_TYPE_ID = GL_ENCUMBRANCE_TYPES.ENCUMBRANCE_TYPE_ID (+) AND IGC_CBC_JE_LINES_BAL_PTD_V.BUDGET_VERSION_ID = GL_BUDGET_VERSIONS.BUDGET_VERSION_ID (+) WITH READ ONLY

View Text - HTML Formatted

SELECT IGC_CBC_JE_LINES_BAL_PTD_V.ACTUAL_FLAG ACTUAL_FLAG
, '_KF:SQLGL:GL#:GL_CODE_COMBINATIONS' "_KF:GL_ACCOUNT"
, IGC_CBC_JE_LINES_BAL_PTD_V.AMOUNT_TYPE AMOUNT_TYPE
, IGC_CBC_JE_LINES_BAL_PTD_V.PERIOD_YEAR PERIOD_YEAR
, IGC_CBC_JE_LINES_BAL_PTD_V.ENTERED_DR ENTERED_DR
, IGC_CBC_JE_LINES_BAL_PTD_V.ENTERED_CR ENTERED_CR
, IGC_CBC_JE_LINES_BAL_PTD_V.PERIOD_NAME PERIOD_NAME
, IGC_CBC_JE_LINES_BAL_PTD_V.PERIOD_SET_NAME PERIOD_SET_NAME
, IGC_CBC_JE_LINES_BAL_PTD_V.QUARTER_NUM QUARTER_NUMBER
, IGC_CBC_JE_LINES_BAL_PTD_V.PERIOD_NUM PERIOD_NUMBER
, IGC_CBC_JE_LINES_BAL_PTD_V.STATUS STATUS
, IGC_CBC_JE_LINES_BAL_PTD_V.DETAIL_SUMMARY_CODE DETAIL_SUMMARY_CODE
, IGC_CBC_JE_LINES_BAL_PTD_V.PTD_BALANCE PERIOD_TO_DATE_BALANCE
, GL_SETS_OF_BOOKS.NAME SETS_OF_BOOKS_NAME
, GL_SETS_OF_BOOKS.SHORT_NAME SETS_OF_BOOKS_SHORT_NAME
, GL_BUDGET_VERSIONS.BUDGET_NAME BUDGET_NAME
, GL_ENCUMBRANCE_TYPES.ENCUMBRANCE_TYPE ENCUMBRANCE_TYPE_NAME
, IGC_CBC_JE_LINES_BAL_PTD_V.CURRENCY_CODE CURRENCY_CODE
, IGC_CBC_JE_LINES_BAL_PTD_V.CODE_COMBINATION_ID CODE_COMBINATION_ID
, IGC_CBC_JE_LINES_BAL_PTD_V.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, IGC_CBC_JE_LINES_BAL_PTD_V.ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, IGC_CBC_JE_LINES_BAL_PTD_V.BUDGET_VERSION_ID BUDGET_VERSION_ID
FROM GL_CODE_COMBINATIONS GL_CODE_COMBINATIONS
, GL_SETS_OF_BOOKS GL_SETS_OF_BOOKS
, GL_BUDGET_VERSIONS GL_BUDGET_VERSIONS
, GL_ENCUMBRANCE_TYPES GL_ENCUMBRANCE_TYPES
, IGC_CBC_JE_LINES_BAL_PTD_V IGC_CBC_JE_LINES_BAL_PTD_V
WHERE IGC_CBC_JE_LINES_BAL_PTD_V.SET_OF_BOOKS_ID = GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID (+)
AND IGC_CBC_JE_LINES_BAL_PTD_V.CODE_COMBINATION_ID = GL_CODE_COMBINATIONS.CODE_COMBINATION_ID
AND IGC_CBC_JE_LINES_BAL_PTD_V.ENCUMBRANCE_TYPE_ID = GL_ENCUMBRANCE_TYPES.ENCUMBRANCE_TYPE_ID (+)
AND IGC_CBC_JE_LINES_BAL_PTD_V.BUDGET_VERSION_ID = GL_BUDGET_VERSIONS.BUDGET_VERSION_ID (+) WITH READ ONLY