VIEW: APPS.AST_SOURCE_AVAIL_SCRIPTS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')