APPS.QP_PREQ_GRP dependencies on FND_FLEX_VALUE_SETS

Line 31002: FROM fnd_flex_value_sets VSET,

30998: FROM qp_npreq_line_attrs_tmp lattr
30999: WHERE attribute_type IN ('PRICING', 'PRODUCT')
31000: AND pricing_status_code = G_STATUS_UNCHANGED
31001: AND EXISTS (SELECT format_type
31002: FROM fnd_flex_value_sets VSET,
31003: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS
31004: WHERE vset.flex_value_set_id = segments.user_valueset_id
31005: AND segments.application_id = 661
31006: AND pcontexts.prc_context_type <> 'QUALIFIER'

Line 31022: FROM fnd_flex_value_sets VSET,

31018: FROM qp_npreq_line_attrs_tmp lattr
31019: WHERE attribute_type IN ('PRICING', 'PRODUCT', 'QUALIFIER')
31020: AND pricing_status_code = G_STATUS_UNCHANGED
31021: AND EXISTS (SELECT format_type
31022: FROM fnd_flex_value_sets VSET,
31023: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS
31024: WHERE vset.flex_value_set_id = segments.user_valueset_id
31025: AND segments.application_id = 661
31026: AND pcontexts.prc_context_code = lattr.context

Line 31036: FROM qp_npreq_line_attrs_tmp lattr, fnd_flex_value_sets VSET,

31032: CURSOR am_attr_qual_msg_cur
31033: IS
31034: SELECT lattr.value_from,lattr.context,
31035: nvl(SEGMENTS_TL.SEEDED_SEGMENT_NAME,SEGMENTS_TL.USER_SEGMENT_NAME) attribute
31036: FROM qp_npreq_line_attrs_tmp lattr, fnd_flex_value_sets VSET,
31037: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS , qp_segments_tl SEGMENTS_TL
31038: WHERE attribute_type IN ('PRICING', 'PRODUCT', 'QUALIFIER')
31039: AND pricing_status_code = G_STATUS_UNCHANGED
31040: AND vset.flex_value_set_id = segments.user_valueset_id

Line 31057: FROM fnd_flex_value_sets VSET,

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

Line 31227: FROM fnd_flex_value_sets VSET,

31223: OR attribute_type IN ('PRICING', 'PRODUCT')) -- Changed for bug2806857
31224: AND pricing_status_code = G_STATUS_UNCHANGED
31225: AND NOT EXISTS (
31226: SELECT format_type
31227: FROM fnd_flex_value_sets VSET,
31228: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS
31229: WHERE vset.flex_value_set_id = segments.user_valueset_id
31230: AND segments.application_id = 661
31231: AND pcontexts.prc_context_type = decode(lattr.attribute_type,'PRICING','PRICING_ATTRIBUTE',

Line 31314: FROM fnd_flex_value_sets VSET,

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

Line 32377: FROM qp_npreq_line_attrs_tmp lattr,fnd_flex_value_sets VSET,

32373: CURSOR am_attr_msg_cur
32374: IS
32375: SELECT lattr.value_from,lattr.value_to,lattr.context,
32376: nvl(SEGMENTS_TL.SEEDED_SEGMENT_NAME,SEGMENTS_TL.USER_SEGMENT_NAME) attribute
32377: FROM qp_npreq_line_attrs_tmp lattr,fnd_flex_value_sets VSET,
32378: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS, qp_segments_tl SEGMENTS_TL
32379: WHERE attribute_type = G_PRICING_TYPE
32380: AND pricing_status_code = G_STATUS_UNCHANGED
32381: AND vset.flex_value_set_id = segments.user_valueset_id

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

32995: INDX,QP_PREQ_GRP.price_request.price_request_sel1,FND_DESCR_FLEX_COL_USAGES_U1,DESCRIPTIVE_FLEXFIELD_NAME,2
32996: INDX,QP_PREQ_GRP.price_request.price_request_sel1,FND_DESCR_FLEX_COL_USAGES_U1,DESCRIPTIVE_FLEX_CONTEXT_CODE,3
32997: INDX,QP_PREQ_GRP.price_request.price_request_sel1,FND_DESCR_FLEX_COL_USAGES_U1,APPLICATION_COLUMN_NAME,4
32998:
32999: INDX,QP_PREQ_GRP.price_request.price_request_sel1,FND_FLEX_VALUE_SETS_U1,FLEX_VALUE_SET_ID,1
33000: */
33001: --G_AM_INSTALLED_PROFILE := nvl(FND_PROFILE.value('QP_ATTRIBUTE_MANAGER_INSTALLED'), G_YES); /* default is G_YES by yangli 03/12/2002*/
33002: G_AM_INSTALLED_PROFILE := QP_UTIL.Attrmgr_Installed;
33003: /* by yangli 05/02/02*/

Line 33014: FROM fnd_flex_value_sets VSET,

33010: WHERE attribute_type = G_PRICING_TYPE
33011: AND pricing_status_code = G_STATUS_UNCHANGED
33012: AND exists (
33013: SELECT format_type
33014: FROM fnd_flex_value_sets VSET,
33015: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS
33016: WHERE vset.flex_value_set_id = segments.user_valueset_id
33017: AND segments.application_id = 661
33018: AND pcontexts.prc_context_type <> 'QUALIFIER'

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