DBA Data[Home] [Help]

APPS.QP_PREQ_GRP dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 31058: fnd_descr_flex_column_usages DFLEX

31054: WHERE attribute_type IN ('PRICING', 'PRODUCT')
31055: AND pricing_status_code = G_STATUS_UNCHANGED
31056: AND EXISTS (SELECT format_type
31057: FROM fnd_flex_value_sets VSET,
31058: fnd_descr_flex_column_usages DFLEX
31059: WHERE vset.flex_value_set_id = dflex.flex_value_set_id
31060: AND dflex.application_id = 661
31061: AND dflex.descriptive_flexfield_name =
31062: 'QP_ATTR_DEFNS_PRICING'

Line 31315: fnd_descr_flex_column_usages DFLEX

31311: AND pricing_status_code = G_STATUS_UNCHANGED
31312: AND NOT EXISTS (
31313: SELECT format_type
31314: FROM fnd_flex_value_sets VSET,
31315: fnd_descr_flex_column_usages DFLEX
31316: WHERE vset.flex_value_set_id = dflex.flex_value_set_id
31317: AND dflex.application_id = 661
31318: AND dflex.descriptive_flexfield_name =
31319: 'QP_ATTR_DEFNS_PRICING'

Line 32398: FROM fnd_flex_value_sets VSET,fnd_descr_flex_column_usages DFLEX

32394: WHERE attribute_type = G_PRICING_TYPE
32395: AND pricing_status_code = G_STATUS_UNCHANGED
32396: AND exists (
32397: SELECT format_type
32398: FROM fnd_flex_value_sets VSET,fnd_descr_flex_column_usages DFLEX
32399: WHERE vset.flex_value_set_id = dflex.flex_value_set_id
32400: AND dflex.application_id = 661
32401: AND dflex.descriptive_flexfield_name = 'QP_ATTR_DEFNS_PRICING'
32402: AND dflex.descriptive_flex_context_code = lattr.context

Line 33058: FROM fnd_flex_value_sets VSET,fnd_descr_flex_column_usages DFLEX

33054: WHERE attribute_type = G_PRICING_TYPE
33055: AND pricing_status_code = G_STATUS_UNCHANGED
33056: AND exists (
33057: SELECT format_type
33058: FROM fnd_flex_value_sets VSET,fnd_descr_flex_column_usages DFLEX
33059: WHERE vset.flex_value_set_id = dflex.flex_value_set_id
33060: AND dflex.application_id = 661
33061: AND dflex.descriptive_flexfield_name = 'QP_ATTR_DEFNS_PRICING'
33062: AND dflex.descriptive_flex_context_code = lattr.context