VIEW: APPS.IGI_DOS_BUD_ASS_CAND_V

Source

View Text - Preformatted

SELECT kfv.code_combination_id , kfv.concatenated_segments , bud.budget_name , be.budget_entity_id , be.name , kfv.chart_of_accounts_id FROM GL_BUDGET_ASSIGNMENT_RANGES_V BAR, GL_BUDGET_ENTITIES BE, GL_BUDGETS BUD, GL_BUDGET_VERSIONS BV, GL_ENTITY_BUDGETS EB, GL_CODE_COMBINATIONS_KFV KFV 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

View Text - HTML Formatted

SELECT KFV.CODE_COMBINATION_ID
, KFV.CONCATENATED_SEGMENTS
, BUD.BUDGET_NAME
, BE.BUDGET_ENTITY_ID
, BE.NAME
, KFV.CHART_OF_ACCOUNTS_ID
FROM GL_BUDGET_ASSIGNMENT_RANGES_V BAR
, GL_BUDGET_ENTITIES BE
, GL_BUDGETS BUD
, GL_BUDGET_VERSIONS BV
, GL_ENTITY_BUDGETS EB
, GL_CODE_COMBINATIONS_KFV KFV
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