VIEW: APPS.AST_AGENT_SCRIPTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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