DBA Data[Home] [Help]

APPS.QP_UTIL dependencies on QP_SEGMENTS_TL

Line 4135: FROM qp_segments_tl a, qp_segments_b b,

4131: a_pte_code VARCHAR2, a_attribute VARCHAR2)
4132: IS
4133: SELECT nvl(a.user_segment_name, a.seeded_segment_name),
4134: b.segment_code
4135: FROM qp_segments_tl a, qp_segments_b b,
4136: qp_prc_contexts_b c, qp_pte_segments d
4137: WHERE c.prc_context_type = a_context_type
4138: AND c.prc_context_code = a_context_code
4139: AND c.prc_context_id = b.prc_context_id

Line 4602: FROM qp_segments_b a, qp_segments_tl b,

4598: a.segment_code, nvl(a.user_precedence, a.seeded_precedence) precedence,
4599: d.prc_context_code, d.prc_context_type, c.lov_enabled,
4600: a.availability_in_basic, c.limits_enabled, c.segment_level,
4601: nvl(a.user_valueset_id, a.seeded_valueset_id) valueset_id
4602: FROM qp_segments_b a, qp_segments_tl b,
4603: qp_pte_segments c, qp_prc_contexts_b d
4604: WHERE d.prc_context_type = a_context_type
4605: AND d.prc_context_code = a_context_code
4606: AND a.prc_context_id = d.prc_context_id