View: AST_SOURCE_AVAIL_SCRIPTS_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_SOURCE_AVAIL_SCRIPTS_V

View Text

SELECT I.DSCRIPT_ID
, I.DSCRIPT_NAME
, F.NLS_LANGUAGE
, I.DSCRIPT_LANG_ID
, A.SOURCE_CODE_ID
FROM IES_DEPLOYED_SCRIPTS I
, FND_LANGUAGES F
, AMS_ACT_CONTACT_POINTS P
, AMS_SOURCE_CODES A
WHERE I.DSCRIPT_LANG_ID = F.LANGUAGE_ID
AND I.ACTIVE_STATUS = 1
AND I.DSCRIPT_NAME = P.CONTACT_POINT_VALUE
AND P.ACT_CONTACT_USED_BY_ID = A.SOURCE_CODE_FOR_ID
AND P.ARC_CONTACT_USED_BY = A.ARC_SOURCE_CODE_FOR
AND P.CONTACT_POINT_TYPE IN ('INBOUND_SCRIPT'
, 'OUTBOUND_SCRIPT')

Columns