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.

[Home] [Help]

APPS.GL_CONS_SEGMENT_MAP_PKG dependencies on FND_FLEX_VALUE_HIERARCHIES

Line 314: fnd_flex_value_hierarchies fvh_curr,

310: -- This only cathes overlaps with the same target specified.
311: CURSOR DUPS3 IS
312: select 'x'
313: from gl_cons_segment_map csm,
314: fnd_flex_value_hierarchies fvh_curr,
315: fnd_flex_value_hierarchies fvh_new
316: where coa_mapping_id = X_Coa_Mapping_id
317: and csm.to_application_column_name = X_To_Application_Column_Name
318: and csm.to_value_set_id = X_To_Value_Set_Id

Line 315: fnd_flex_value_hierarchies fvh_new

311: CURSOR DUPS3 IS
312: select 'x'
313: from gl_cons_segment_map csm,
314: fnd_flex_value_hierarchies fvh_curr,
315: fnd_flex_value_hierarchies fvh_new
316: where coa_mapping_id = X_Coa_Mapping_id
317: and csm.to_application_column_name = X_To_Application_Column_Name
318: and csm.to_value_set_id = X_To_Value_Set_Id
319: and single_value = X_Single_Value

Line 343: fnd_flex_value_hierarchies fvh

339: UNION
340: select 'x'
341: from gl_cons_flex_hierarchies cfh,
342: gl_cons_segment_map csm,
343: fnd_flex_value_hierarchies fvh
344: where csm.segment_map_id = cfh.segment_map_id
345: and csm.coa_mapping_id = X_Coa_Mapping_id
346: and single_value = X_Single_Value
347: and csm.to_application_column_name = X_To_Application_Column_Name

Line 374: fnd_flex_value_hierarchies fvh_curr,

370: -- This will catch overlaps that go to separate targets.
371: CURSOR DUPS4 IS
372: select 'x'
373: from gl_cons_segment_map csm,
374: fnd_flex_value_hierarchies fvh_curr,
375: fnd_flex_value_hierarchies fvh_new
376: where coa_mapping_id = X_Coa_Mapping_id
377: and csm.to_application_column_name = X_To_Application_Column_Name
378: and csm.to_value_set_id = X_To_Value_Set_Id

Line 375: fnd_flex_value_hierarchies fvh_new

371: CURSOR DUPS4 IS
372: select 'x'
373: from gl_cons_segment_map csm,
374: fnd_flex_value_hierarchies fvh_curr,
375: fnd_flex_value_hierarchies fvh_new
376: where coa_mapping_id = X_Coa_Mapping_id
377: and csm.to_application_column_name = X_To_Application_Column_Name
378: and csm.to_value_set_id = X_To_Value_Set_Id
379: and csm.from_application_column_name = X_from_Application_Column_Name

Line 402: fnd_flex_value_hierarchies fvh

398: UNION
399: select 'x'
400: from gl_cons_flex_hierarchies cfh,
401: gl_cons_segment_map csm,
402: fnd_flex_value_hierarchies fvh
403: where csm.segment_map_id = cfh.segment_map_id
404: and csm.coa_mapping_id = X_Coa_Mapping_id
405: and csm.to_application_column_name = X_To_Application_Column_Name
406: and csm.from_application_column_name = X_From_Application_Column_Name