DBA Data[Home] [Help]

APPS.GMF_MIGRATION dependencies on FND_ID_FLEX_STRUCTURES

Line 1253: FROM fnd_id_flex_structures_vl fifs

1249: SELECT description
1250: FROM mtl_categories_vl
1251: WHERE structure_id IN (
1252: SELECT fifs.id_flex_num
1253: FROM fnd_id_flex_structures_vl fifs
1254: WHERE fifs.application_id = 401
1255: AND fifs.id_flex_code = 'MCAT'
1256: AND fifs.id_flex_structure_code = 'GL_BUSINESS_CLASS'
1257: AND enabled_flag = 'Y'

Line 1343: FROM fnd_id_flex_structures_vl fifs

1339: FROM mtl_categories_vl
1340: WHERE structure_id IN
1341: (
1342: SELECT fifs.id_flex_num
1343: FROM fnd_id_flex_structures_vl fifs
1344: WHERE fifs.application_id = 401
1345: AND fifs.id_flex_code = 'MCAT'
1346: AND fifs.id_flex_structure_code = 'GL_PRODUCT_LINE'
1347: AND enabled_flag = 'Y'

Line 1552: fnd_id_flex_structures fifstr,

1548: IS
1549: SELECT concatenated_segment_delimiter,
1550: glsob.chart_of_accounts_id
1551: FROM gl_sets_of_books glsob,
1552: fnd_id_flex_structures fifstr,
1553: fnd_application fa,
1554: gl_plcy_mst gpm
1555: WHERE glsob.chart_of_accounts_id = fifstr.id_flex_num
1556: AND fifstr.id_flex_code = 'GL#'

Line 6619: fnd_id_flex_structures_vl c

6615: c.id_flex_structure_code structure_code,
6616: c.id_flex_structure_name structure_name
6617: FROM gl_plcy_seg a,
6618: fnd_id_flex_segments b,
6619: fnd_id_flex_structures_vl c
6620: WHERE a.co_code = p_co_code
6621: AND b.segment_num = a.segment_ref
6622: AND b.id_flex_num = p_coa_id
6623: AND b.enabled_flag = 'Y'