select ATTRIBUTE_CATEGORY,VALUE,ENABL
FLEX_VALUE_ATTRIBUTE3,FLEX_VAL
from fusion.FND_VS_VALUES_B
where VALUE_SET_ID in (SELECT segi.VALUE_SET_ID FROM fusion.fnd_kf_str_instances_b stri, fusion.fnd_kf_segment_instance
WHERE application_id = 101
AND stri.structure_instance_id = segi.structure_instance_id
AND stri.structure_id = segb.structure_id
AND segb.segment_code = segi.segment_code
AND segi.value_set_id = vs.value_set_id
AND STRUCTURE_INSTANCE_NUMBER=1041
In fusion.
fnd_kf_str_instances_b
have STRUCTURE_INSTANCE_CODE and you could use it as parameter.
=============================================================
#FusionVsOracleApps
FND_VS_VALUE_SETS-> FND_FLEX_VALUE_SETS
FND_VS_VALUES_VL -> FND_FLEX_VALUES_VL
Oracle Apps R12 and Fusion Cloud Self Paced Training Videos Published on Udemy with Live Meeting Support. Please Check https://www.oracleappstechnical.com
ReplyDelete