HXT Rotation Plan Table Listing
Description
- Categories
- BI Publisher
- Application
- Time and Labor
- Source
- Rotation Plan Table Listing (XML)
- Short Name
- HXT957C_XML
- DB package
- HXT_HXT957C_XMLP_PKG
SQL 8 lines
SELECT HXT_WEEKLY_WORK_SCHEDULES.NAME NAME1, HXT_WEEKLY_WORK_SCHEDULES.DESCRIPTION, HXT_ROTATION_SCHEDULES.START_DATE, HXT_ROTATION_SCHEDULES.TWS_ID, HXT_ROTATION_SCHEDULES.RTP_ID FROM HXT_ROTATION_SCHEDULES, HXT_WEEKLY_WORK_SCHEDULES WHERE (HXT_ROTATION_SCHEDULES.TWS_ID=HXT_WEEKLY_WORK_SCHEDULES.ID) and HXT_ROTATION_SCHEDULES.RTP_ID=:ID ORDER BY HXT_WEEKLY_WORK_SCHEDULES.NAME ASC |