DBA Data[Home] [Help]

APPS.QP_PREQ_GRP dependencies on QP_SEGMENTS_TL

Line 36615: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS , qp_segments_tl SEGMENTS_TL

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

Line 41119: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS, qp_segments_tl SEGMENTS_TL

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