DBA Data[Home] [Help]

APPS.PO_UDA_TEMPLATES_UTIL dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 4213: SELECT f.FLEX_VALUE_SET_ID, fv.VALIDATION_TYPE FROM FND_DESCR_FLEX_COL_USAGE_VL f, PO_UDA_AG_TEMPLATE_USAGES t , fnd_flex_value_sets fv

4209: l_query LONG;
4210: l_validation_type VARCHAR2(2);
4211:
4212: CURSOR c_get_value_set_id(p_usage_id NUMBER, p_attr_col VARCHAR2) IS
4213: SELECT f.FLEX_VALUE_SET_ID, fv.VALIDATION_TYPE FROM FND_DESCR_FLEX_COL_USAGE_VL f, PO_UDA_AG_TEMPLATE_USAGES t , fnd_flex_value_sets fv
4214: WHERE DESCRIPTIVE_FLEXFIELD_NAME LIKE 'PO_UDA_TEMPLATE_USAGES'
4215: AND f.DESCRIPTIVE_FLEX_CONTEXT_CODE = T.ATTRIBUTE_CATEGORY
4216: AND t. usage_id = p_usage_id AND f.APPLICATION_COLUMN_NAME = p_attr_col
4217: AND f.FLEX_VALUE_SET_ID = fv.FLEX_VALUE_SET_ID;

Line 4343: SELECT f.FLEX_VALUE_SET_ID, fv.VALIDATION_TYPE FROM FND_DESCR_FLEX_COL_USAGE_VL f, PO_UDA_AG_TEMPLATE_USAGES t , fnd_flex_value_sets fv

4339: l_validation_type VARCHAR2(2);
4340: l_attr_meaning VARCHAR2(100);
4341:
4342: CURSOR c_get_value_set_id(p_usage_id NUMBER, p_attr_col VARCHAR2) IS
4343: SELECT f.FLEX_VALUE_SET_ID, fv.VALIDATION_TYPE FROM FND_DESCR_FLEX_COL_USAGE_VL f, PO_UDA_AG_TEMPLATE_USAGES t , fnd_flex_value_sets fv
4344: WHERE DESCRIPTIVE_FLEXFIELD_NAME LIKE 'PO_UDA_TEMPLATE_USAGES'
4345: AND f.DESCRIPTIVE_FLEX_CONTEXT_CODE = T.ATTRIBUTE_CATEGORY
4346: AND t. usage_id = p_usage_id AND f.APPLICATION_COLUMN_NAME = p_attr_col
4347: AND f.FLEX_VALUE_SET_ID = fv.FLEX_VALUE_SET_ID;