VIEW: APPS.PA_BUDGET_VER_OLAP_V

Source

View Text - Preformatted

SELECT b.project_id , b.budget_version_id from pa_projects_all p , pa_budget_versions b WHERE p.project_id = b.project_id union all select -1 , -1 from dual

View Text - HTML Formatted

SELECT B.PROJECT_ID
, B.BUDGET_VERSION_ID
FROM PA_PROJECTS_ALL P
, PA_BUDGET_VERSIONS B
WHERE P.PROJECT_ID = B.PROJECT_ID UNION ALL SELECT -1
, -1
FROM DUAL