DBA Data[Home] [Help]

APPS.INVKBCGN dependencies on FND_ID_FLEX_STRUCTURES

Line 1589: from fnd_id_flex_structures

1585: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1586: BEGIN
1587:
1588: Select id_flex_num into v_flex_num
1589: from fnd_id_flex_structures
1590: where id_flex_code = 'MTLL';
1591:
1592: Select project_reference_enabled into v_proj_ref_enabled
1593: from MTL_PARAMETERS

Line 1715: from fnd_id_flex_structures

1711: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1712: BEGIN
1713:
1714: Select id_flex_num into v_flex_num
1715: from fnd_id_flex_structures
1716: where id_flex_code = 'MSTK';
1717:
1718: v_delim := fnd_flex_ext.get_delimiter('INV','MSTK',v_flex_num);
1719: v_num := fnd_flex_ext.breakup_segments( X_item_lo, v_delim, seg_low);

Line 1899: from fnd_id_flex_structures

1895: from FND_ID_FLEX_SEGMENTS_VL a
1896: where a.application_id = 401 and
1897: a.id_flex_code = flex_code and
1898: a.id_flex_num = (select id_flex_num
1899: from fnd_id_flex_structures
1900: where id_flex_code = flex_code) and
1901: a.enabled_flag = 'Y' and
1902: a.display_flag = 'Y'
1903: order by a.segment_num;

Line 1910: from fnd_id_flex_structures

1906: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1907: BEGIN
1908:
1909: Select id_flex_num into v_flex_num
1910: from fnd_id_flex_structures
1911: where id_flex_code = 'MTLL';
1912:
1913: Select project_reference_enabled into v_proj_ref_enabled
1914: from MTL_PARAMETERS