VIEW: APPS.HXC_APPROVAL_STYLES_V

Source

View Text - Preformatted

SELECT aps.BUSINESS_GROUP_ID, aps.LEGISLATION_CODE, aps.APPROVAL_STYLE_ID, aps.NAME, aps.DESCRIPTION, aps.OBJECT_VERSION_NUMBER, nvl(aps.RUN_RECIPIENT_EXTENSIONS,'Y') RUN_RECIPIENT_EXTENSIONS, aps.ADMIN_ROLE, aps.ERROR_ADMIN_ROLE, hxc_notification_helper.has_timeout_notifications(aps.approval_style_id) TIMEOUTS_ENABLED, hxc_notification_helper.number_timeout_retries_any(aps.approval_style_id) NUMBER_RETRIES, hxc_notification_helper.approver_timeout_value(aps.approval_style_id) APPROVER_TIMEOUT, hxc_notification_helper.preparer_timeout_value(aps.approval_style_id) PREPARER_TIMEOUT, hxc_notification_helper.admin_timeout_value(aps.approval_style_id) ADMIN_TIMEOUT, hxc_notification_helper.notify_sup_for_approval(aps.approval_style_id) NOTIFY_SUPERVISOR, hxc_notification_helper.notify_worker_submission(aps.approval_style_id) NOTIFY_WORKER_ON_SUBMIT, hxc_notification_helper.notify_worker_auto_approve(aps.approval_style_id) NOTIFY_WORKER_ON_AA, hxc_notification_helper.notify_preparer_approve(aps.approval_style_id) NOTIFY_PREPARER_APPROVED, hxc_notification_helper.notify_preparer_reject(aps.approval_style_id) NOTIFY_PREPARER_REJECTED, hxc_notification_helper.notify_preparer_transfer(aps.approval_style_id) NOTIFY_PREPARER_TRANSFER, aps.CREATED_BY, aps.CREATION_DATE, aps.LAST_UPDATED_BY, aps.LAST_UPDATE_DATE, aps.LAST_UPDATE_LOGIN from hxc_approval_styles aps

View Text - HTML Formatted

SELECT APS.BUSINESS_GROUP_ID
, APS.LEGISLATION_CODE
, APS.APPROVAL_STYLE_ID
, APS.NAME
, APS.DESCRIPTION
, APS.OBJECT_VERSION_NUMBER
, NVL(APS.RUN_RECIPIENT_EXTENSIONS
, 'Y') RUN_RECIPIENT_EXTENSIONS
, APS.ADMIN_ROLE
, APS.ERROR_ADMIN_ROLE
, HXC_NOTIFICATION_HELPER.HAS_TIMEOUT_NOTIFICATIONS(APS.APPROVAL_STYLE_ID) TIMEOUTS_ENABLED
, HXC_NOTIFICATION_HELPER.NUMBER_TIMEOUT_RETRIES_ANY(APS.APPROVAL_STYLE_ID) NUMBER_RETRIES
, HXC_NOTIFICATION_HELPER.APPROVER_TIMEOUT_VALUE(APS.APPROVAL_STYLE_ID) APPROVER_TIMEOUT
, HXC_NOTIFICATION_HELPER.PREPARER_TIMEOUT_VALUE(APS.APPROVAL_STYLE_ID) PREPARER_TIMEOUT
, HXC_NOTIFICATION_HELPER.ADMIN_TIMEOUT_VALUE(APS.APPROVAL_STYLE_ID) ADMIN_TIMEOUT
, HXC_NOTIFICATION_HELPER.NOTIFY_SUP_FOR_APPROVAL(APS.APPROVAL_STYLE_ID) NOTIFY_SUPERVISOR
, HXC_NOTIFICATION_HELPER.NOTIFY_WORKER_SUBMISSION(APS.APPROVAL_STYLE_ID) NOTIFY_WORKER_ON_SUBMIT
, HXC_NOTIFICATION_HELPER.NOTIFY_WORKER_AUTO_APPROVE(APS.APPROVAL_STYLE_ID) NOTIFY_WORKER_ON_AA
, HXC_NOTIFICATION_HELPER.NOTIFY_PREPARER_APPROVE(APS.APPROVAL_STYLE_ID) NOTIFY_PREPARER_APPROVED
, HXC_NOTIFICATION_HELPER.NOTIFY_PREPARER_REJECT(APS.APPROVAL_STYLE_ID) NOTIFY_PREPARER_REJECTED
, HXC_NOTIFICATION_HELPER.NOTIFY_PREPARER_TRANSFER(APS.APPROVAL_STYLE_ID) NOTIFY_PREPARER_TRANSFER
, APS.CREATED_BY
, APS.CREATION_DATE
, APS.LAST_UPDATED_BY
, APS.LAST_UPDATE_DATE
, APS.LAST_UPDATE_LOGIN
FROM HXC_APPROVAL_STYLES APS