DBA Data[Home] [Help]

APPS.AML_INTERACTION_ENGINE dependencies on AMS_SOURCE_CODES

Line 144: FROM ams_source_codes amsc,

140: amsc.source_code_id,
141: amsc.source_code_for_id, amsc.arc_source_code_for,
142: v.party_name, v.party_id, v.customer_id, v.address_id,
143: v.contact_party_id
144: FROM ams_source_codes amsc,
145: (
146: -- Interactions from OMO and customer is person or organization without
147: -- contact
148: SELECT interact.interaction_id, interact.source_code,

Line 364: FROM ams_source_codes amsc,

360: SELECT distinct aap.category_id, aap.category_set_id, aap.inventory_item_id,
361: aap.organization_id,
362: DECODE(aap.inventory_item_id, NULL, NULL, msi.primary_uom_code),
363: aap.quantity
364: FROM ams_source_codes amsc,
365: ams_act_products aap,
366: mtl_system_items_b msi,
367: (
368: SELECT jii.source_code