DBA Data[Home] [Help]

APPS.INVKBCGN dependencies on FND_ID_FLEX_STRUCTURES

Line 1163: from fnd_id_flex_structures

1159: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1160: BEGIN
1161:
1162: Select id_flex_num into v_flex_num
1163: from fnd_id_flex_structures
1164: where id_flex_code = 'MTLL';
1165:
1166: Select project_reference_enabled into v_proj_ref_enabled
1167: from MTL_PARAMETERS

Line 1289: from fnd_id_flex_structures

1285: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1286: BEGIN
1287:
1288: Select id_flex_num into v_flex_num
1289: from fnd_id_flex_structures
1290: where id_flex_code = 'MSTK';
1291:
1292: v_delim := fnd_flex_ext.get_delimiter('INV','MSTK',v_flex_num);
1293: v_num := fnd_flex_ext.breakup_segments( X_item_lo, v_delim, seg_low);

Line 1446: from fnd_id_flex_structures

1442: from FND_ID_FLEX_SEGMENTS_VL a
1443: where a.application_id = 401 and
1444: a.id_flex_code = flex_code and
1445: a.id_flex_num = (select id_flex_num
1446: from fnd_id_flex_structures
1447: where id_flex_code = flex_code) and
1448: a.enabled_flag = 'Y' and
1449: a.display_flag = 'Y'
1450: order by a.segment_num;

Line 1457: from fnd_id_flex_structures

1453: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1454: BEGIN
1455:
1456: Select id_flex_num into v_flex_num
1457: from fnd_id_flex_structures
1458: where id_flex_code = 'MTLL';
1459:
1460: Select project_reference_enabled into v_proj_ref_enabled
1461: from MTL_PARAMETERS