APPS.QP_PREQ_GRP dependencies on FND_FLEX_VALUE_SETS

Line 36580: FROM fnd_flex_value_sets VSET,

36576: FROM qp_npreq_line_attrs_tmp lattr
36577: WHERE attribute_type IN ('PRICING', 'PRODUCT')
36578: AND pricing_status_code = G_STATUS_UNCHANGED
36579: AND EXISTS (SELECT format_type
36580: FROM fnd_flex_value_sets VSET,
36581: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS
36582: WHERE vset.flex_value_set_id = segments.user_valueset_id
36583: AND segments.application_id = 661
36584: AND pcontexts.prc_context_type <> 'QUALIFIER'

Line 36600: FROM fnd_flex_value_sets VSET,

36596: FROM qp_npreq_line_attrs_tmp lattr
36597: WHERE attribute_type IN ('PRICING', 'PRODUCT', 'QUALIFIER')
36598: AND pricing_status_code = G_STATUS_UNCHANGED
36599: AND EXISTS (SELECT format_type
36600: FROM fnd_flex_value_sets VSET,
36601: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS
36602: WHERE vset.flex_value_set_id = segments.user_valueset_id
36603: AND segments.application_id = 661
36604: AND pcontexts.prc_context_code = lattr.context

Line 36614: FROM qp_npreq_line_attrs_tmp lattr, fnd_flex_value_sets VSET,

36610: CURSOR am_attr_qual_msg_cur
36611: IS
36612: SELECT lattr.value_from,lattr.context,
36613: nvl(SEGMENTS_TL.SEEDED_SEGMENT_NAME,SEGMENTS_TL.USER_SEGMENT_NAME) attribute
36614: FROM qp_npreq_line_attrs_tmp lattr, fnd_flex_value_sets VSET,
36615: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS , qp_segments_tl SEGMENTS_TL
36616: WHERE attribute_type IN ('PRICING', 'PRODUCT', 'QUALIFIER')
36617: AND pricing_status_code = G_STATUS_UNCHANGED
36618: AND vset.flex_value_set_id = segments.user_valueset_id

Line 36635: FROM fnd_flex_value_sets VSET,

36631: FROM qp_npreq_line_attrs_tmp lattr
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 =

Line 36805: FROM fnd_flex_value_sets VSET,

36801: OR attribute_type IN ('PRICING', 'PRODUCT')) -- Changed for bug2806857
36802: AND pricing_status_code = G_STATUS_UNCHANGED
36803: AND NOT EXISTS (
36804: SELECT format_type
36805: FROM fnd_flex_value_sets VSET,
36806: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS
36807: WHERE vset.flex_value_set_id = segments.user_valueset_id
36808: AND segments.application_id = 661
36809: AND pcontexts.prc_context_type = decode(lattr.attribute_type,'PRICING','PRICING_ATTRIBUTE',

Line 36892: FROM fnd_flex_value_sets VSET,

36888: WHERE attribute_type IN ('PRICING', 'PRODUCT')
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 =

Line 41118: FROM qp_npreq_line_attrs_tmp lattr,fnd_flex_value_sets VSET,

41114: CURSOR am_attr_msg_cur
41115: IS
41116: SELECT lattr.value_from,lattr.value_to,lattr.context,
41117: nvl(SEGMENTS_TL.SEEDED_SEGMENT_NAME,SEGMENTS_TL.USER_SEGMENT_NAME) attribute
41118: FROM qp_npreq_line_attrs_tmp lattr,fnd_flex_value_sets VSET,
41119: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS, qp_segments_tl SEGMENTS_TL
41120: WHERE attribute_type = G_PRICING_TYPE
41121: AND pricing_status_code = G_STATUS_UNCHANGED
41122: AND vset.flex_value_set_id = segments.user_valueset_id

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 41844: INDX,QP_PREQ_GRP.price_request.price_request_sel1,FND_FLEX_VALUE_SETS_U1,FLEX_VALUE_SET_ID,1

41840: INDX,QP_PREQ_GRP.price_request.price_request_sel1,FND_DESCR_FLEX_COL_USAGES_U1,DESCRIPTIVE_FLEXFIELD_NAME,2
41841: INDX,QP_PREQ_GRP.price_request.price_request_sel1,FND_DESCR_FLEX_COL_USAGES_U1,DESCRIPTIVE_FLEX_CONTEXT_CODE,3
41842: INDX,QP_PREQ_GRP.price_request.price_request_sel1,FND_DESCR_FLEX_COL_USAGES_U1,APPLICATION_COLUMN_NAME,4
41843:
41844: INDX,QP_PREQ_GRP.price_request.price_request_sel1,FND_FLEX_VALUE_SETS_U1,FLEX_VALUE_SET_ID,1
41845: */
41846: --G_AM_INSTALLED_PROFILE := nvl(FND_PROFILE.value('QP_ATTRIBUTE_MANAGER_INSTALLED'), G_YES); /* default is G_YES by yangli 03/12/2002*/
41847: G_AM_INSTALLED_PROFILE := QP_UTIL.Attrmgr_Installed;
41848: /* by yangli 05/02/02*/

Line 41859: FROM fnd_flex_value_sets VSET,

41855: WHERE attribute_type = G_PRICING_TYPE
41856: AND pricing_status_code = G_STATUS_UNCHANGED
41857: AND exists (
41858: SELECT format_type
41859: FROM fnd_flex_value_sets VSET,
41860: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS
41861: WHERE vset.flex_value_set_id = segments.user_valueset_id
41862: AND segments.application_id = 661
41863: AND pcontexts.prc_context_type <> 'QUALIFIER'

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