VIEW: APPS.HXC_PUBLIC_TEMPLATE_LIST_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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