eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_ACTMETRICS_SEED_PVT dependencies on AMS_ACT_PRODUCTS

Line 2702: from as_sales_lead_lines LL, ams_act_products actprod

2698: and lead.primary_contact_party_id = csch_parties.contact_rel_party_id))
2699: and lead.creation_date between csch_parties.last_activation_date
2700: and csch_parties.last_activation_date + l_inferred_period
2701: AND exists (select 1
2702: from as_sales_lead_lines LL, ams_act_products actprod
2703: where ll.inventory_item_id = actprod.INVENTORY_ITEM_ID
2704: and ll.organization_id = actprod.organization_id
2705: and ll.sales_lead_id = lead.sales_lead_id
2706: and actprod.arc_act_product_used_by = 'CSCH'

Line 2817: from as_sales_lead_lines LL, ams_act_products actprod

2813: and lead.primary_contact_party_id = csch_parties.contact_rel_party_id))
2814: and lead.creation_date between csch_parties.last_activation_date
2815: and csch_parties.last_activation_date + l_inferred_period
2816: AND exists (select 1
2817: from as_sales_lead_lines LL, ams_act_products actprod
2818: where ll.inventory_item_id = actprod.INVENTORY_ITEM_ID
2819: and ll.organization_id = actprod.organization_id
2820: and ll.sales_lead_id = lead.sales_lead_id
2821: and actprod.arc_act_product_used_by = 'CSCH'

Line 2937: ams_act_products aprod

2933: ) csch_parties,
2934: hz_cust_accounts account,
2935: oe_order_headers_all H,
2936: oe_order_lines_all I,
2937: ams_act_products aprod
2938: where csch_parties.primary_party_id = account.party_id
2939: AND H.sold_to_org_id = account.cust_account_id
2940: AND ((source_category = 'B2B'
2941: AND exists (select 1 from hz_cust_account_roles roles

Line 3082: ams_act_products aprod

3078: ) csch_parties,
3079: hz_cust_accounts account,
3080: oe_order_headers_all H,
3081: oe_order_lines_all I,
3082: ams_act_products aprod
3083: where csch_parties.primary_party_id = account.party_id
3084: AND H.sold_to_org_id = account.cust_account_id
3085: AND ((source_category = 'B2B'
3086: AND exists (select 1 from hz_cust_account_roles roles

Line 3413: ams_act_products aprod,

3409: sum(nvl(I.ordered_quantity * I.unit_selling_price,0)) booked_revenue,
3410: csch_parties.ACTIVITY_METRIC_ID,
3411: primary_party_id, contact_rel_party_id
3412: from AMS_INFMET_ORDER_GT csch_parties,
3413: ams_act_products aprod,
3414: hz_cust_accounts account,
3415: oe_order_headers_all H,
3416: oe_order_lines_all I
3417: where csch_parties.primary_party_id = account.party_id

Line 3556: from as_sales_lead_lines LL, ams_act_products actprod

3552: and lead.creation_date between csch_parties.last_activation_date
3553: and csch_parties.last_activation_date + l_inferred_period
3554: -- and csch_parties.last_activation_date + 90
3555: AND exists (select 1
3556: from as_sales_lead_lines LL, ams_act_products actprod
3557: where ll.inventory_item_id = actprod.INVENTORY_ITEM_ID
3558: and ll.organization_id = actprod.organization_id
3559: and ll.sales_lead_id = lead.sales_lead_id
3560: and actprod.arc_act_product_used_by = 'CSCH'