eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_UTIL dependencies on QP_SEGMENTS_B

Line 471: qp_segments_b c

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
475: AND c.segment_mapping_column = a_attribute

Line 666: FROM qp_prc_contexts_b a, qp_segments_b b

662: ) IS
663: CURSOR context_attr_cur(a_attribute_code VARCHAR2)
664: IS
665: SELECT a.prc_context_code, b.segment_mapping_column
666: FROM qp_prc_contexts_b a, qp_segments_b b
667: WHERE a.prc_context_id = b.prc_context_id
668: AND b.segment_code = UPPER(a_attribute_code);
669:
670: BEGIN

Line 1040: FROM qp_prc_contexts_b a, qp_segments_b b

1036: IS
1037: CURSOR context_cur(a_attribute_code VARCHAR2)
1038: IS
1039: SELECT a.prc_context_id
1040: FROM qp_prc_contexts_b a, qp_segments_b b
1041: WHERE a.prc_context_id = b.prc_context_id
1042: AND b.segment_code = a_attribute_code
1043: AND a.prc_context_type = 'QUALIFIER';
1044:

Line 1103: FROM qp_prc_contexts_b a, qp_segments_b b

1099: IS
1100: CURSOR context_cur(a_attribute_code VARCHAR2)
1101: IS
1102: SELECT a.prc_context_id
1103: FROM qp_prc_contexts_b a, qp_segments_b b
1104: WHERE a.prc_context_id = b.prc_context_id
1105: AND b.segment_code = a_attribute_code
1106: AND a.prc_context_type = 'PRICING';
1107:

Line 1390: -- existence of the segment in flexfield tables, checks in the QP_SEGMENTS_B

1386: --
1387: -- DESCRIPTION
1388: -- New function introduced in Attributes Manager that is equivalent to
1389: -- existing Segment_Exists function but instead of checking for the
1390: -- existence of the segment in flexfield tables, checks in the QP_SEGMENTS_B
1391: -- table.
1392: --
1393: --*****************************************************************************
1394:

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 2278: FROM qp_segments_b a, qp_prc_contexts_b b

2274: CURSOR valueset_id_cur(a_context_type VARCHAR2, a_context_code VARCHAR2,
2275: a_segment_code VARCHAR2)
2276: IS
2277: SELECT nvl(a.user_valueset_id, a.seeded_valueset_id)
2278: FROM qp_segments_b a, qp_prc_contexts_b b
2279: WHERE a.prc_context_id = b.prc_context_id
2280: AND b.prc_context_type = a_context_type
2281: AND b.prc_context_code = a_context_code
2282: AND a.segment_code = a_segment_code;

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 4243: qp_segments_b b,

4239:
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

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 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