Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_AGENT_SCRIPTS_V |
SELECT SCR.DSCRIPT_ID
, DECODE(SCR.ACTIVE_STATUS
, 0
, 'N'
, 'Y')
, SCR.DSCRIPT_NAME
, SCR.DESCRIPTION
, SCR.DSCRIPT_LANG_ID
, LNG.DESCRIPTION LANGUAGE_DESCRIPTION
, LNG.NLS_LANGUAGE
, SCR.CREATED_BY
, SCR.CREATION_DATE
, SCR.LAST_UPDATE_DATE
, PER.FULL_NAME CREATED_BY_NAME
, SCR.APPLICATION_ID
, SCR.FUNCTION_ID
, SCR.SCRIPT_TYPE
FROM IES_DEPLOYED_SCRIPTS SCR
, FND_LANGUAGES_VL LNG
, FND_USER USR
, PER_ALL_PEOPLE_F PER
WHERE LNG.LANGUAGE_ID = SCR.DSCRIPT_LANG_ID
AND USR.USER_ID (+) = SCR.CREATED_BY
AND PER.PERSON_ID (+) = USR.EMPLOYEE_ID