[Home] [Help]
View: PSBFV_CONSTRAINT_SETS
View Text
SELECT PES.NAME
, PES.DESCRIPTION
, PES.CONSTRAINT_THRESHOLD
, '_DF:PSB:PSB_ENTITY_SET:PES'
, PES.ENTITY_SET_ID
, PES.LAST_UPDATE_DATE
, PES.LAST_UPDATED_BY
, PES.CREATED_BY
, PES.CREATION_DATE
FROM PSB_ENTITY_SET PES
, PSB_BUDGET_GROUPS BG
, GL_SETS_OF_BOOKS GL
, PSB_DATA_EXTRACTS DE
WHERE BG.BUDGET_GROUP_ID = PES.BUDGET_GROUP_ID
AND GL.SET_OF_BOOKS_ID(+) = PES.SET_OF_BOOKS_ID
AND DE.DATA_EXTRACT_ID(+) = PES.DATA_EXTRACT_ID
AND PES.ENTITY_TYPE = 'CONSTRAINT' WITH READ ONLY
Columns
Name |
CONSTRAINT_SET_NAME |
DESCRIPTION |
CONSTRAINT_THRESHOLD |
"_DF" |
CONSTRAINT_SET_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |