VIEW: APPS.PSBBV_ACCOUNT_SETS

Source

View Text - Preformatted

SELECT sets.name, decode(sets.global_or_local_type,'G','Y','N'), sets.account_position_set_id, sets.set_of_books_id, sets.LAST_UPDATE_DATE, sets.LAST_UPDATED_BY, sets.CREATED_BY, sets.CREATION_DATE FROM psb_account_position_sets sets WHERE account_or_position_type = 'A' with read only

View Text - HTML Formatted

SELECT SETS.NAME
, DECODE(SETS.GLOBAL_OR_LOCAL_TYPE
, 'G'
, 'Y'
, 'N')
, SETS.ACCOUNT_POSITION_SET_ID
, SETS.SET_OF_BOOKS_ID
, SETS.LAST_UPDATE_DATE
, SETS.LAST_UPDATED_BY
, SETS.CREATED_BY
, SETS.CREATION_DATE
FROM PSB_ACCOUNT_POSITION_SETS SETS
WHERE ACCOUNT_OR_POSITION_TYPE = 'A' WITH READ ONLY