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.PV_WORKFLOW_PUB dependencies on ENI_PROD_DEN_HRCHY_PARENTS_V

Line 2640: from as_leads_all a, as_lead_lines_all b, eni_prod_den_hrchy_parents_v c

2636: -- Eliminated reference to wf_notifications from all the queries
2637: -- ----------------------------------------------------------------------------------
2638: cursor lc_get_products (pc_entity_id number, pc_notification_id number) is
2639: select c.CONCAT_CAT_PARENTAGE, decode(nvl(b.total_amount,0),0,'', b.total_amount || ' ' || a.currency_code) amount
2640: from as_leads_all a, as_lead_lines_all b, eni_prod_den_hrchy_parents_v c
2641: where a.lead_id = pc_entity_id
2642: and a.lead_id = b.lead_id
2643: and b.product_cat_set_id = c.category_set_id
2644: and b.product_category_id = c.category_id;

Line 2648: from as_leads_all a, as_lead_lines_all b, eni_prod_den_hrchy_parents_v c

2644: and b.product_category_id = c.category_id;
2645:
2646: cursor lc_max_products_length (pc_entity_id number, pc_notification_id number) is
2647: select max(length(c.CONCAT_CAT_PARENTAGE)), max(length(to_char(b.total_amount) || ' ' || a.currency_code))
2648: from as_leads_all a, as_lead_lines_all b, eni_prod_den_hrchy_parents_v c
2649: where a.lead_id = pc_entity_id
2650: and a.lead_id = b.lead_id
2651: and b.product_cat_set_id = c.category_set_id
2652: and b.product_category_id = c.category_id;