APPS.JA_CN_COA_EXP_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 180: ||' ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV '

176: ||' ''/'') sub_item '
177: ||' ,nvl(FFV.' || l_acc_bal_position ||', '''') '
178: ||' acc_bal '
179: ||' FROM FND_ID_FLEX_SEGMENTS FIFS '
180: ||' ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV '
181: ||' ,FND_FLEX_VALUE_SETS FFVS '
182: ||' ,FND_FLEX_VALUES FFV '
183: --||' ,GL_LEDGERS LEDGER '
184: ||' WHERE '

Line 228: ||' ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV '

224: ||' ,DECODE(FFV.VALUE_CATEGORY,'''|| l_acc_bal_context ||''','
225: ||' nvl(FFV.' || l_acc_bal_position ||', ''''), '
226: ||' '''') acc_bal '
227: ||' FROM FND_ID_FLEX_SEGMENTS FIFS '
228: ||' ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV '
229: ||' ,FND_FLEX_VALUE_SETS FFVS '
230: ||' ,FND_FLEX_VALUES FFV '
231: --||' ,GL_LEDGERS LEDGER '
232: ||' WHERE '

Line 283: ||' ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV '

279: ||' DECODE(nvl(FFV.' || l_sub_person_position || ', '
280: ||' ''N''), ''Y'', ''Personnel/'', ''''), '
281: ||' ''/''), ''/'') sub_item '
282: ||' FROM FND_ID_FLEX_SEGMENTS FIFS '
283: ||' ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV '
284: ||' ,FND_FLEX_VALUE_SETS FFVS '
285: ||' ,FND_FLEX_VALUES FFV '
286: ||' ,GL_SETS_OF_BOOKS SOB '
287: ||' WHERE '

Line 357: ||' ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV '

353: ||' DECODE(nvl(FFV.' || l_sub_person_position || ', '
354: ||' ''N''), ''Y'', ''Personnel/'', ''''), '
355: ||' ''/''), ''/'') sub_item '
356: ||' FROM FND_ID_FLEX_SEGMENTS FIFS '
357: ||' ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV '
358: ||' ,FND_FLEX_VALUE_SETS FFVS '
359: ||' ,FND_FLEX_VALUES FFV '
360: ||' ,GL_SETS_OF_BOOKS SOB '
361: --Balane table used here only for project from Project Module

Line 563: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV

559: ) sub_item
560: ,nvl(sub.acc_bal, '') acc_bal
561: FROM JA_CN_ACC_SUBS_V sub
562: ,FND_ID_FLEX_SEGMENTS FIFS
563: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
564: ,FND_FLEX_VALUE_SETS FFVS
565: ,FND_FLEX_VALUES FFV
566: ,FND_FLEX_VALUES_TL FFVT
567: ,GL_LEDGERS ledger

Line 1170: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV

1166: FROM JA_CN_ACCOUNT_BALANCES BAL
1167: ,GL_LEDGERS LEDGER
1168: ,Ja_Cn_Sub_Acc_Sources_All SUBAS
1169: ,FND_ID_FLEX_SEGMENTS FIFS
1170: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
1171: ,FND_FLEX_VALUE_SETS FFVS
1172: ,FND_FLEX_VALUES_TL FFVT
1173: ,FND_FLEX_VALUES FFV
1174: WHERE BAL.Ledger_Id= l_ledger_id --using variable l_sob_id

Line 1821: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV

1817: FFV.FLEX_VALUE cc_number
1818: ,nvl(FFVT.description, '') cc_name
1819: FROM JA_CN_ACCOUNT_BALANCES BAL
1820: ,FND_ID_FLEX_SEGMENTS FIFS
1821: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
1822: ,FND_FLEX_VALUE_SETS FFVS
1823: ,FND_FLEX_VALUES_TL FFVT
1824: ,FND_FLEX_VALUES FFV
1825: ,GL_LEDGERS LEDGER