VIEW: APPS.PSBBV_ALLOC_RULE_SET_LISTS

Source

View Text - Preformatted

SELECT pes.name, pe.name, pe.entity_subtype, '_LA:allocation_type:FND_LOOKUPS:PSB_ALLOCRULE_TYPE:meaning', '_LA:balance_type:FND_LOOKUPS:PSB_BALANCE_TYPE:meaning', pe.description, pea.priority, 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_assignment pea, psb_entity pe, psb_entity_set pes, psb_budget_year_types ytp WHERE pe.entity_type = 'ALLOCRULE' AND pe.entity_id = pea.entity_id AND pes.entity_set_id = pea.entity_set_id AND pe.budget_year_type_id = ytp.budget_year_type_id(+) WITH READ ONLY

View Text - HTML Formatted

SELECT PES.NAME
, PE.NAME
, PE.ENTITY_SUBTYPE
, '_LA:ALLOCATION_TYPE:FND_LOOKUPS:PSB_ALLOCRULE_TYPE:MEANING'
, '_LA:BALANCE_TYPE:FND_LOOKUPS:PSB_BALANCE_TYPE:MEANING'
, PE.DESCRIPTION
, PEA.PRIORITY
, 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_ASSIGNMENT PEA
, PSB_ENTITY PE
, PSB_ENTITY_SET PES
, PSB_BUDGET_YEAR_TYPES YTP
WHERE PE.ENTITY_TYPE = 'ALLOCRULE'
AND PE.ENTITY_ID = PEA.ENTITY_ID
AND PES.ENTITY_SET_ID = PEA.ENTITY_SET_ID
AND PE.BUDGET_YEAR_TYPE_ID = YTP.BUDGET_YEAR_TYPE_ID(+) WITH READ ONLY