View: AST_SUSPENDED_SCRIPTS_V

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

View Text

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)

Columns