VIEW: APPS.IGCFV_CBC_JOURNAL_LINES

Source

View Text - Preformatted

SELECT IGC_CBCJEL.CBC_JE_LINE_NUM JOURNAL_LINE_NUMBER, IGC_CBCJEL.JE_SOURCE JOURNAL_SOURCE, IGC_CBCJEL.JE_CATEGORY JOURNAL_CATEGORY, '_LA:IGC_CBCJEL.ACTUAL_FLAG:GL_LOOKUPS:BATCH_TYPE:DESCRIPTION' "_LA:BALANCE_TYPE", IGC_CBCJEL.EFFECTIVE_DATE EFFECTIVE_DATE, IGC_CBCJEL.ENTERED_DR ENTERED_DR, IGC_CBCJEL.ENTERED_CR ENTERED_CR, IGC_CBCJEL.POSTED_DATE POSTED_DATE, IGC_CBCJEL.DESCRIPTION DESCRIPTION, IGC_CBCJEL.REFERENCE_1 REFERENCE_1, IGC_CBCJEL.REFERENCE_2 REFERENCE_2, IGC_CBCJEL.REFERENCE_3 REFERENCE_3, IGC_CBCJEL.REFERENCE_4 REFERENCE_4, IGC_CBCJEL.REFERENCE_5 REFERENCE_5, IGC_CBCJEL.REFERENCE_6 REFERENCE_6, IGC_CBCJEL.REFERENCE_7 REFERENCE_7, IGC_CBCJEL.REFERENCE_8 REFERENCE_8, IGC_CBCJEL.REFERENCE_9 REFERENCE_9, IGC_CBCJEL.REFERENCE_10 REFERENCE_10, IGC_CBCJEL.BALANCING_SEGMENT_VALUE BALANCING_SEGMENT_VALUE, '_KF:SQLGL:GL#:GL_CODE_COMBINATIONS' "_KF:GL_ACCOUNT", GL_BUDGET_VERSIONS.BUDGET_NAME BUDGET_VERSION_NAME, GL_ENCUMBRANCE_TYPES.ENCUMBRANCE_TYPE ENCUMBRANCE_TYPE_NAME, IGC_CBCJEB.NAME BATCH_NAME, GL_SETS_OF_BOOKS.NAME SETS_OF_BOOKS_NAME, GL_SETS_OF_BOOKS.SHORT_NAME SETS_OF_BOOKS_SHORT_NAME, IGC_CBCJEL.BUDGET_TYPE BUDGET_TYPE, IGC_CBCJEL.PERIOD_NAME PERIOD_NAME, IGC_CBCJEL.PERIOD_SET_NAME PERIOD_SET_NAME, IGC_CBCJEL.ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, IGC_CBCJEL.CODE_COMBINATION_ID CODE_COMBINATION_ID, IGC_CBCJEL.BUDGET_VERSION_ID BUDGET_VERSION_ID, IGC_CBCJEL.SET_OF_BOOKS_ID SET_OF_BOOKS_ID, IGC_CBCJEL.CURRENCY_CODE CURRENCY_CODE, IGC_CBCJEL.CBC_JE_BATCH_ID BATCH_ID, IGC_CBCJEL.LAST_UPDATE_DATE LAST_UPDATE_DATE, IGC_CBCJEL.LAST_UPDATED_BY LAST_UPDATED_BY, IGC_CBCJEL.CREATION_DATE CREATION_DATE, IGC_CBCJEL.CREATED_BY CREATED_BY FROM IGC_CBC_JE_LINES IGC_CBCJEL,IGC_CBC_JE_BATCHES IGC_CBCJEB,FND_CURRENCIES FND_CURRENCIES,GL_ENCUMBRANCE_TYPES GL_ENCUMBRANCE_TYPES,GL_CODE_COMBINATIONS GL_CODE_COMBINATIONS,GL_SETS_OF_BOOKS GL_SETS_OF_BOOKS,GL_PERIOD_SETS GL_PERIOD_SETS,GL_PERIODS GL_PERIODS,GL_BUDGET_VERSIONS GL_BUDGET_VERSIONS WHERE IGC_CBCJEL.CBC_JE_BATCH_ID = IGC_CBCJEB.CBC_JE_BATCH_ID AND IGC_CBCJEL.CURRENCY_CODE=FND_CURRENCIES.CURRENCY_CODE AND IGC_CBCJEL.ENCUMBRANCE_TYPE_ID=GL_ENCUMBRANCE_TYPES.ENCUMBRANCE_TYPE_ID (+) AND IGC_CBCJEL.BUDGET_VERSION_ID=GL_BUDGET_VERSIONS.BUDGET_VERSION_ID (+) AND IGC_CBCJEL.CODE_COMBINATION_ID = GL_CODE_COMBINATIONS.CODE_COMBINATION_ID AND IGC_CBCJEL.PERIOD_SET_NAME=GL_PERIOD_SETS.PERIOD_SET_NAME (+) AND IGC_CBCJEL.PERIOD_NAME=GL_PERIODS.PERIOD_NAME (+) WITH READ ONLY

View Text - HTML Formatted

SELECT IGC_CBCJEL.CBC_JE_LINE_NUM JOURNAL_LINE_NUMBER
, IGC_CBCJEL.JE_SOURCE JOURNAL_SOURCE
, IGC_CBCJEL.JE_CATEGORY JOURNAL_CATEGORY
, '_LA:IGC_CBCJEL.ACTUAL_FLAG:GL_LOOKUPS:BATCH_TYPE:DESCRIPTION' "_LA:BALANCE_TYPE"
, IGC_CBCJEL.EFFECTIVE_DATE EFFECTIVE_DATE
, IGC_CBCJEL.ENTERED_DR ENTERED_DR
, IGC_CBCJEL.ENTERED_CR ENTERED_CR
, IGC_CBCJEL.POSTED_DATE POSTED_DATE
, IGC_CBCJEL.DESCRIPTION DESCRIPTION
, IGC_CBCJEL.REFERENCE_1 REFERENCE_1
, IGC_CBCJEL.REFERENCE_2 REFERENCE_2
, IGC_CBCJEL.REFERENCE_3 REFERENCE_3
, IGC_CBCJEL.REFERENCE_4 REFERENCE_4
, IGC_CBCJEL.REFERENCE_5 REFERENCE_5
, IGC_CBCJEL.REFERENCE_6 REFERENCE_6
, IGC_CBCJEL.REFERENCE_7 REFERENCE_7
, IGC_CBCJEL.REFERENCE_8 REFERENCE_8
, IGC_CBCJEL.REFERENCE_9 REFERENCE_9
, IGC_CBCJEL.REFERENCE_10 REFERENCE_10
, IGC_CBCJEL.BALANCING_SEGMENT_VALUE BALANCING_SEGMENT_VALUE
, '_KF:SQLGL:GL#:GL_CODE_COMBINATIONS' "_KF:GL_ACCOUNT"
, GL_BUDGET_VERSIONS.BUDGET_NAME BUDGET_VERSION_NAME
, GL_ENCUMBRANCE_TYPES.ENCUMBRANCE_TYPE ENCUMBRANCE_TYPE_NAME
, IGC_CBCJEB.NAME BATCH_NAME
, GL_SETS_OF_BOOKS.NAME SETS_OF_BOOKS_NAME
, GL_SETS_OF_BOOKS.SHORT_NAME SETS_OF_BOOKS_SHORT_NAME
, IGC_CBCJEL.BUDGET_TYPE BUDGET_TYPE
, IGC_CBCJEL.PERIOD_NAME PERIOD_NAME
, IGC_CBCJEL.PERIOD_SET_NAME PERIOD_SET_NAME
, IGC_CBCJEL.ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, IGC_CBCJEL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, IGC_CBCJEL.BUDGET_VERSION_ID BUDGET_VERSION_ID
, IGC_CBCJEL.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, IGC_CBCJEL.CURRENCY_CODE CURRENCY_CODE
, IGC_CBCJEL.CBC_JE_BATCH_ID BATCH_ID
, IGC_CBCJEL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IGC_CBCJEL.LAST_UPDATED_BY LAST_UPDATED_BY
, IGC_CBCJEL.CREATION_DATE CREATION_DATE
, IGC_CBCJEL.CREATED_BY CREATED_BY
FROM IGC_CBC_JE_LINES IGC_CBCJEL
, IGC_CBC_JE_BATCHES IGC_CBCJEB
, FND_CURRENCIES FND_CURRENCIES
, GL_ENCUMBRANCE_TYPES GL_ENCUMBRANCE_TYPES
, GL_CODE_COMBINATIONS GL_CODE_COMBINATIONS
, GL_SETS_OF_BOOKS GL_SETS_OF_BOOKS
, GL_PERIOD_SETS GL_PERIOD_SETS
, GL_PERIODS GL_PERIODS
, GL_BUDGET_VERSIONS GL_BUDGET_VERSIONS
WHERE IGC_CBCJEL.CBC_JE_BATCH_ID = IGC_CBCJEB.CBC_JE_BATCH_ID
AND IGC_CBCJEL.CURRENCY_CODE=FND_CURRENCIES.CURRENCY_CODE
AND IGC_CBCJEL.ENCUMBRANCE_TYPE_ID=GL_ENCUMBRANCE_TYPES.ENCUMBRANCE_TYPE_ID (+)
AND IGC_CBCJEL.BUDGET_VERSION_ID=GL_BUDGET_VERSIONS.BUDGET_VERSION_ID (+)
AND IGC_CBCJEL.CODE_COMBINATION_ID = GL_CODE_COMBINATIONS.CODE_COMBINATION_ID
AND IGC_CBCJEL.PERIOD_SET_NAME=GL_PERIOD_SETS.PERIOD_SET_NAME (+)
AND IGC_CBCJEL.PERIOD_NAME=GL_PERIODS.PERIOD_NAME (+) WITH READ ONLY