[Home] [Help]
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'
36585: AND pcontexts.prc_context_code = lattr.context
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
36605: AND segments.segment_mapping_column = lattr.attribute
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
36619: AND segments.application_id = 661
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',
36810: lattr.attribute_type) -- Changed for bug2806857
37456: ,qnlat.REQUEST_ID
37457: ,'Y'
37458: FROM qp_npreq_line_attrs_tmp qnlat,
37459: qp_prc_contexts_b qpc,
37460: qp_segments_b qs,
37461: HZ_HIERARCHY_NODES hn
37462: WHERE qnlat.pricing_status_code = G_STATUS_UNCHANGED
37463: AND qnlat.attribute_type = G_QUALIFIER_TYPE
37464: AND qpc.PRC_CONTEXT_TYPE = 'QUALIFIER'
37506: qp_npreq_line_attrs_tmp /*+ index(attr qp_preq_line_attrs_tmp_n9) */attr
37507: SET attr.segment_id = (
37508: SELECT qps.segment_id
37509: FROM qp_prc_contexts_b qpc
37510: , qp_segments_b qps
37511: , qp_pte_segments qpps
37512: WHERE attr.context = qpc.prc_context_code
37513: AND qpc.prc_context_id = qps.prc_context_id
37514: AND qps.segment_mapping_column = attr.attribute
37528: qp_npreq_line_attrs_tmp attr
37529: SET attr.segment_id = (
37530: SELECT qps.segment_id
37531: FROM qp_prc_contexts_b qpc
37532: , qp_segments_b qps
37533: , qp_pte_segments qpps
37534: WHERE attr.context = qpc.prc_context_code
37535: AND qpc.prc_context_id = qps.prc_context_id
37536: AND qps.segment_mapping_column = attr.attribute
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
41123: AND segments.application_id = 661
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'
41864: AND pcontexts.prc_context_code = lattr.context