DBA Data[Home] [Help]

APPS.QP_UTIL dependencies on QP_SEGMENTS_TL

Line 4158: FROM qp_segments_tl a, qp_segments_b b,

4154: a_pte_code VARCHAR2, a_attribute VARCHAR2)
4155: IS
4156: SELECT nvl(a.user_segment_name, a.seeded_segment_name),
4157: b.segment_code
4158: FROM qp_segments_tl a, qp_segments_b b,
4159: qp_prc_contexts_b c, qp_pte_segments d
4160: WHERE c.prc_context_type = a_context_type
4161: AND c.prc_context_code = a_context_code
4162: AND c.prc_context_id = b.prc_context_id

Line 4625: FROM qp_segments_b a, qp_segments_tl b,

4621: a.segment_code, nvl(a.user_precedence, a.seeded_precedence) precedence,
4622: d.prc_context_code, d.prc_context_type, c.lov_enabled,
4623: a.availability_in_basic, c.limits_enabled, c.segment_level,
4624: nvl(a.user_valueset_id, a.seeded_valueset_id) valueset_id
4625: FROM qp_segments_b a, qp_segments_tl b,
4626: qp_pte_segments c, qp_prc_contexts_b d
4627: WHERE d.prc_context_type = a_context_type
4628: AND d.prc_context_code = a_context_code
4629: AND a.prc_context_id = d.prc_context_id