VIEW: APPS.PSB_ALLOCRULE_ASSIGNMENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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