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.FII_GL_CCID_C dependencies on FND_ID_FLEX_SEGMENTS

Line 441: fnd_id_flex_segments seg1,

437: and nvl(udd1_seg_name, 1) = nvl(''' || p_ud1_seg || ''',1)
438: and nvl(udd2_seg_name, 1) =nvl(''' || p_ud2_seg || ''',1)
439: ) accts,
440: FII_CCID_SLG_GT csg,
441: fnd_id_flex_segments seg1,
442: fnd_id_flex_segments seg2,
443: fnd_id_flex_segments seg3,
444: GL_CODE_COMBINATIONS glcc,
445: fnd_flex_values flx1,

Line 442: fnd_id_flex_segments seg2,

438: and nvl(udd2_seg_name, 1) =nvl(''' || p_ud2_seg || ''',1)
439: ) accts,
440: FII_CCID_SLG_GT csg,
441: fnd_id_flex_segments seg1,
442: fnd_id_flex_segments seg2,
443: fnd_id_flex_segments seg3,
444: GL_CODE_COMBINATIONS glcc,
445: fnd_flex_values flx1,
446: fnd_flex_values flx2,

Line 443: fnd_id_flex_segments seg3,

439: ) accts,
440: FII_CCID_SLG_GT csg,
441: fnd_id_flex_segments seg1,
442: fnd_id_flex_segments seg2,
443: fnd_id_flex_segments seg3,
444: GL_CODE_COMBINATIONS glcc,
445: fnd_flex_values flx1,
446: fnd_flex_values flx2,
447: fnd_flex_values flx3 ';

Line 619: fnd_id_flex_segments seg1,

615: and nvl(udd1_seg_name, 1) = nvl('''|| p_ud1_seg ||''',1)
616: and nvl(udd2_seg_name, 1) =nvl('''|| p_ud2_seg ||''',1)
617: ) accts,
618: FII_CCID_SLG_GT csg,
619: fnd_id_flex_segments seg1,
620: fnd_id_flex_segments seg2,
621: fnd_id_flex_segments seg3,
622: GL_CODE_COMBINATIONS glcc,
623: fnd_flex_values flx1,

Line 620: fnd_id_flex_segments seg2,

616: and nvl(udd2_seg_name, 1) =nvl('''|| p_ud2_seg ||''',1)
617: ) accts,
618: FII_CCID_SLG_GT csg,
619: fnd_id_flex_segments seg1,
620: fnd_id_flex_segments seg2,
621: fnd_id_flex_segments seg3,
622: GL_CODE_COMBINATIONS glcc,
623: fnd_flex_values flx1,
624: fnd_flex_values flx2,

Line 621: fnd_id_flex_segments seg3,

617: ) accts,
618: FII_CCID_SLG_GT csg,
619: fnd_id_flex_segments seg1,
620: fnd_id_flex_segments seg2,
621: fnd_id_flex_segments seg3,
622: GL_CODE_COMBINATIONS glcc,
623: fnd_flex_values flx1,
624: fnd_flex_values flx2,
625: fnd_flex_values flx3 ';

Line 1207: fnd_id_flex_segments seg1,

1203: SET (glcc.product_id, glcc.PROD_CATEGORY_ID) =
1204: (SELECT flx1.flex_value_id, mtc.category_id
1205: FROM gl_code_combinations glccd,
1206: mtl_categories mtc,
1207: fnd_id_flex_segments seg1,
1208: fnd_flex_values flx1
1209: WHERE glccd.code_combination_id = glcc.code_combination_id
1210: AND mtc.structure_id = ' || g_mtc_structure_id || '
1211: AND mtc.' || g_mtc_column_name || ' = glccd.' || p_product_seg || '

Line 1997: from fnd_id_flex_segments

1993: --associated with the structure. So we get segment name as:
1994: SELECT application_column_name into g_mtc_column_name
1995: FROM
1996: (select application_column_name
1997: from fnd_id_flex_segments
1998: where application_id = 401
1999: and id_flex_code = 'MCAT'
2000: and id_flex_num = g_mtc_structure_id
2001: and flex_value_set_id = g_mtc_value_set_id