HXT Project Accounting Table List

Description
Categories: BI Publisher
Application: Time and Labor
Source: Project Accounting Table List (XML)
Short Name: HXT957E_XML
DB package: HXT_HXT957E_XMLP_PKG
SELECT HR_ORGANIZATION_UNITS.NAME ORG_NAME, 
HXT_PROJECTS.NAME PROJ_NAME, HXT_PROJECTS.DESCRIPTION, HXT_PROJECTS.PRO_NUMBER, 
HXT_PROJECTS.DATE_FROM, HXT_PROJECTS.DATE_TO, HXT_PROJECTS.ID
FROM HXT_PROJECTS, HR_ORGANIZATION_UNITS
WHERE 
(HXT_PROJECTS.ORGANIZATION_ID=HR_ORGANIZATION_UNITS.ORGANIZATION_ID)
ORDER BY HR_ORGANIZATION_UNITS.NAME ASC, HXT_PROJECTS.NAME ASC