Product: | PSB - Public Sector Budgeting (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PEA.ROWID
, PEA.ENTITY_SET_ID
, PEA.ENTITY_ID
, PE.ENTITY_SUBTYPE
, PEA.SEVERITY_LEVEL
, PE.NAME
, PE.DESCRIPTION
, PE.DATA_EXTRACT_ID
, PE.CURRENCY_CODE
, PE.CONSTRAINT_DETAILED_FLAG
, PE.FTE_CONSTRAINT
, PEA.EFFECTIVE_START_DATE
, PEA.EFFECTIVE_END_DATE
, PE.ATTRIBUTE1
, PE.ATTRIBUTE2
, PE.ATTRIBUTE3
, PE.ATTRIBUTE4
, PE.ATTRIBUTE5
, PE.ATTRIBUTE6
, PE.ATTRIBUTE7
, PE.ATTRIBUTE8
, PE.ATTRIBUTE9
, PE.ATTRIBUTE10
, PE.CONTEXT
, PEA.LAST_UPDATE_DATE
, PEA.LAST_UPDATED_BY
, PE.CREATION_DATE
, PE.CREATED_BY
, PEA.LAST_UPDATE_LOGIN
FROM PSB_ENTITY_ASSIGNMENT PEA
, PSB_ENTITY PE
WHERE PE.ENTITY_TYPE = 'CONSTRAINT'
AND PE.ENTITY_ID = PEA.ENTITY_ID