View: HXC_PUBLIC_TEMPLATE_LIST_V

Product:	HXC - Time and Labor Engine
Description:
Implementation/DBA Data:	APPS.HXC_PUBLIC_TEMPLATE_LIST_V

View Text

SELECT TEMPLATE_ID
, TEMPLATE_NAME
, DESCRIPTION
, LAYOUTS_TL.DISPLAY_LAYOUT_NAME
, REC_PRD.NAME
, RECORDED_HOURS
, PER_CRE_BY.FULL_NAME
, PER_UPD_BY.FULL_NAME
, SUMMARY.BUSINESS_GROUP_ID
, SUMMARY.START_TIME
, SUMMARY.STOP_TIME
FROM HXC_TEMPLATE_SUMMARY SUMMARY
, HXC_LAYOUTS_TL LAYOUTS_TL
, HXC_RECURRING_PERIODS REC_PRD
, PER_ALL_PEOPLE_F PER_CRE_BY
, PER_ALL_PEOPLE_F PER_UPD_BY
WHERE SUMMARY.RECURRING_PERIOD_ID = REC_PRD.RECURRING_PERIOD_ID
AND SUMMARY.LAYOUT_ID = LAYOUTS_TL.LAYOUT_ID
AND PER_CRE_BY.PERSON_ID = SUMMARY.RESOURCE_ID
AND SUMMARY.TEMPLATE_TYPE = 'PUBLIC'
AND PER_UPD_BY.PERSON_ID =SUMMARY.LAST_UPDATED_BY_RESOURCE_ID
AND TRUNC(SYSDATE) BETWEEN PER_CRE_BY.EFFECTIVE_START_DATE
AND PER_CRE_BY.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN PER_UPD_BY.EFFECTIVE_START_DATE
AND PER_UPD_BY.EFFECTIVE_END_DATE
AND LAYOUTS_TL.LANGUAGE = USERENV('LANG')

Columns