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 AS_LEADS_ALL

Line 634: as_leads_all X,

630: COUNT(X.lead_id) actual_value, AL.activity_metric_id,
631: AL.func_actual_value
632: FROM
633: ams_source_codes C,
634: as_leads_all X,
635: ams_act_metrics_all AL, ams_metrics_all_b ALB
636: WHERE X.source_promotion_id(+) = C.source_code_id
637: AND AL.ARC_ACT_METRIC_USED_BY = C.arc_source_code_for
638: AND AL.metric_id = ALB.metric_id

Line 1190: as_leads_all X,

1186: COUNT(X.lead_id) actual_value, AL.activity_metric_id,
1187: AL.func_actual_value
1188: FROM
1189: ams_source_codes C,
1190: as_leads_all X,
1191: ams_act_metrics_all AL, ams_metrics_all_b ALB
1192: WHERE X.source_promotion_id(+) = C.source_code_id
1193: AND AL.ARC_ACT_METRIC_USED_BY = C.arc_source_code_for
1194: AND AL.metric_id = ALB.metric_id

Line 2156: FROM as_leads_all lead

2152: , actmet.func_actual_value
2153: FROM
2154: (
2155: SELECT lead.lead_id, list_parties.activity_metric_id
2156: FROM as_leads_all lead
2157: , (
2158: -- SELECT DISTINCT LIST OF B2C AND B2B PARTIES
2159: SELECT distinct A.activity_metric_id,
2160: decode(src.source_category,