Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSB_PARAMETER_ASSIGNMENTS_V |
SELECT PEA.ROWID
, PEA.ENTITY_SET_ID
, PEA.ENTITY_ID
, PE.ENTITY_SUBTYPE
, PE.NAME
, PE.DESCRIPTION
, PE.DATA_EXTRACT_ID
, PEA.PRIORITY
, PE.PARAMETER_AUTOINC_RULE
, PE.PARAMETER_COMPOUND_ANNUALLY
, PE.CURRENCY_CODE
, 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
, PE.LAST_UPDATED_BY
, PEA.CREATION_DATE
, PEA.CREATED_BY
, PEA.LAST_UPDATE_LOGIN
FROM PSB_ENTITY_ASSIGNMENT PEA
, PSB_ENTITY PE
WHERE PE.ENTITY_TYPE = 'PARAMETER'
AND PE.ENTITY_ID = PEA.ENTITY_ID