VIEW: APPS.PSBFV_PARAMETER_POS_SET_LISTS

Source

View Text - Preformatted

SELECT pe.name, aps.name, pea.effective_start_date, pea.effective_end_date, pe.entity_id, aps.account_position_set_id, pe.last_update_date, pe.last_updated_by, pe.created_by, pe.creation_date FROM psb_entity pe, psb_entity_assignment pea, psb_account_position_sets aps, psb_set_relations sr WHERE pe.entity_id = pea.entity_id AND pe.entity_type = 'PARAMETER' AND aps.account_or_position_type = 'P' AND sr.account_position_set_id = aps.account_position_set_id AND sr.parameter_id = pe.entity_id WITH READ ONLY

View Text - HTML Formatted

SELECT PE.NAME
, APS.NAME
, PEA.EFFECTIVE_START_DATE
, PEA.EFFECTIVE_END_DATE
, PE.ENTITY_ID
, APS.ACCOUNT_POSITION_SET_ID
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATED_BY
, PE.CREATED_BY
, PE.CREATION_DATE
FROM PSB_ENTITY PE
, PSB_ENTITY_ASSIGNMENT PEA
, PSB_ACCOUNT_POSITION_SETS APS
, PSB_SET_RELATIONS SR
WHERE PE.ENTITY_ID = PEA.ENTITY_ID
AND PE.ENTITY_TYPE = 'PARAMETER'
AND APS.ACCOUNT_OR_POSITION_TYPE = 'P'
AND SR.ACCOUNT_POSITION_SET_ID = APS.ACCOUNT_POSITION_SET_ID
AND SR.PARAMETER_ID = PE.ENTITY_ID WITH READ ONLY