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
SQL 8 lines
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 |