Product: | IGC - Contract Commitment |
---|---|
Description: | view based on gl summary templates and cbc summary templates table for cbc funds check level |
Implementation/DBA Data: | APPS.IGC_CBC_SUMMARY_TEMPLATES_V |
SELECT DISTINCT GST.TEMPLATE_ID
, GST.SET_OF_BOOKS_ID
, GST.STATUS
, GST.LAST_UPDATE_DATE
, GST.LAST_UPDATED_BY
, GST.LAST_UPDATE_LOGIN
, GST.CREATED_BY
, GST.CREATION_DATE
, GST.TEMPLATE_NAME
, GST.CONCATENATED_DESCRIPTION
, GST.ACCOUNT_CATEGORY_CODE
, GST.FUNDS_CHECK_LEVEL_CODE
, GST.MAX_CODE_COMBINATION_ID
, GST.START_ACTUALS_PERIOD_NAME
, GST.AMOUNT_TYPE
, GST.BOUNDARY_CODE
, GST.DR_CR_CODE
, GST.FUNDING_BUDGET_VERSION_ID
, GST.SEGMENT1_TYPE
, GST.SEGMENT2_TYPE
, GST.SEGMENT3_TYPE
, GST.SEGMENT4_TYPE
, GST.SEGMENT5_TYPE
, GST.SEGMENT6_TYPE
, GST.SEGMENT7_TYPE
, GST.SEGMENT8_TYPE
, GST.SEGMENT9_TYPE
, GST.SEGMENT10_TYPE
, GST.SEGMENT11_TYPE
, GST.SEGMENT12_TYPE
, GST.SEGMENT13_TYPE
, GST.SEGMENT14_TYPE
, GST.SEGMENT15_TYPE
, GST.SEGMENT16_TYPE
, GST.SEGMENT17_TYPE
, GST.SEGMENT18_TYPE
, GST.SEGMENT19_TYPE
, GST.SEGMENT20_TYPE
, GST.SEGMENT21_TYPE
, GST.SEGMENT22_TYPE
, GST.SEGMENT23_TYPE
, GST.SEGMENT24_TYPE
, GST.SEGMENT25_TYPE
, GST.SEGMENT26_TYPE
, GST.SEGMENT27_TYPE
, GST.SEGMENT28_TYPE
, GST.SEGMENT29_TYPE
, GST.SEGMENT30_TYPE
, GST.DESCRIPTION
, GST.ATTRIBUTE1
, GST.ATTRIBUTE2
, GST.ATTRIBUTE3
, GST.ATTRIBUTE4
, GST.ATTRIBUTE5
, GST.ATTRIBUTE6
, GST.ATTRIBUTE7
, GST.ATTRIBUTE8
, GST.CONTEXT
, IST.CBC_OVERRIDE
FROM GL_SUMMARY_TEMPLATES GST
, IGC_CBC_SUMMARY_TEMPLATES IST
WHERE IST.SET_OF_BOOKS_ID(+) = GST.SET_OF_BOOKS_ID
AND IST.TEMPLATE_ID(+) = GST.TEMPLATE_ID