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 4159: qp_prc_contexts_b c, qp_pte_segments d

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

Line 4267: qp_pte_segments c,

4263: select c.segment_level
4264: into l_segment_level
4265: from qp_prc_contexts_b a,
4266: qp_segments_b b,
4267: qp_pte_segments c,
4268: qp_list_headers_b d
4269: where a.prc_context_id = b.prc_context_id
4270: and b.segment_id = c.segment_id
4271: and c.pte_code = d.pte_code

Line 4350: FROM qp_segments_b c, qp_pte_segments d

4346: FROM qp_prc_contexts_b a, qp_prc_contexts_tl b
4347: WHERE a.prc_context_id = b.prc_context_id
4348: AND b.language = userenv('LANG')
4349: AND EXISTS (SELECT 'x'
4350: FROM qp_segments_b c, qp_pte_segments d
4351: WHERE d.pte_code = a_pte_code
4352: AND c.segment_id = d.segment_id
4353: AND c.prc_context_id = a.prc_context_id
4354: AND d.lov_enabled = 'Y'

Line 4626: qp_pte_segments c, qp_prc_contexts_b d

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