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

Line 152: FROM eni_prod_den_hrchy_parents_v

148:
149: --08-MAY-2006 kdass bug 5199585 SQL ID# 17777526 - added last condition so that table uses index
150: /*CURSOR c_valid_prod_family (p_prod_name IN VARCHAR2) IS
151: SELECT category_id
152: FROM eni_prod_den_hrchy_parents_v
153: WHERE category_desc = p_prod_name
154: AND NVL(category_id, 0) = category_id;*/
155:
156: --nirprasa, the category passed to the API was being validated incorrectly.

Line 163: ENI_PROD_DEN_HRCHY_PARENTS_V d

159: SELECT c.category_id
160: FROM mtl_default_category_sets a ,
161: mtl_category_sets_b b ,
162: mtl_categories_v c ,
163: ENI_PROD_DEN_HRCHY_PARENTS_V d
164: WHERE a.functional_area_id in (7,11)
165: AND a.category_set_id = b.category_set_id
166: AND b.structure_id = c.structure_id
167: AND c.category_id = d.category_id(+)