APPS.JA_CN_COA_EXPORT_PKG dependencies on FND_FLEX_VALUES

Line 96: -- while using Global Data Elements, the value of FND_FLEX_VALUES.VALUE_CATEGORY will be null

92: -- and item of project, third party, cost center and personnel and Balance Side
93: -- of all accounts.
94:
95: -- add Global Data Elements supporting
96: -- while using Global Data Elements, the value of FND_FLEX_VALUES.VALUE_CATEGORY will be null
97: IF 'Global Data Elements'=nvl(l_acc_level_context,'') THEN
98: l_sql_str :=
99: 'SELECT DISTINCT '
100: ||' FFV.FLEX_VALUE acc_number '

Line 110: ||' ,FND_FLEX_VALUES FFV '

106: ||' acc_bal '
107: ||' FROM FND_ID_FLEX_SEGMENTS FIFS '
108: ||' ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV '
109: ||' ,FND_FLEX_VALUE_SETS FFVS '
110: ||' ,FND_FLEX_VALUES FFV '
111: --||' ,GL_LEDGERS LEDGER '
112: ||' WHERE '
113: --Get all correct row of FFV
114: --||' LEDGER.ledger_id = ' || l_LEDGER_id

Line 142: ||' ,FND_FLEX_VALUES FFV '

138: ||' '''') acc_bal '
139: ||' FROM FND_ID_FLEX_SEGMENTS FIFS '
140: ||' ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV '
141: ||' ,FND_FLEX_VALUE_SETS FFVS '
142: ||' ,FND_FLEX_VALUES FFV '
143: --||' ,GL_LEDGERS LEDGER '
144: ||' WHERE '
145: --Get all correct row of FFV
146: --||' LEDGER.ledger_id = ' || l_LEDGER_id

Line 238: l_na_number FND_FLEX_VALUES.FLEX_VALUE%TYPE;

234: l_acc_seg_serial NUMBER;
235: TYPE t_level_seg_lens IS TABLE OF NUMBER;
236: l_acc_seg_lens t_level_seg_lens;
237:
238: l_na_number FND_FLEX_VALUES.FLEX_VALUE%TYPE;
239: l_na_name FND_FLEX_VALUES_TL.description%TYPE;
240: l_na_parent VARCHAR2(1);
241: l_na_level VARCHAR2(100);
242: l_na_sub_flag VARCHAR2(1);

Line 239: l_na_name FND_FLEX_VALUES_TL.description%TYPE;

235: TYPE t_level_seg_lens IS TABLE OF NUMBER;
236: l_acc_seg_lens t_level_seg_lens;
237:
238: l_na_number FND_FLEX_VALUES.FLEX_VALUE%TYPE;
239: l_na_name FND_FLEX_VALUES_TL.description%TYPE;
240: l_na_parent VARCHAR2(1);
241: l_na_level VARCHAR2(100);
242: l_na_sub_flag VARCHAR2(1);
243: l_na_sub_item VARCHAR2(100);

Line 314: ,FND_FLEX_VALUES FFV

310: FROM JA_CN_ACC_SUBS_V sub
311: ,FND_ID_FLEX_SEGMENTS FIFS
312: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
313: ,FND_FLEX_VALUE_SETS FFVS
314: ,FND_FLEX_VALUES FFV
315: ,FND_FLEX_VALUES_TL FFVT
316: ,GL_LEDGERS ledger
317: WHERE --Get all correct row of FFV
318: ledger.ledger_id = l_ledger_id --using variable l_sob_id

Line 315: ,FND_FLEX_VALUES_TL FFVT

311: ,FND_ID_FLEX_SEGMENTS FIFS
312: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
313: ,FND_FLEX_VALUE_SETS FFVS
314: ,FND_FLEX_VALUES FFV
315: ,FND_FLEX_VALUES_TL FFVT
316: ,GL_LEDGERS ledger
317: WHERE --Get all correct row of FFV
318: ledger.ledger_id = l_ledger_id --using variable l_sob_id
319: AND ledger.chart_of_accounts_id = FIFS.id_flex_num