View: FII_PA_BUDGET_MPV

Product:	FII - Financial Intelligence
Description:	FII_PA_BUDGET_MPV is the view for data validity on source side.
Implementation/DBA Data:	APPS.FII_PA_BUDGET_MPV

View Text

SELECT BV.BUDGET_VERSION_ID || '-' || SUBSTRB(ELI.INSTANCE_CODE
, 1
, 40)
, BV.LAST_UPDATE_DATE
FROM PA_BUDGET_TYPES BT
, PA_BUDGET_VERSIONS BV
, PA_PROJECTS_ALL PRJ
, EDW_LOCAL_INSTANCE ELI
WHERE BV.BUDGET_TYPE_CODE = BT.BUDGET_TYPE_CODE
AND BV.PROJECT_ID = PRJ.PROJECT_ID
AND BV.BUDGET_STATUS_CODE = 'B'

Columns