View: BIS_HR_BUDGETS_V

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.BIS_HR_BUDGETS_V

View Text

SELECT DISTINCT TO_CHAR(G.BUSINESS_GROUP_ID)||'+'||TO_CHAR(B.BUDGET_ID) ID
, B.NAME VALUE
, G.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, G.NAME BUSINESS_GROUP_NAME
, B.BUDGET_ID BUDGET_ID
, B.NAME BUDGET_NAME
FROM PER_BUSINESS_GROUPS G
, PER_BUDGETS B
, PER_BUDGET_VERSIONS V
WHERE B.BUSINESS_GROUP_ID = G.BUSINESS_GROUP_ID
AND B.BUDGET_ID = V.BUDGET_ID
AND TRUNC(SYSDATE) BETWEEN V.DATE_FROM
AND NVL(V.DATE_TO
, SYSDATE)

Columns