APPS.AML_INTERACTION_ENGINE dependencies on JTF_IH_INTERACTIONS

Line 133: FROM jtf_ih_interactions

129:
130:
131: CURSOR c_get_last_interaction_id(c_interaction_lookback NUMBER) IS
132: SELECT interaction_id
133: FROM jtf_ih_interactions
134: WHERE creation_date > (SYSDATE - c_interaction_lookback)
135: ORDER BY interaction_id;
136:
137: CURSOR c_get_interactions(c_last_interaction_id NUMBER,

Line 153: FROM jtf_ih_interactions interact, hz_parties party, hz_party_sites site

149: interact.source_code_id, party.party_name, party.party_type,
150: TO_NUMBER(NULL) party_id, interact.resource_id,
151: party.party_id customer_id, site.party_site_id address_id,
152: TO_NUMBER(NULL) contact_party_id
153: FROM jtf_ih_interactions interact, hz_parties party, hz_party_sites site
154: WHERE interact.party_id = party.party_id
155: AND interact.handler_id = 530 -- for Oracle Marketing
156: AND party.party_type IN ('PERSON', 'ORGANIZATION')
157: AND party.party_id = site.party_id(+)

Line 166: FROM jtf_ih_interactions interact, hz_parties party,

162: interact.source_code_id, party.party_name, party.party_type,
163: interact.party_id, interact.resource_id,
164: rel.object_id customer_id, site.party_site_id address_id,
165: rel.subject_id contact_party_id
166: FROM jtf_ih_interactions interact, hz_parties party,
167: hz_relationships rel, hz_party_sites site
168: WHERE interact.party_id = party.party_id
169: AND interact.handler_id = 530 -- for Oracle Marketing
170: AND party.party_type = 'PARTY_RELATIONSHIP'

Line 184: FROM jtf_ih_interactions interact, hz_parties party,

180: interact.source_code_id, party.party_name, party.party_type,
181: TO_NUMBER(NULL) party_id, interact.resource_id,
182: party.party_id customer_id, site.party_site_id address_id,
183: TO_NUMBER(NULL) contact_party_id
184: FROM jtf_ih_interactions interact, hz_parties party,
185: jtf_ih_activities acv, pv_process_rules_b rule,
186: pv_enty_select_criteria cra, pv_selected_attr_values val,
187: aml_business_event_types_b bet, hz_party_sites site
188: WHERE interact.party_id = party.party_id

Line 210: FROM jtf_ih_interactions interact, hz_parties party,

206: interact.source_code_id, party.party_name, party.party_type,
207: interact.party_id, interact.resource_id,
208: rel.object_id customer_id, site.party_site_id address_id,
209: rel.subject_id contact_party_id
210: FROM jtf_ih_interactions interact, hz_parties party,
211: hz_relationships rel, hz_party_sites site, jtf_ih_activities acv,
212: pv_process_rules_b rule, pv_enty_select_criteria cra,
213: pv_selected_attr_values val, aml_business_event_types_b bet
214: WHERE interact.party_id = party.party_id

Line 369: FROM jtf_ih_interactions jii

365: ams_act_products aap,
366: mtl_system_items_b msi,
367: (
368: SELECT jii.source_code
369: FROM jtf_ih_interactions jii
370: WHERE interaction_id = c_interaction_id
371: UNION ALL
372: SELECT jia.source_code
373: FROM jtf_ih_activities jia

Line 993: UPDATE jtf_ih_interactions

989: SET lead_rank_id = NULL, channel_code = NULL, interaction_score = l_lead_interaction_score
990: WHERE sales_lead_id = l_sales_lead_id;
991: Call Lead_Process_After_Update;
992: END IF;
993: UPDATE jtf_ih_interactions
994: SET sales_lead_id = l_sales_lead_id
995: WHERE interaction_id = l_interaction_id;
996: */
997: