APPS.JA_CN_COA_EXP_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 179: ||' FROM FND_ID_FLEX_SEGMENTS FIFS '

175: ||' ''N''), ''Y'', ''Personnel/'', ''''), '
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 '

Line 227: ||' FROM FND_ID_FLEX_SEGMENTS FIFS '

223: ||' ''/''), ''/'') sub_item '
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 '

Line 282: ||' FROM FND_ID_FLEX_SEGMENTS FIFS '

278: ||' ''Y'', ''Cost Center/'', '''')|| '
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 '

Line 356: ||' FROM FND_ID_FLEX_SEGMENTS FIFS '

352: ||' ''Y'', ''Cost Center/'', '''')|| '
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 '

Line 562: ,FND_ID_FLEX_SEGMENTS FIFS

558: ), 'Personnel', l_personnel_meaning
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

Line 1169: ,FND_ID_FLEX_SEGMENTS FIFS

1165: ,nvl(FFVT.description, '') pj_name --name for project from COA
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

Line 1818: ,FND_ID_FLEX_SEGMENTS FIFS

1814: SELECT DISTINCT
1815: FFV.FLEX_VALUE cc_number
1816: ,nvl(FFVT.description, '') cc_name
1817: FROM JA_CN_ACCOUNT_BALANCES BAL
1818: ,FND_ID_FLEX_SEGMENTS FIFS
1819: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
1820: ,FND_FLEX_VALUE_SETS FFVS
1821: ,FND_FLEX_VALUES_TL FFVT
1822: ,FND_FLEX_VALUES FFV