APPS.QP_UTIL dependencies on QP_PTE_SEGMENTS

Line 470: FROM qp_pte_segments a, qp_prc_contexts_b b,

466: a_attribute VARCHAR2, a_pte_code VARCHAR2)
467: IS
468: SELECT a.sourcing_enabled, a.sourcing_status,
469: nvl(a.user_sourcing_method, a.seeded_sourcing_method)
470: FROM qp_pte_segments a, qp_prc_contexts_b b,
471: qp_segments_b c
472: WHERE b.prc_context_code = a_context
473: AND b.prc_context_type = a_context_type
474: AND c.prc_context_id = b.prc_context_id

Line 1417: FROM qp_segments_b a, qp_pte_segments b

1413: a_pte_code VARCHAR2)
1414: IS
1415: SELECT nvl(user_valueset_id, seeded_valueset_id),
1416: nvl(user_precedence, seeded_precedence)
1417: FROM qp_segments_b a, qp_pte_segments b
1418: WHERE a.prc_context_id = a_context_id
1419: AND a.segment_mapping_column = a_segment_mapping_column
1420: AND b.pte_code = a_pte_code
1421: AND a.segment_id = b.segment_id

Line 1430: FROM qp_segments_b a, qp_pte_segments b

1426: a_pte_code VARCHAR2)
1427: IS
1428: SELECT nvl(user_valueset_id, seeded_valueset_id),
1429: nvl(user_precedence, seeded_precedence)
1430: FROM qp_segments_b a, qp_pte_segments b
1431: WHERE a.prc_context_id = a_context_id
1432: AND a.segment_mapping_column = a_segment_mapping_column
1433: AND b.pte_code = a_pte_code
1434: AND a.segment_id = b.segment_id;

Line 4136: qp_prc_contexts_b c, qp_pte_segments d

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
4140: AND b.segment_mapping_column = a_attribute

Line 4244: qp_pte_segments c,

4240: select c.segment_level
4241: into l_segment_level
4242: from qp_prc_contexts_b a,
4243: qp_segments_b b,
4244: qp_pte_segments c,
4245: qp_list_headers_b d
4246: where a.prc_context_id = b.prc_context_id
4247: and b.segment_id = c.segment_id
4248: and c.pte_code = d.pte_code

Line 4327: FROM qp_segments_b c, qp_pte_segments d

4323: FROM qp_prc_contexts_b a, qp_prc_contexts_tl b
4324: WHERE a.prc_context_id = b.prc_context_id
4325: AND b.language = userenv('LANG')
4326: AND EXISTS (SELECT 'x'
4327: FROM qp_segments_b c, qp_pte_segments d
4328: WHERE d.pte_code = a_pte_code
4329: AND c.segment_id = d.segment_id
4330: AND c.prc_context_id = a.prc_context_id
4331: AND d.lov_enabled = 'Y'

Line 4603: qp_pte_segments c, qp_prc_contexts_b d

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
4607: AND a.segment_id = b.segment_id