DBA Data[Home] [Help]

APPS.IEX_CALL_HISTORY dependencies on JTF_RS_RESOURCE_EXTNS_VL

Line 67: JTF_RS_RESOURCE_EXTNS_VL JREV

63: Select JIIN.interaction_id ,
64: JIIN.start_date_time ,
65: JREV.resource_name
66: From JTF_IH_INTERACTIONS JIIN ,
67: JTF_RS_RESOURCE_EXTNS_VL JREV
68: where JIIN.party_id = p_party_id
69: AND JIIN.start_date_time
70: BETWEEN p_from_date and (p_to_date + 1)
71: AND JIIN.Resource_Id = JREV.resource_id

Line 83: JTF_RS_RESOURCE_EXTNS_VL JREV,

79: Select JIIN.interaction_id ,
80: JIIN.start_date_time ,
81: JREV.resource_name
82: From JTF_IH_INTERACTIONS JIIN ,
83: JTF_RS_RESOURCE_EXTNS_VL JREV,
84: JTF_IH_ACTIVITIES JIA
85: where JIA.cust_account_id = p_cust_account_id
86: AND JIA.Interaction_Id = JIIN.Interaction_Id
87: AND JIIN.Resource_Id = JREV.resource_id