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.FFDICT dependencies on FF_FDI_USAGES_F

Line 235: ff_fdi_usages_f b

231: -- the business group of the formula
232: select 'X' into dummy from dual where exists
233: (select null
234: from ff_formulas_f a,
235: ff_fdi_usages_f b
236: where a.formula_id = b.formula_id
237: and (b.item_name = p_item_name or
238: b.alternative_item_name = p_item_name)
239: and

Line 314: from ff_fdi_usages_f b,

310: -- the business group of the formula
311: --
312: select 'X' into dummy from dual where exists
313: (select null
314: from ff_fdi_usages_f b,
315: ff_formulas_f a
316: where b.alternative_item_name = p_tl_user_name
317: and a.formula_id = b.formula_id
318: and a.effective_start_date = b.effective_start_date

Line 393: from ff_fdi_usages_f b,

389: , b.effective_start_date
390: , b.effective_end_date
391: , a.business_group_id
392: , a.legislation_code
393: from ff_fdi_usages_f b,
394: ff_formulas_f a
395: where b.alternative_item_name = p_tl_user_name
396: and a.formula_id = b.formula_id
397: and a.effective_start_date = b.effective_start_date

Line 434: from ff_fdi_usages_f b,

430: , b.effective_start_date
431: , b.effective_end_date
432: , a.business_group_id
433: , a.legislation_code
434: from ff_fdi_usages_f b,
435: ff_formulas_f a
436: where b.item_name = p_tl_user_name
437: and a.formula_id = b.formula_id
438: and a.effective_start_date = b.effective_start_date

Line 574: from ff_fdi_usages_f b,

570: -- the business group of the formula
571: --
572: select 'X' into dummy from dual where exists
573: (select null
574: from ff_fdi_usages_f b,
575: ff_formulas_f a
576: where b.item_name = p_user_name
577: and a.formula_id = b.formula_id
578: and a.effective_start_date = b.effective_start_date

Line 666: from ff_fdi_usages_f b,

662: -- the business group of the formula.
663: --
664: select 'X' into dummy from dual where exists
665: (select null
666: from ff_fdi_usages_f b,
667: ff_formulas_f a
668: where b.item_name = p_item_name
669: and b.usage <> 'D'
670: and a.formula_id = b.formula_id

Line 2137: INDEX(A FF_FDI_USAGES_F_N50) */

2133: (
2134: select /*+ ORDERED
2135: INDEX(C FF_USER_ENTITIES_FK1)
2136: INDEX(B FF_DATABASE_ITEMS_FK1)
2137: INDEX(A FF_FDI_USAGES_F_N50) */
2138: null
2139: from ff_user_entities c,
2140: ff_database_items b,
2141: ff_fdi_usages_f a

Line 2141: ff_fdi_usages_f a

2137: INDEX(A FF_FDI_USAGES_F_N50) */
2138: null
2139: from ff_user_entities c,
2140: ff_database_items b,
2141: ff_fdi_usages_f a
2142: where a.item_name = b.user_name
2143: and a.usage = 'D'
2144: and b.user_entity_id = c.user_entity_id
2145: and c.route_id = p_route_id

Line 2206: INDEX(A FF_FDI_USAGES_F_N50)

2202: where exists
2203: (
2204: select /*+ ORDERED
2205: INDEX(C FF_DATABASE_ITEMS_FK1)
2206: INDEX(A FF_FDI_USAGES_F_N50)
2207: INDEX(B FF_FORMULAS_F_PK) */ null
2208: from ff_database_items c,
2209: ff_fdi_usages_f a,
2210: ff_formulas_f b

Line 2209: ff_fdi_usages_f a,

2205: INDEX(C FF_DATABASE_ITEMS_FK1)
2206: INDEX(A FF_FDI_USAGES_F_N50)
2207: INDEX(B FF_FORMULAS_F_PK) */ null
2208: from ff_database_items c,
2209: ff_fdi_usages_f a,
2210: ff_formulas_f b
2211: where a.formula_id = b.formula_id
2212: and a.item_name = c.user_name
2213: and a.usage = 'D'

Line 2493: ff_fdi_usages_f b,

2489: select 'X' into dummy from dual
2490: where exists
2491: (
2492: select null from ff_formulas_f a,
2493: ff_fdi_usages_f b,
2494: ff_contexts c
2495: where a.formula_type_id = p_ftype_id
2496: and a.formula_id = b.formula_id
2497: and b.item_name = upper(c.context_name)