DBA Data[Home] [Help]

APPS.QP_PREQ_GRP dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 36636: fnd_descr_flex_column_usages DFLEX

36632: WHERE attribute_type IN ('PRICING', 'PRODUCT')
36633: AND pricing_status_code = G_STATUS_UNCHANGED
36634: AND EXISTS (SELECT format_type
36635: FROM fnd_flex_value_sets VSET,
36636: fnd_descr_flex_column_usages DFLEX
36637: WHERE vset.flex_value_set_id = dflex.flex_value_set_id
36638: AND dflex.application_id = 661
36639: AND dflex.descriptive_flexfield_name =
36640: 'QP_ATTR_DEFNS_PRICING'

Line 36893: fnd_descr_flex_column_usages DFLEX

36889: AND pricing_status_code = G_STATUS_UNCHANGED
36890: AND NOT EXISTS (
36891: SELECT format_type
36892: FROM fnd_flex_value_sets VSET,
36893: fnd_descr_flex_column_usages DFLEX
36894: WHERE vset.flex_value_set_id = dflex.flex_value_set_id
36895: AND dflex.application_id = 661
36896: AND dflex.descriptive_flexfield_name =
36897: 'QP_ATTR_DEFNS_PRICING'

Line 41139: FROM fnd_flex_value_sets VSET,fnd_descr_flex_column_usages DFLEX

41135: WHERE attribute_type = G_PRICING_TYPE
41136: AND pricing_status_code = G_STATUS_UNCHANGED
41137: AND exists (
41138: SELECT format_type
41139: FROM fnd_flex_value_sets VSET,fnd_descr_flex_column_usages DFLEX
41140: WHERE vset.flex_value_set_id = dflex.flex_value_set_id
41141: AND dflex.application_id = 661
41142: AND dflex.descriptive_flexfield_name = 'QP_ATTR_DEFNS_PRICING'
41143: AND dflex.descriptive_flex_context_code = lattr.context

Line 41903: FROM fnd_flex_value_sets VSET,fnd_descr_flex_column_usages DFLEX

41899: WHERE attribute_type = G_PRICING_TYPE
41900: AND pricing_status_code = G_STATUS_UNCHANGED
41901: AND exists (
41902: SELECT format_type
41903: FROM fnd_flex_value_sets VSET,fnd_descr_flex_column_usages DFLEX
41904: WHERE vset.flex_value_set_id = dflex.flex_value_set_id
41905: AND dflex.application_id = 661
41906: AND dflex.descriptive_flexfield_name = 'QP_ATTR_DEFNS_PRICING'
41907: AND dflex.descriptive_flex_context_code = lattr.context