SELECT form_name, user_form_name, description FROM fnd_form_vl WHERE hr_general.chk_application_id(application_id) = 'TRUE' UNION SELECT 'GENERAL' form_name, 'General' user_form_name, 'Function for standalone integrators' description FROM dual UNION SELECT 'LETTER' form_name, 'Letterl' user_form_name, 'Function for letter request integrators' description FROM dual
SELECT FORM_NAME
, USER_FORM_NAME
, DESCRIPTION
FROM FND_FORM_VL
WHERE HR_GENERAL.CHK_APPLICATION_ID(APPLICATION_ID) = 'TRUE' UNION SELECT 'GENERAL' FORM_NAME
, 'GENERAL' USER_FORM_NAME
, 'FUNCTION FOR STANDALONE INTEGRATORS' DESCRIPTION
FROM DUAL UNION SELECT 'LETTER' FORM_NAME
, 'LETTERL' USER_FORM_NAME
, 'FUNCTION FOR LETTER REQUEST INTEGRATORS' DESCRIPTION
FROM DUAL
|
|
|