VIEW: APPS.GL_BUDGET_ASSIGNMENTS_UNIQUE_V

Source

View Text - Preformatted

SELECT ba.ledger_id LEDGER_ID, ba.budget_entity_id BUDGET_ENTITY_ID, ba.range_id RANGE_ID, ba.code_combination_id CODE_COMBINATION_ID, ba.currency_code CURRENCY_CODE, ba.entry_code ENTRY_CODE, ba.ordering_value ORDERING_VALUE, ba.creation_date CREATION_DATE, ba.created_by CREATED_BY, ba.last_update_date LAST_UPDATE_DATE, ba.last_updated_by LAST_UPDATED_BY, ba.last_update_login LAST_UPDATE_LOGIN, ba.program_application_id PROGRAM_APPLICATION_ID, ba.program_id PROGRAM_ID, ba.program_update_date PROGRAM_UPDATE_DATE, ba.request_id REQUEST_ID FROM gl_budget_assignments ba WHERE NOT EXISTS (SELECT 'duplicate lesser range_id row' FROM gl_budget_assignments ba2 WHERE ba2.ledger_id = ba.ledger_id AND ba2.code_combination_id = ba.code_combination_id AND ba2.currency_code = ba.currency_code AND ba2.range_id < ba.range_id)

View Text - HTML Formatted

SELECT BA.LEDGER_ID LEDGER_ID
, BA.BUDGET_ENTITY_ID BUDGET_ENTITY_ID
, BA.RANGE_ID RANGE_ID
, BA.CODE_COMBINATION_ID CODE_COMBINATION_ID
, BA.CURRENCY_CODE CURRENCY_CODE
, BA.ENTRY_CODE ENTRY_CODE
, BA.ORDERING_VALUE ORDERING_VALUE
, BA.CREATION_DATE CREATION_DATE
, BA.CREATED_BY CREATED_BY
, BA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, BA.LAST_UPDATED_BY LAST_UPDATED_BY
, BA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BA.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, BA.PROGRAM_ID PROGRAM_ID
, BA.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, BA.REQUEST_ID REQUEST_ID
FROM GL_BUDGET_ASSIGNMENTS BA
WHERE NOT EXISTS (SELECT 'DUPLICATE LESSER RANGE_ID ROW'
FROM GL_BUDGET_ASSIGNMENTS BA2
WHERE BA2.LEDGER_ID = BA.LEDGER_ID
AND BA2.CODE_COMBINATION_ID = BA.CODE_COMBINATION_ID
AND BA2.CURRENCY_CODE = BA.CURRENCY_CODE
AND BA2.RANGE_ID < BA.RANGE_ID)