FND Design Data [Home] [Help]

View: PSBBV_POSITION_SET_LISTS

Product: PSB - Public Sector Budgeting
Description:
Implementation/DBA Data: ViewAPPS.PSBBV_POSITION_SET_LISTS
View Text

SELECT ST.NAME
, DT.DATA_EXTRACT_NAME
, PS.NAME
, PO.ACCOUNT_POSITION_SET_ID
, PO.DATA_EXTRACT_ID
, PO.POSITION_ID
, PO.LAST_UPDATE_DATE
, PO.LAST_UPDATED_BY
, PO.CREATED_BY
, PO.CREATION_DATE
FROM PSB_BUDGET_POSITIONS PO
, PSB_POSITIONS PS
, PSB_DATA_EXTRACTS DT
, PSB_ACCOUNT_POSITION_SETS ST
WHERE PO.POSITION_ID = PS.POSITION_ID
AND DT.DATA_EXTRACT_ID = PS.DATA_EXTRACT_ID
AND ST.ACCOUNT_POSITION_SET_ID = PO.ACCOUNT_POSITION_SET_ID WITH READ ONLY

Columns

Name
POSITION_SET_NAME
DATA_EXTRACT_NAME
POSITION_NAME
POSITION_SET_ID
DATA_EXTRACT_ID
POSITION_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE