DBA Data[Home] [Help]

APPS.POR_IFT_INFO_PKG dependencies on FND_FLEX_VALUES

Line 29: from FND_FLEX_VALUES VAL,

25: CURSOR c_attributes (p_category_id IN NUMBER) IS
26: SELECT ATT.DESCRIPTION,
27: decode(ATB.FLEX_VALUE_SET_ID, null, INFO.ATTRIBUTE_VALUE,
28: (select VTL.FLEX_VALUE_MEANING
29: from FND_FLEX_VALUES VAL,
30: FND_FLEX_VALUES_TL VTL
31: where INFO.ATTRIBUTE_VALUE = VAL.FLEX_VALUE
32: AND VAL.FLEX_VALUE_SET_ID = ATB.FLEX_VALUE_SET_ID
33: AND VAL.FLEX_VALUE_ID = VTL.FLEX_VALUE_ID

Line 30: FND_FLEX_VALUES_TL VTL

26: SELECT ATT.DESCRIPTION,
27: decode(ATB.FLEX_VALUE_SET_ID, null, INFO.ATTRIBUTE_VALUE,
28: (select VTL.FLEX_VALUE_MEANING
29: from FND_FLEX_VALUES VAL,
30: FND_FLEX_VALUES_TL VTL
31: where INFO.ATTRIBUTE_VALUE = VAL.FLEX_VALUE
32: AND VAL.FLEX_VALUE_SET_ID = ATB.FLEX_VALUE_SET_ID
33: AND VAL.FLEX_VALUE_ID = VTL.FLEX_VALUE_ID
34: AND VTL.LANGUAGE = NVL(p_preparer_language, USERENV('LANG')))) value,