View: IGI_DOS_BUD_ASS_CAND_V

Product:	IGI - Public Sector Financials International
Description:	Based on GL_BUDGET_ASSIGNMENT_RANGES_V, GL_BUDGET_ENTITIES, GL_BUDGETS, BUDGET_VERSIONS, GL_ENTITY_BUDGETS, and GL_CODE_COMBINATIONS_KFV.
Implementation/DBA Data:	APPS.IGI_DOS_BUD_ASS_CAND_V

View Text

SELECT KFV.CODE_COMBINATION_ID
, KFV.CONCATENATED_SEGMENTS
, BUD.BUDGET_NAME
, BE.BUDGET_ENTITY_ID
, BE.NAME
, KFV.CHART_OF_ACCOUNTS_ID
FROM GL_BUDGETS BUD
, GL_BUDGET_ASSIGNMENT_RANGES_V BAR
, GL_BUDGET_ENTITIES BE
, GL_BUDGET_VERSIONS BV
, GL_CODE_COMBINATIONS_KFV KFV
, GL_ENTITY_BUDGETS EB
WHERE BUD.BUDGET_NAME =BV.BUDGET_NAME
AND BUD.BUDGET_TYPE = BV.BUDGET_TYPE
AND BV.BUDGET_VERSION_ID = EB.BUDGET_VERSION_ID
AND BE.BUDGET_ENTITY_ID = EB.BUDGET_ENTITY_ID
AND BAR.BUDGET_ENTITY_ID = BE.BUDGET_ENTITY_ID
AND KFV.GL_ACCOUNT_TYPE = 'E'
AND KFV.SUMMARY_FLAG <>'Y'
AND KFV.SEGMENT1||KFV.SEGMENT2||KFV.SEGMENT3||KFV.SEGMENT4||KFV.SEGMENT5||KFV.SEGMENT6 BETWEEN BAR.SEGMENT1_LOW ||BAR.SEGMENT2_LOW ||BAR.SEGMENT3_LOW ||BAR.SEGMENT4_LOW ||BAR.SEGMENT5_LOW ||BAR.SEGMENT6_LOW
AND BAR.SEGMENT1_HIGH ||BAR.SEGMENT2_HIGH ||BAR.SEGMENT3_HIGH ||BAR.SEGMENT4_HIGH ||BAR.SEGMENT5_HIGH ||BAR.SEGMENT6_HIGH

Columns