APPS.FA_ASSET_TRACE_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 934: from fnd_id_flex_segments

930: l_calling_fn varchar2(40) := 'fa_asset_trace_pkg.get_dist_info';
931:
932: CURSOR c_coa_segs IS
933: SELECT APPLICATION_COLUMN_NAME, SEGMENT_NAME
934: from fnd_id_flex_segments
935: where application_id = 101
936: and id_flex_code = 'GL#'
937: AND ID_FLEX_NUM = l_flex_num;
938:

Line 1135: l_options_tbl(l_idx).l_add_clause := ' FROM FND_ID_FLEX_SEGMENTS_VL SEG, FND_FLEX_VALUE_SETS SETS, FND_SEGMENT_ATTRIBUTE_VALUES VAL,'

1131: l_options_tbl(l_idx).l_lcs := 'ID_FLEX_CODE';
1132: l_options_tbl(l_idx).l_lc_header := fparse_header('ID_FLEX_CODE');
1133: l_options_tbl(l_idx).l_leading_cols := fafsc('SEG.ID_FLEX_CODE');
1134: l_options_tbl(l_idx).l_num_cols := 2;
1135: l_options_tbl(l_idx).l_add_clause := ' FROM FND_ID_FLEX_SEGMENTS_VL SEG, FND_FLEX_VALUE_SETS SETS, FND_SEGMENT_ATTRIBUTE_VALUES VAL,'
1136: ||' FA_BOOK_CONTROLS FABC, FND_ID_FLEX_STRUCTURES_VL STRU WHERE SEG.flex_value_set_id = SETS.flex_value_set_id(+)'
1137: ||' AND SEG.id_flex_code in (''LOC#'',''CAT#'',''KEY#'',''GL#'') AND SEG.id_flex_code = VAL.id_flex_code(+)'
1138: ||' AND SEG.id_flex_num = VAL.id_flex_num(+) AND SEG.application_column_name = VAL.application_column_name(+)'
1139: ||' AND VAL.attribute_value(+) = ''Y'' AND VAL.segment_attribute_type(+) <> ''GL_GLOBAL'' AND SEG.id_flex_num = FABC.accounting_flex_structure'