APPS.INV_ITEM_CATEGORY_PUB dependencies on FND_ID_FLEX_STRUCTURES

Line 559: FROM fnd_id_flex_structures

555: l_flexstr_exists VARCHAR2(1);
556:
557: CURSOR get_structure_id(p_structure_code VARCHAR) IS
558: SELECT id_flex_num
559: FROM fnd_id_flex_structures
560: WHERE application_id = G_INVENTORY_APP_ID
561: AND id_flex_code = G_CAT_FLEX_CODE
562: AND id_flex_structure_code = p_structure_code
563: AND enabled_flag = 'Y';

Line 572: FROM fnd_id_flex_structures

568: WHERE category_id = p_category_id;
569:
570: CURSOR validate_structure_id(p_structure_id VARCHAR) IS
571: SELECT 'x'
572: FROM fnd_id_flex_structures
573: WHERE application_id = G_INVENTORY_APP_ID
574: AND id_flex_code = G_CAT_FLEX_CODE
575: AND id_flex_num = p_structure_id
576: AND enabled_flag = 'Y';