Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSBFV_CONSTRAINTS |
SELECT PE.NAME
, DE.DATA_EXTRACT_NAME
, '_LA:ENTITY_SUBTYPE:FND_LOOKUPS:PSB_CONSTRAINT_TYPE:MEANING'
, PE.DESCRIPTION
, PE.CURRENCY_CODE
, PE.CONSTRAINT_DETAILED_FLAG
, PE.FTE_CONSTRAINT
, '_DF:PSB:PSB_ENTITY:PE'
, PE.ENTITY_ID
, PE.DATA_EXTRACT_ID
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATED_BY
, PE.CREATED_BY
, PE.CREATION_DATE
FROM PSB_ENTITY PE
, GL_SETS_OF_BOOKS GL
, PSB_DATA_EXTRACTS DE
WHERE GL.SET_OF_BOOKS_ID(+) = PE.SET_OF_BOOKS_ID
AND DE.DATA_EXTRACT_ID(+) = PE.DATA_EXTRACT_ID
AND PE.ENTITY_TYPE = 'CONSTRAINT' WITH READ ONLY