DBA Data[Home] [Help]

VIEW: APPS.PSB_ALLOCRULES_V

Source

View Text - Preformatted

SELECT pe.rowid, pe.entity_id, pe.entity_subtype, pe.name, pe.set_of_books_id, pe.description, pe.allocation_type, pe.budget_year_type_id, pe.balance_type, pe.last_update_date, pe.last_updated_by, pe.creation_date, pe.created_by, pe.last_update_login FROM PSB_ENTITY PE WHERE pe.entity_type = 'ALLOCRULE'
View Text - HTML Formatted

SELECT PE.ROWID
, PE.ENTITY_ID
, PE.ENTITY_SUBTYPE
, PE.NAME
, PE.SET_OF_BOOKS_ID
, PE.DESCRIPTION
, PE.ALLOCATION_TYPE
, PE.BUDGET_YEAR_TYPE_ID
, PE.BALANCE_TYPE
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATED_BY
, PE.CREATION_DATE
, PE.CREATED_BY
, PE.LAST_UPDATE_LOGIN
FROM PSB_ENTITY PE
WHERE PE.ENTITY_TYPE = 'ALLOCRULE'