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
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