DBA Data[Home] [Help]

VIEW: APPS.ENG_LIST_ROLES_V

Source

View Text - Preformatted

SELECT 'ENG_LIST'||':'||eeal.approval_list_id, eeal.approval_list_name, eeal.description, WF_PREF.GET_PREF('-WF_DEFAULT-','MAILTYPE'), NULL, NULL, NULL, NULL, 'ENG_LIST', eeal.approval_list_id, to_date(NULL), 'ACTIVE', to_date(NULL), NULL, 'N', 7 FROM ENG_ECN_APPROVAL_LISTS EEAL
View Text - HTML Formatted

SELECT 'ENG_LIST'||':'||EEAL.APPROVAL_LIST_ID
, EEAL.APPROVAL_LIST_NAME
, EEAL.DESCRIPTION
, WF_PREF.GET_PREF('-WF_DEFAULT-'
, 'MAILTYPE')
, NULL
, NULL
, NULL
, NULL
, 'ENG_LIST'
, EEAL.APPROVAL_LIST_ID
, TO_DATE(NULL)
, 'ACTIVE'
, TO_DATE(NULL)
, NULL
, 'N'
, 7
FROM ENG_ECN_APPROVAL_LISTS EEAL