VIEW: APPS.PSBBV_POSITION_SETS

Source

View Text - Preformatted

SELECT sets.name ,dte.data_extract_name ,decode(sets.global_or_local_type,'G','Y','N') ,sets.account_position_set_id ,sets.data_extract_id ,sets.LAST_UPDATE_DATE ,sets.LAST_UPDATED_BY ,sets.CREATED_BY ,sets.CREATION_DATE FROM psb_account_position_sets sets, psb_data_extracts dte WHERE account_or_position_type = 'P' AND dte.data_extract_id(+) = sets.data_extract_id with read only

View Text - HTML Formatted

SELECT SETS.NAME
, DTE.DATA_EXTRACT_NAME
, DECODE(SETS.GLOBAL_OR_LOCAL_TYPE
, 'G'
, 'Y'
, 'N')
, SETS.ACCOUNT_POSITION_SET_ID
, SETS.DATA_EXTRACT_ID
, SETS.LAST_UPDATE_DATE
, SETS.LAST_UPDATED_BY
, SETS.CREATED_BY
, SETS.CREATION_DATE
FROM PSB_ACCOUNT_POSITION_SETS SETS
, PSB_DATA_EXTRACTS DTE
WHERE ACCOUNT_OR_POSITION_TYPE = 'P'
AND DTE.DATA_EXTRACT_ID(+) = SETS.DATA_EXTRACT_ID WITH READ ONLY