View: GL_BUDGET_ASSIGNMENTS_UNIQUE_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_BUDGET_ASSIGNMENTS_UNIQUE_V

View Text

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)

Columns