View: PSBFV_POSITION_SETS

Product:	PSB - Public Sector Budgeting
Description:
Implementation/DBA Data:	APPS.PSBFV_POSITION_SETS

View Text

SELECT DTE.DATA_EXTRACT_NAME
, SETS.NAME
, DECODE(SETS.GLOBAL_OR_LOCAL_TYPE
, 'G'
, 'Y'
, 'N')
, SETS.ATTRIBUTE_SELECTION_TYPE
, 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

Columns