DBA Data[Home] [Help]

APPS.FND_FLEX_LOADER_APIS dependencies on FND_VALUE_ATTRIBUTE_TYPES

Line 91: SUBTYPE kff_sgq_type IS fnd_value_attribute_types%ROWTYPE;

87: SUBTYPE dff_seg_tl_type IS fnd_descr_flex_col_usage_tl%ROWTYPE;
88:
89: SUBTYPE kff_flx_type IS fnd_id_flexs%ROWTYPE;
90: SUBTYPE kff_flq_type IS fnd_segment_attribute_types%ROWTYPE;
91: SUBTYPE kff_sgq_type IS fnd_value_attribute_types%ROWTYPE;
92: SUBTYPE kff_sgq_tl_type IS fnd_val_attribute_types_tl%ROWTYPE;
93: SUBTYPE kff_str_type IS fnd_id_flex_structures%ROWTYPE;
94: SUBTYPE kff_str_tl_type IS fnd_id_flex_structures_tl%ROWTYPE;
95: SUBTYPE kff_wfp_type IS fnd_flex_workflow_processes%ROWTYPE;

Line 1894: fnd_value_attribute_types vat

1890: vat.lookup_type,
1891: vat.default_value,
1892: NULL
1893: FROM fnd_flex_validation_qualifiers fvq,
1894: fnd_value_attribute_types vat
1895: WHERE fvq.flex_value_set_id = p_flex_value_set_id
1896: AND fvq.id_flex_application_id = vat.application_id(+)
1897: AND fvq.id_flex_code = vat.id_flex_code(+)
1898: AND fvq.segment_attribute_type = vat.segment_attribute_type(+)

Line 2337: FROM fnd_value_attribute_types

2333: BEGIN
2334: l_func_name := g_api_name || 'get_kff_sgq(F)';
2335: SELECT *
2336: INTO x_kff_sgq
2337: FROM fnd_value_attribute_types
2338: WHERE application_id = p_kff_flq.application_id
2339: AND id_flex_code = p_kff_flq.id_flex_code
2340: AND segment_attribute_type = p_kff_flq.segment_attribute_type
2341: AND value_attribute_type = p_value_attribute_type;