Product: | IGC - Contract Commitment |
---|---|
Description: | view based on assignment range for funds check level |
Implementation/DBA Data: | APPS.IGC_CBC_BA_RANGES_FCL_V |
SELECT DISTINCT RA.BUDGET_ENTITY_ID
, RA.ROWID ROW_ID
, RA.SET_OF_BOOKS_ID
, RA.CURRENCY_CODE
, RA.ENTRY_CODE
, GL1.MEANING ENTRY_CODE_MEANING
, RA.RANGE_ID
, RA.STATUS
, RA.AUTOMATIC_ENCUMBRANCE_FLAG
, RA.FUNDS_CHECK_LEVEL_CODE
, GL2.MEANING SBC_FUNDS_CHECK_MEANING
, RA.LAST_UPDATE_DATE
, RA.CREATED_BY
, RA.CREATION_DATE
, RA.LAST_UPDATED_BY
, RA.LAST_UPDATE_LOGIN
, RA.SEQUENCE_NUMBER
, RA.SEGMENT1_LOW
, RA.SEGMENT1_HIGH
, RA.SEGMENT2_LOW
, RA.SEGMENT2_HIGH
, RA.SEGMENT3_LOW
, RA.SEGMENT3_HIGH
, RA.SEGMENT4_LOW
, RA.SEGMENT4_HIGH
, RA.SEGMENT5_LOW
, RA.SEGMENT5_HIGH
, RA.SEGMENT6_LOW
, RA.SEGMENT6_HIGH
, RA.SEGMENT7_LOW
, RA.SEGMENT7_HIGH
, RA.SEGMENT8_LOW
, RA.SEGMENT8_HIGH
, RA.SEGMENT9_LOW
, RA.SEGMENT9_HIGH
, RA.SEGMENT10_LOW
, RA.SEGMENT10_HIGH
, RA.SEGMENT11_LOW
, RA.SEGMENT11_HIGH
, RA.SEGMENT12_LOW
, RA.SEGMENT12_HIGH
, RA.SEGMENT13_LOW
, RA.SEGMENT13_HIGH
, RA.SEGMENT14_LOW
, RA.SEGMENT14_HIGH
, RA.SEGMENT15_LOW
, RA.SEGMENT15_HIGH
, RA.SEGMENT16_LOW
, RA.SEGMENT16_HIGH
, RA.SEGMENT17_LOW
, RA.SEGMENT17_HIGH
, RA.SEGMENT18_LOW
, RA.SEGMENT18_HIGH
, RA.SEGMENT19_LOW
, RA.SEGMENT19_HIGH
, RA.SEGMENT20_LOW
, RA.SEGMENT20_HIGH
, RA.SEGMENT21_LOW
, RA.SEGMENT21_HIGH
, RA.SEGMENT22_LOW
, RA.SEGMENT22_HIGH
, RA.SEGMENT23_LOW
, RA.SEGMENT23_HIGH
, RA.SEGMENT24_LOW
, RA.SEGMENT24_HIGH
, RA.SEGMENT25_LOW
, RA.SEGMENT25_HIGH
, RA.SEGMENT26_LOW
, RA.SEGMENT26_HIGH
, RA.SEGMENT27_LOW
, RA.SEGMENT27_HIGH
, RA.SEGMENT28_LOW
, RA.SEGMENT28_HIGH
, RA.SEGMENT29_LOW
, RA.SEGMENT29_HIGH
, RA.SEGMENT30_LOW
, RA.SEGMENT30_HIGH
, RA.AMOUNT_TYPE
, RA.BOUNDARY_CODE
, RA.CONTEXT
, RA.FUNDING_BUDGET_VERSION_ID
, GBV.BUDGET_NAME FUNDING_BUDGET_NAME
, RA.PROGRAM_APPLICATION_ID
, RA.PROGRAM_ID
, RA.PROGRAM_UPDATE_DATE
, RA.REQUEST_ID
, RA.ATTRIBUTE1
, RA.ATTRIBUTE2
, RA.ATTRIBUTE3
, RA.ATTRIBUTE4
, RA.ATTRIBUTE5
, RA.ATTRIBUTE6
, RA.ATTRIBUTE7
, RA.ATTRIBUTE8
, RA.ATTRIBUTE9
, RA.ATTRIBUTE10
, RA.ATTRIBUTE11
, RA.ATTRIBUTE12
, RA.ATTRIBUTE13
, RA.ATTRIBUTE14
, RA.ATTRIBUTE15
, OV.SBC_FUNDS_CHECK_LEVEL_CODE
, OV.CBC_OVERRIDE
FROM GL_BUDGET_ASSIGNMENT_RANGES RA
, IGC_CBC_BA_RANGES OV
, GL_LOOKUPS GL1
, GL_LOOKUPS GL2
, GL_BUDGET_VERSIONS GBV
WHERE OV.SET_OF_BOOKS_ID(+) = RA.SET_OF_BOOKS_ID
AND OV.CBC_RANGE_ID(+) = RA.RANGE_ID
AND GL1.LOOKUP_TYPE(+) = 'ENTRY_CODE'
AND GL1.LOOKUP_CODE(+) = RA.ENTRY_CODE
AND GL2.LOOKUP_TYPE(+) = 'FUNDS_CHECK_LEVEL'
AND GL2.LOOKUP_CODE(+) = RA.FUNDS_CHECK_LEVEL_CODE
AND GBV.BUDGET_VERSION_ID(+) = RA.FUNDING_BUDGET_VERSION_ID