Product: | IGC - Contract Commitment |
---|---|
Description: | view based on gl summary templates and cbc summary templates table for cbc funds check level form |
Implementation/DBA Data: | APPS.IGC_CBC_SUMMARY_TEMPLATE_FCL_V |
SELECT GST.ROWID ROW_ID
, GST.TEMPLATE_ID
, GST.SET_OF_BOOKS_ID
, GST.STATUS
, GL1.MEANING SUMMARY_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
, GL2.MEANING ACCOUNT_CATEGORY
, GST.FUNDS_CHECK_LEVEL_CODE
, GL3.MEANING SBC_FUNDS_CHECK_MEANING
, GST.MAX_CODE_COMBINATION_ID
, GST.START_ACTUALS_PERIOD_NAME
, GST.AMOUNT_TYPE
, GST.BOUNDARY_CODE
, GST.DR_CR_CODE
, GL4.DESCRIPTION DR_CR_MEANING
, GST.FUNDING_BUDGET_VERSION_ID
, GBV.BUDGET_NAME FUNDING_BUDGET_NAME
, 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
, GL_LOOKUPS GL1
, GL_LOOKUPS GL2
, GL_LOOKUPS GL3
, GL_LOOKUPS GL4
, GL_BUDGET_VERSIONS GBV
WHERE IST.SET_OF_BOOKS_ID(+) = GST.SET_OF_BOOKS_ID
AND IST.TEMPLATE_ID(+) = GST.TEMPLATE_ID
AND GL1.LOOKUP_TYPE(+) = 'SUMMARY_STATUS'
AND GL1.LOOKUP_CODE(+) = GST.STATUS
AND GL2.LOOKUP_TYPE(+) = 'ACCOUNT_CATEGORY_CODE'
AND GL2.LOOKUP_CODE(+) = GST.ACCOUNT_CATEGORY_CODE
AND GL3.LOOKUP_TYPE(+) = 'FUNDS_CHECK_LEVEL'
AND GL3.LOOKUP_CODE(+) = GST.FUNDS_CHECK_LEVEL_CODE
AND GL4.LOOKUP_TYPE(+) = 'DR_CR'
AND GL4.LOOKUP_CODE(+) = GST.DR_CR_CODE
AND GBV.BUDGET_VERSION_ID(+) = GST.FUNDING_BUDGET_VERSION_ID