eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PSPFV_TEMPLATE_ORGANIZATIONS

Product:	PSP - Labor Distribution
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT HO2.NAME
, HOU.NAME
, HOU.DATE_FROM
, HOU.DATE_TO
, HOU.TYPE
, PTO.EXPENDITURE_ORGANIZATION_ID
, PTO.TEMPLATE_ID
, PER.TEMPLATE_NAME
, PTO.LAST_UPDATE_DATE
, PTO.LAST_UPDATED_BY
, PTO.CREATED_BY
, PTO.CREATION_DATE
FROM PSP_TEMPLATE_ORGANIZATIONS PTO
, HR_ORGANIZATION_UNITS HO2
, HR_ORGANIZATION_UNITS HOU
, PSP_EFFORT_REPORT_TEMPLATES PER
WHERE PTO.EXPENDITURE_ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND HOU.BUSINESS_GROUP_ID = HO2.ORGANIZATION_ID
AND PTO.TEMPLATE_ID = PER.TEMPLATE_ID
AND '_SEC:PTO.EXPENDITURE_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns

Name
BUSINESS_GROUP_NAME
ORGANIZATION_NAME
ORGANIZATION_START_DATE
EXPENDITURE_ORGANIZATION_ID
ORGANIZATION_TYPE
ORGANIZATION_END_DATE
TEMPLATE_ID
TEMPLATE_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE