DBA Data[Home] [Help]

APPS.FV_FACTS_TRANSACTIONS dependencies on FND_FLEX_VALUES_TL

Line 4568: FROM fnd_flex_values_tl ffvl,

4564: -- RPAD(ffvl.description,25,' '))
4565: SELECT DECODE(ffvl.description,NULL,RPAD(' ',25,' '),
4566: RPAD(SUBSTR(ffvl.description,1,25),25,' '))
4567: INTO p_seg_txt
4568: FROM fnd_flex_values_tl ffvl,
4569: fnd_flex_values ffv
4570: WHERE ffvl.flex_value_id = ffv.flex_value_id
4571: AND ffv.flex_value_set_id = p_prg_val_set_id
4572: AND ffv.flex_value = p_program