APPS.FA_ASSET_TRACE_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 963: from fnd_id_flex_segments

959: l_calling_fn varchar2(40) := 'fa_asset_trace_pkg.get_dist_info';
960:
961: CURSOR c_coa_segs IS
962: SELECT APPLICATION_COLUMN_NAME, SEGMENT_NAME
963: from fnd_id_flex_segments
964: where application_id = 101
965: and id_flex_code = 'GL#'
966: AND ID_FLEX_NUM = l_flex_num;
967:

Line 1168: 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,'

1164: l_options_tbl(l_idx).l_lcs := 'ID_FLEX_CODE';
1165: l_options_tbl(l_idx).l_lc_header := fparse_header('ID_FLEX_CODE');
1166: l_options_tbl(l_idx).l_leading_cols := fafsc('SEG.ID_FLEX_CODE');
1167: l_options_tbl(l_idx).l_num_cols := 2;
1168: 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,'
1169: ||' FA_BOOK_CONTROLS FABC, FND_ID_FLEX_STRUCTURES_VL STRU WHERE SEG.flex_value_set_id = SETS.flex_value_set_id(+)'
1170: ||' AND SEG.id_flex_code in (''LOC#'',''CAT#'',''KEY#'',''GL#'') AND SEG.id_flex_code = VAL.id_flex_code(+)'
1171: ||' AND SEG.id_flex_num = VAL.id_flex_num(+) AND SEG.application_column_name = VAL.application_column_name(+)'
1172: ||' AND VAL.attribute_value(+) = ''Y'' AND VAL.segment_attribute_type(+) <> ''GL_GLOBAL'' AND SEG.id_flex_num = FABC.accounting_flex_structure'