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 234: ff_fdi_usages_f b

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

Line 313: from ff_fdi_usages_f b,

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

Line 392: from ff_fdi_usages_f b,

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

Line 433: from ff_fdi_usages_f b,

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

Line 573: from ff_fdi_usages_f b,

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

Line 665: from ff_fdi_usages_f b,

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

Line 2134: INDEX(A FF_FDI_USAGES_F_N50) */

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

Line 2138: ff_fdi_usages_f a

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

Line 2203: INDEX(A FF_FDI_USAGES_F_N50)

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

Line 2206: ff_fdi_usages_f a,

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

Line 2490: ff_fdi_usages_f b,

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