DBA Data[Home] [Help]

APPS.INV_ITEM_CATEGORY_PUB dependencies on FND_ID_FLEX_SEGMENTS

Line 1320: FROM fnd_id_flex_segments

1316: l_indx NUMBER;
1317:
1318: CURSOR segment_count(p_structure_id NUMBER) IS
1319: SELECT count(segment_num)
1320: FROM fnd_id_flex_segments
1321: WHERE application_id = G_INVENTORY_APP_ID
1322: AND id_flex_code = G_CAT_FLEX_CODE
1323: AND id_flex_num = p_structure_id
1324: AND (enabled_flag = 'Y' OR NVL(g_eni_upgarde_flag,'N') = 'Y');-- Added for 11.5.10 ENI Upgrade

Line 1329: FROM fnd_id_flex_segments

1325:
1326: --Bug: 3893482
1327: CURSOR c_get_segments(cp_flex_num NUMBER) IS
1328: SELECT application_column_name,rownum
1329: FROM fnd_id_flex_segments
1330: WHERE application_id = 401
1331: AND id_flex_code = 'MCAT'
1332: AND id_flex_num = cp_flex_num
1333: AND enabled_flag = 'Y'