HXT Holiday Calendar Table
Description
Categories: BI Publisher
Application: Time and Labor
Source: Holiday Calendar Table Report (XML)
Short Name: HXT957A_XML
DB package: HXT_HXT957A_XMLP_PKG
Source: Holiday Calendar Table Report (XML)
Short Name: HXT957A_XML
DB package: HXT_HXT957A_XMLP_PKG
Run
HXT Holiday Calendar Table and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT ALL HXT_HOLIDAY_CALENDARS.ID, HXT_HOLIDAY_CALENDARS.NAME, HXT_HOLIDAY_CALENDARS.DESCRIPTION, HXT_HOLIDAY_CALENDARS.ELEMENT_TYPE_ID, HXT_HOLIDAY_CALENDARS.EFFECTIVE_START_DATE, HXT_HOLIDAY_CALENDARS.EFFECTIVE_END_DATE, HXT_HOLIDAY_CALENDARS.organization_id, NULL dummy, HXT_HXT957A_XMLP_PKG.org_nameformula(HXT_HOLIDAY_CALENDARS.organization_id) ORG_NAME, HXT_HXT957A_XMLP_PKG.earn_typeformula(HXT_HOLIDAY_CALENDARS.ELEMENT_TYPE_ID, HXT_HOLIDAY_CALENDARS.EFFECTIVE_START_DATE, HXT_HOLIDAY_CALENDARS.EFFECTIVE_END_DATE) EARN_TYPE FROM HXT_HOLIDAY_CALENDARS ORDER BY HXT_HOLIDAY_CALENDARS.NAME ASC |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Start Date |
|
Date | |
End Date |
|
Date |