Product: | PSB - Public Sector Budgeting |
---|---|
Description: | Base view for constriant assignments. |
Implementation/DBA Data: | APPS.PSBBV_CONSTRAINT_SET_LISTS |
SELECT PES.NAME
, PE.NAME
, '_LA:ENTITY_SUBTYPE:FND_LOOKUPS:PSB_CONSTRAINT_TYPE:MEANING'
, PEA.SEVERITY_LEVEL
, PE.DESCRIPTION
, PE.CURRENCY_CODE
, PE.CONSTRAINT_DETAILED_FLAG
, PE.FTE_CONSTRAINT
, PEA.EFFECTIVE_START_DATE
, PEA.EFFECTIVE_END_DATE
, PEA.ENTITY_SET_ID
, PEA.ENTITY_ID
, PEA.LAST_UPDATE_DATE
, PEA.LAST_UPDATED_BY
, PEA.CREATED_BY
, PEA.CREATION_DATE
FROM PSB_ENTITY PE
, PSB_ENTITY_SET PES
, PSB_ENTITY_ASSIGNMENT PEA
WHERE PE.ENTITY_TYPE = 'CONSTRAINT'
AND PE.ENTITY_ID = PEA.ENTITY_ID
AND PES.ENTITY_SET_ID = PEA.ENTITY_SET_ID WITH READ ONLY