DBA Data[Home] [Help]

APPS.INVKBCGN dependencies on FND_ID_FLEX_SEGMENTS_VL

Line 1573: from FND_ID_FLEX_SEGMENTS_VL a, FND_FLEX_VALUE_SETS b

1569: seg_high fnd_flex_ext.SegmentArray;
1570:
1571: Cursor CUR1(v_struct_num Number) is
1572: select a.application_column_name, b.format_type
1573: from FND_ID_FLEX_SEGMENTS_VL a, FND_FLEX_VALUE_SETS b
1574: where a.application_id = 401 and
1575: a.id_flex_code = 'MTLL' and
1576: a.id_flex_num = v_struct_num and
1577: a.enabled_flag = 'Y' and

Line 1700: from FND_ID_FLEX_SEGMENTS_VL a, FND_FLEX_VALUE_SETS b

1696:
1697:
1698: Cursor CUR1(v_struct_num Number) is
1699: select a.application_column_name, b.format_type
1700: from FND_ID_FLEX_SEGMENTS_VL a, FND_FLEX_VALUE_SETS b
1701: where a.application_id = 401 and
1702: a.id_flex_code = 'MSTK' and
1703: a.id_flex_num = v_struct_num and
1704: a.enabled_flag = 'Y' and

Line 1895: from FND_ID_FLEX_SEGMENTS_VL a

1891: d_data_str varchar2(1000) := null;
1892:
1893: Cursor CUR1(flex_code varchar2) is
1894: select a.application_column_name
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