DBA Data[Home] [Help]

APPS.FV_FACTS_TRANSACTIONS dependencies on FND_FLEX_VALUES_TL

Line 4496: FROM fnd_flex_values_tl ffvl,

4492: -- RPAD(ffvl.description,25,' '))
4493: SELECT DECODE(ffvl.description,NULL,RPAD(' ',25,' '),
4494: RPAD(SUBSTR(ffvl.description,1,25),25,' '))
4495: INTO p_seg_txt
4496: FROM fnd_flex_values_tl ffvl,
4497: fnd_flex_values ffv
4498: WHERE ffvl.flex_value_id = ffv.flex_value_id
4499: AND ffv.flex_value_set_id = p_prg_val_set_id
4500: AND ffv.flex_value = p_program