DBA Data[Home] [Help]

APPS.QP_PREQ_GRP dependencies on QP_SEGMENTS_TL

Line 31037: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS , qp_segments_tl SEGMENTS_TL

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
31041: AND segments.application_id = 661

Line 32378: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS, qp_segments_tl SEGMENTS_TL

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
32382: AND segments.application_id = 661