Product: | PSB - Public Sector Budgeting (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT OFALNK.ROWID
, OFALNK.LINK_ID
, OFALNK.NAME
, OFALNK.WORKSHEET_ID
, WS.NAME
, OFALNK.LINK_PREFIX
, OFALNK.DESCRIPTION_PREFIX
, OFALNK.FIN_DATA_SET_ID
, FDS.NAME
, OFALNK.HIERARCHY_ID
, HIR.NAME
, OFALNK.LOAD_COMPLETE_FLAG
, OFALNK.FREEZE_FLAG
, OFALNK.CONTEXT
, OFALNK.ATTRIBUTE1
, OFALNK.ATTRIBUTE2
, OFALNK.ATTRIBUTE3
, OFALNK.ATTRIBUTE4
, OFALNK.ATTRIBUTE5
, OFALNK.ATTRIBUTE6
, OFALNK.ATTRIBUTE7
, OFALNK.ATTRIBUTE8
, OFALNK.ATTRIBUTE9
, OFALNK.ATTRIBUTE10
FROM PSB_DSS_OFA_LINKS OFALNK
, PSB_WORKSHEETS WS
, PSB_DSS_FIN_DATA_SETS_V FDS
, PSB_DSS_HIERARCHIES_V HIR
WHERE OFALNK.WORKSHEET_ID = WS.WORKSHEET_ID
AND OFALNK.FIN_DATA_SET_ID = FDS.FIN_DATA_SET_ID
AND OFALNK.HIERARCHY_ID = HIR.HIERARCHY_ID(+)