VIEW: APPS.AST_SUSPENDED_SCRIPTS_V

Source

View Text - Preformatted

SELECT /*+ ORDERED USE_NL (a b c d a1 b1) */ a.dscript_name, p.panel_name, c.nls_language, d.end_time, r.source_name, b.transaction_id, a.dscript_id, r.resource_id, a.dscript_lang_id, b1.party_id FROM Jtf_ih_interactions b1, JTF_IH_ACTIVITIES a1, Ies_transactions b, Ies_deployed_scripts a, Fnd_languages c, Ies_trans_segments d, Jtf_rs_resource_extns r, Ies_panels p, Ies_panel_data p1 WHERE a.dscript_id = b.dscript_id and a.dscript_lang_id = c.language_id and r.user_id = d.created_by and p.panel_id = p1.panel_id and p1.transaction_id = b.transaction_id and b.transaction_id = d.transaction_id and b.transaction_id = a1.script_trans_id and b1.interaction_id = a1.interaction_id and b.status = 1 and a1.script_trans_id IS NOT NULL and a1.action_id = 23 and d.segment_id = (SELECT max(segment_id) FROM ies_trans_segments WHERE transaction_id = b.transaction_id) and p1.sequence_number = (SELECT max(sequence_number) FROM Ies_panel_data WHERE transaction_id = b.transaction_id) and a1.activity_id=(SELECT max(activity_id) FROM JTF_IH_ACTIVITIES ia WHERE b.transaction_id= ia.script_trans_id and ia.script_trans_id IS NOT NULL and ia.action_id = 23)

View Text - HTML Formatted

SELECT /*+ ORDERED USE_NL (A B C D A1 B1) */ A.DSCRIPT_NAME
, P.PANEL_NAME
, C.NLS_LANGUAGE
, D.END_TIME
, R.SOURCE_NAME
, B.TRANSACTION_ID
, A.DSCRIPT_ID
, R.RESOURCE_ID
, A.DSCRIPT_LANG_ID
, B1.PARTY_ID
FROM JTF_IH_INTERACTIONS B1
, JTF_IH_ACTIVITIES A1
, IES_TRANSACTIONS B
, IES_DEPLOYED_SCRIPTS A
, FND_LANGUAGES C
, IES_TRANS_SEGMENTS D
, JTF_RS_RESOURCE_EXTNS R
, IES_PANELS P
, IES_PANEL_DATA P1
WHERE A.DSCRIPT_ID = B.DSCRIPT_ID
AND A.DSCRIPT_LANG_ID = C.LANGUAGE_ID
AND R.USER_ID = D.CREATED_BY
AND P.PANEL_ID = P1.PANEL_ID
AND P1.TRANSACTION_ID = B.TRANSACTION_ID
AND B.TRANSACTION_ID = D.TRANSACTION_ID
AND B.TRANSACTION_ID = A1.SCRIPT_TRANS_ID
AND B1.INTERACTION_ID = A1.INTERACTION_ID
AND B.STATUS = 1
AND A1.SCRIPT_TRANS_ID IS NOT NULL
AND A1.ACTION_ID = 23
AND D.SEGMENT_ID = (SELECT MAX(SEGMENT_ID)
FROM IES_TRANS_SEGMENTS
WHERE TRANSACTION_ID = B.TRANSACTION_ID)
AND P1.SEQUENCE_NUMBER = (SELECT MAX(SEQUENCE_NUMBER)
FROM IES_PANEL_DATA
WHERE TRANSACTION_ID = B.TRANSACTION_ID)
AND A1.ACTIVITY_ID=(SELECT MAX(ACTIVITY_ID)
FROM JTF_IH_ACTIVITIES IA
WHERE B.TRANSACTION_ID= IA.SCRIPT_TRANS_ID
AND IA.SCRIPT_TRANS_ID IS NOT NULL
AND IA.ACTION_ID = 23)