DBA Data[Home] [Help]

APPS.GMF_MIGRATION dependencies on FND_ID_FLEX_STRUCTURES_VL

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 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'