Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSB_ALLOCRULE_ASSIGNMENTS_V |
SELECT PEA.ROWID
, PEA.ENTITY_SET_ID
, PEA.ENTITY_ID
, PE.ENTITY_SUBTYPE
, PE.ALLOCATION_TYPE
, PE.BUDGET_YEAR_TYPE_ID
, YTP.NAME
, PE.BALANCE_TYPE
, FL.MEANING
, PE.NAME
, PE.DESCRIPTION
, PEA.PRIORITY
, 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
, PEA.CREATION_DATE
, PEA.CREATED_BY
, PEA.LAST_UPDATE_LOGIN
FROM PSB_ENTITY_ASSIGNMENT PEA
, PSB_ENTITY PE
, PSB_BUDGET_YEAR_TYPES YTP
, FND_LOOKUPS FL
WHERE PE.ENTITY_TYPE = 'ALLOCRULE'
AND PE.ENTITY_ID = PEA.ENTITY_ID
AND PE.BUDGET_YEAR_TYPE_ID = YTP.BUDGET_YEAR_TYPE_ID(+)
AND FL.LOOKUP_TYPE(+) = 'BALANCE_TYPE'
AND FL.LOOKUP_CODE(+) = PE.BALANCE_TYPE