APPS.JA_CN_COA_EXP_PKG dependencies on FND_FLEX_VALUE_SETS

Line 181: ||' ,FND_FLEX_VALUE_SETS FFVS '

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 '
185: --Get all correct row of FFV

Line 229: ||' ,FND_FLEX_VALUE_SETS FFVS '

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 '
233: --Get all correct row of FFV

Line 284: ||' ,FND_FLEX_VALUE_SETS FFVS '

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 '
288: --Get all correct row of FFV

Line 358: ||' ,FND_FLEX_VALUE_SETS FFVS '

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
362: --||' ,JA_CN_ACCOUNT_BALANCES BAL '

Line 564: ,FND_FLEX_VALUE_SETS FFVS

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
568: WHERE --Get all correct row of FFV

Line 1171: ,FND_FLEX_VALUE_SETS FFVS

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
1175: AND BAL.account_segment IS NOT NULL

Line 1822: ,FND_FLEX_VALUE_SETS FFVS

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
1826: WHERE BAL.Ledger_Id = l_ledger_id --using variable l_sob_id