VIEW: APPS.IEX_INTERACTION_HISTORY_V

Source

View Text - Preformatted

SELECT JIIN.interaction_id interaction_id, JIIN.start_date_time start_date_time, JREV.resource_name resource_name, (Select Decode(Nvl(Count(1), 0), 0, 'N', 'Y') from jtf_ih_activities where Interaction_id = JIIN.Interaction_Id AND doc_ref = 'IEX_DISPUTE') Disputed, (Select Decode(Nvl(Count(1), 0), 0, 'N', 'Y') from jtf_ih_activities where Interaction_id = JIIN.Interaction_Id AND doc_ref = 'IEX_PAYMENT') Paid, (Select Decode(Nvl(Count(1), 0), 0, 'N', 'Y') from jtf_ih_activities where Interaction_id = JIIN.Interaction_Id AND doc_ref = 'IEX_DUNNING') Corresponded, (Select Decode(Nvl(Count(1), 0), 0, 'N', 'Y') from jtf_ih_activities where Interaction_id = JIIN.Interaction_Id AND doc_ref = 'IEX_PROMISE') promise_to_pay, (Select Decode(Nvl(Count(1), 0), 0, 'N', 'Y') from jtf_ih_activities where Interaction_id = JIIN.Interaction_Id AND doc_ref = 'IEX_ADJUSTMENT') adjusted, JIIN.PARTY_ID From JTF_IH_INTERACTIONS JIIN, JTF_RS_RESOURCE_EXTNS_VL JREV WHERE JIIN.Resource_Id = JREV.resource_id

View Text - HTML Formatted

SELECT JIIN.INTERACTION_ID INTERACTION_ID
, JIIN.START_DATE_TIME START_DATE_TIME
, JREV.RESOURCE_NAME RESOURCE_NAME
, (SELECT DECODE(NVL(COUNT(1)
, 0)
, 0
, 'N'
, 'Y')
FROM JTF_IH_ACTIVITIES
WHERE INTERACTION_ID = JIIN.INTERACTION_ID
AND DOC_REF = 'IEX_DISPUTE') DISPUTED
, (SELECT DECODE(NVL(COUNT(1)
, 0)
, 0
, 'N'
, 'Y')
FROM JTF_IH_ACTIVITIES
WHERE INTERACTION_ID = JIIN.INTERACTION_ID
AND DOC_REF = 'IEX_PAYMENT') PAID
, (SELECT DECODE(NVL(COUNT(1)
, 0)
, 0
, 'N'
, 'Y')
FROM JTF_IH_ACTIVITIES
WHERE INTERACTION_ID = JIIN.INTERACTION_ID
AND DOC_REF = 'IEX_DUNNING') CORRESPONDED
, (SELECT DECODE(NVL(COUNT(1)
, 0)
, 0
, 'N'
, 'Y')
FROM JTF_IH_ACTIVITIES
WHERE INTERACTION_ID = JIIN.INTERACTION_ID
AND DOC_REF = 'IEX_PROMISE') PROMISE_TO_PAY
, (SELECT DECODE(NVL(COUNT(1)
, 0)
, 0
, 'N'
, 'Y')
FROM JTF_IH_ACTIVITIES
WHERE INTERACTION_ID = JIIN.INTERACTION_ID
AND DOC_REF = 'IEX_ADJUSTMENT') ADJUSTED
, JIIN.PARTY_ID
FROM JTF_IH_INTERACTIONS JIIN
, JTF_RS_RESOURCE_EXTNS_VL JREV
WHERE JIIN.RESOURCE_ID = JREV.RESOURCE_ID