APPS.INV_ITEM_CATEGORY_PUB dependencies on FND_ID_FLEX_SEGMENTS

Line 1339: FROM fnd_id_flex_segments

1335: l_indx NUMBER;
1336:
1337: CURSOR segment_count(p_structure_id NUMBER) IS
1338: SELECT count(segment_num)
1339: FROM fnd_id_flex_segments
1340: WHERE application_id = G_INVENTORY_APP_ID
1341: AND id_flex_code = G_CAT_FLEX_CODE
1342: AND id_flex_num = p_structure_id
1343: AND (enabled_flag = 'Y' OR NVL(g_eni_upgarde_flag,'N') = 'Y');-- Added for 11.5.10 ENI Upgrade

Line 1348: FROM fnd_id_flex_segments

1344:
1345: --Bug: 3893482
1346: CURSOR c_get_segments(cp_flex_num NUMBER) IS
1347: SELECT application_column_name,rownum
1348: FROM fnd_id_flex_segments
1349: WHERE application_id = 401
1350: AND id_flex_code = 'MCAT'
1351: AND id_flex_num = cp_flex_num
1352: AND enabled_flag = 'Y'

Line 3659: FROM fnd_id_flex_segments

3655: l_msg_text VARCHAR2(1000);
3656:
3657: CURSOR segment_count(p_structure_id NUMBER) IS
3658: SELECT count(segment_num)
3659: FROM fnd_id_flex_segments
3660: WHERE application_id = G_INVENTORY_APP_ID
3661: AND id_flex_code = G_CAT_FLEX_CODE
3662: AND id_flex_num = p_structure_id
3663: AND (enabled_flag = 'Y' OR NVL(g_eni_upgarde_flag,'N') = 'Y');-- Added for 11.5.10 ENI Upgrade

Line 3667: FROM fnd_id_flex_segments

3663: AND (enabled_flag = 'Y' OR NVL(g_eni_upgarde_flag,'N') = 'Y');-- Added for 11.5.10 ENI Upgrade
3664:
3665: CURSOR c_get_segments(cp_flex_num NUMBER) IS
3666: SELECT application_column_name,rownum
3667: FROM fnd_id_flex_segments
3668: WHERE application_id = 401
3669: AND id_flex_code = 'MCAT'
3670: AND id_flex_num = cp_flex_num
3671: AND enabled_flag = 'Y'