VIEW: APPS.IES_SUSPENDED_TRANS_V

Source

View Text - Preformatted

SELECT b.transaction_id, a.dscript_id, a.dscript_name, c.nls_language DSCRIPT_LANGUAGE, srvs.survey_id SURVEY_CAMPAIGN_ID, deps.survey_deployment_id, rsp.response_id, f.user_name FND_USER_NAME, d.end_time SUSPEND_TIME, e.segment_count NUM_SEGMENTS FROM ies_deployed_scripts a, ies_transactions b, fnd_languages c, ies_trans_segments d, ies_trans_segments_count_v e, fnd_user f, ies_svy_response_entries rsp, ies_svy_surveys_all srvs, ies_svy_cycles_all cycls, ies_svy_deplyments_all deps WHERE a.dscript_id = b.dscript_id AND a.dscript_lang_id = c.language_id AND b.transaction_id = d.transaction_id AND e.transaction_id = b.transaction_id AND d.created_by = f.user_id AND b.status = 1 AND d.segment_id = (SELECT max(segment_id) FROM ies_trans_segments WHERE transaction_id = b.transaction_id) AND b.transaction_id = rsp.transaction_id (+) AND rsp.survey_deployment_id = deps.survey_deployment_id (+) AND deps.survey_cycle_id = cycls.survey_cycle_id (+) AND cycls.survey_id = srvs.survey_id (+)

View Text - HTML Formatted

SELECT B.TRANSACTION_ID
, A.DSCRIPT_ID
, A.DSCRIPT_NAME
, C.NLS_LANGUAGE DSCRIPT_LANGUAGE
, SRVS.SURVEY_ID SURVEY_CAMPAIGN_ID
, DEPS.SURVEY_DEPLOYMENT_ID
, RSP.RESPONSE_ID
, F.USER_NAME FND_USER_NAME
, D.END_TIME SUSPEND_TIME
, E.SEGMENT_COUNT NUM_SEGMENTS
FROM IES_DEPLOYED_SCRIPTS A
, IES_TRANSACTIONS B
, FND_LANGUAGES C
, IES_TRANS_SEGMENTS D
, IES_TRANS_SEGMENTS_COUNT_V E
, FND_USER F
, IES_SVY_RESPONSE_ENTRIES RSP
, IES_SVY_SURVEYS_ALL SRVS
, IES_SVY_CYCLES_ALL CYCLS
, IES_SVY_DEPLYMENTS_ALL DEPS
WHERE A.DSCRIPT_ID = B.DSCRIPT_ID
AND A.DSCRIPT_LANG_ID = C.LANGUAGE_ID
AND B.TRANSACTION_ID = D.TRANSACTION_ID
AND E.TRANSACTION_ID = B.TRANSACTION_ID
AND D.CREATED_BY = F.USER_ID
AND B.STATUS = 1
AND D.SEGMENT_ID = (SELECT MAX(SEGMENT_ID)
FROM IES_TRANS_SEGMENTS
WHERE TRANSACTION_ID = B.TRANSACTION_ID)
AND B.TRANSACTION_ID = RSP.TRANSACTION_ID (+)
AND RSP.SURVEY_DEPLOYMENT_ID = DEPS.SURVEY_DEPLOYMENT_ID (+)
AND DEPS.SURVEY_CYCLE_ID = CYCLS.SURVEY_CYCLE_ID (+)
AND CYCLS.SURVEY_ID = SRVS.SURVEY_ID (+)