Reports2017-11-18T12:27:27+00:00

HXT Project Accounting Table List

Description
Categories: BI Publisher, Human Resources
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
By continuing to use the site, you agree to the use of cookies. Accept