DBA Data[Home] [Help]

VIEW: APPS.PSB_ALLOCRULE_SETS_V

Source

View Text - Preformatted

SELECT pes.rowid, pes.entity_set_id, pes.name, pes.description, pes.budget_group_id, pes.set_of_books_id, pes.data_extract_id, pes.attribute1, pes.attribute2, pes.attribute3, pes.attribute4, pes.attribute5, pes.attribute6, pes.attribute7, pes.attribute8, pes.attribute9, pes.attribute10, pes.context, pes.last_update_date, pes.last_updated_by, pes.created_by, pes.creation_date, pes.last_update_login FROM PSB_ENTITY_SET PES WHERE pes.entity_type = 'ALLOCRULE'
View Text - HTML Formatted

SELECT PES.ROWID
, PES.ENTITY_SET_ID
, PES.NAME
, PES.DESCRIPTION
, PES.BUDGET_GROUP_ID
, PES.SET_OF_BOOKS_ID
, PES.DATA_EXTRACT_ID
, PES.ATTRIBUTE1
, PES.ATTRIBUTE2
, PES.ATTRIBUTE3
, PES.ATTRIBUTE4
, PES.ATTRIBUTE5
, PES.ATTRIBUTE6
, PES.ATTRIBUTE7
, PES.ATTRIBUTE8
, PES.ATTRIBUTE9
, PES.ATTRIBUTE10
, PES.CONTEXT
, PES.LAST_UPDATE_DATE
, PES.LAST_UPDATED_BY
, PES.CREATED_BY
, PES.CREATION_DATE
, PES.LAST_UPDATE_LOGIN
FROM PSB_ENTITY_SET PES
WHERE PES.ENTITY_TYPE = 'ALLOCRULE'