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_ATTR_GRP_PVT dependencies on QP_QUALIFIERS

Line 434: from qp_qualifiers qpq,

430: null modifier_level_code,
431: qpq.qualifier_datatype attribute_datatype,
432: qpq.qualifier_attr_value attribute_value,
433: 'QUAL' attribute_type
434: from qp_qualifiers qpq,
435: qp_list_headers_b qph
436: where qpq.list_line_id = -1
437: and qph.list_header_id = qpq.list_header_id
438: and qpq.list_header_id = nvl(p_list_header_id, qpq.list_header_id)

Line 531: from qp_list_lines qpl, qp_qualifiers qpq, qp_list_headers_b qph

527: qpl.modifier_level_code modifier_level_code,
528: qpq.qualifier_datatype attribute_datatype,
529: qpq.qualifier_attr_value attribute_value,
530: 'QUAL' attribute_type
531: from qp_list_lines qpl, qp_qualifiers qpq, qp_list_headers_b qph
532: where qpq.list_line_id <> -1
533: and qph.list_header_id = qpq.list_header_id
534: and qpl.list_header_id = qph.list_header_id
535: and qpl.list_line_id = qpq.list_line_id

Line 2112: from qp_qualifiers

2108: elsif p_qualifier_group is not null then
2109: begin
2110: select 'Y'
2111: into l_qual_exists
2112: from qp_qualifiers
2113: where list_header_id = p_list_header_id
2114: and list_line_id = -1
2115: and ((list_type_code = 'PRL'
2116: AND QUALIFIER_CONTEXT <> 'MODLIST'

Line 2135: from qp_qualifiers

2131: else
2132: begin
2133: select 'Y'
2134: into l_qual_exists
2135: from qp_qualifiers
2136: where list_header_id = p_list_header_id
2137: and list_line_id = -1
2138: and ((list_type_code = 'PRL'
2139: AND QUALIFIER_CONTEXT <> 'MODLIST'

Line 2291: from qp_qualifiers

2287: elsif p_qualifier_group is not null then
2288: begin
2289: select 'Y'
2290: into l_qual_exists
2291: from qp_qualifiers
2292: where list_header_id = p_list_header_id
2293: and list_line_id = p_list_line_id
2294: and QUALIFIER_GROUPING_NO = p_qualifier_group
2295: and rownum = 1;

Line 2315: from qp_qualifiers

2311: else
2312: begin
2313: select 'Y'
2314: into l_qual_exists
2315: from qp_qualifiers
2316: where list_header_id = p_list_header_id
2317: and list_line_id = p_list_line_id
2318: and QUALIFIER_GROUPING_NO <> -1
2319: and rownum = 1;

Line 2477: from qp_qualifiers

2473: -- when called while set up of price list/modifier
2474: begin
2475: select 'Y'
2476: into l_qual_exists
2477: from qp_qualifiers
2478: where list_header_id = p_list_header_id
2479: and list_line_id = p_list_line_id
2480: and rownum = 1;
2481: exception

Line 2552: from qp_qualifiers

2548: ,p_high_list_line_id IN NUMBER)
2549: is
2550: cursor c_qual_seg_id is
2551: select distinct QUALIFIER_CONTEXT, QUALIFIER_ATTRIBUTE
2552: from qp_qualifiers
2553: where QUALIFIER_CONTEXT is not null
2554: and QUALIFIER_ATTRIBUTE is not null
2555: and list_header_id = nvl(p_list_header_id, list_header_id)
2556: and list_line_id between p_low_list_line_id and p_high_list_line_id

Line 2562: TYPE segment_id_tab IS TABLE OF qp_qualifiers.segment_id%TYPE INDEX BY BINARY_INTEGER;

2558: OR
2559: (p_qualifier_group is null)
2560: );
2561:
2562: TYPE segment_id_tab IS TABLE OF qp_qualifiers.segment_id%TYPE INDEX BY BINARY_INTEGER;
2563: TYPE context_tab IS TABLE OF qp_qualifiers.QUALIFIER_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
2564: TYPE attribute_tab IS TABLE OF qp_qualifiers.QUALIFIER_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
2565:
2566: segment_id_t segment_id_tab;

Line 2563: TYPE context_tab IS TABLE OF qp_qualifiers.QUALIFIER_CONTEXT%TYPE INDEX BY BINARY_INTEGER;

2559: (p_qualifier_group is null)
2560: );
2561:
2562: TYPE segment_id_tab IS TABLE OF qp_qualifiers.segment_id%TYPE INDEX BY BINARY_INTEGER;
2563: TYPE context_tab IS TABLE OF qp_qualifiers.QUALIFIER_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
2564: TYPE attribute_tab IS TABLE OF qp_qualifiers.QUALIFIER_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
2565:
2566: segment_id_t segment_id_tab;
2567: context_t context_tab;

Line 2564: TYPE attribute_tab IS TABLE OF qp_qualifiers.QUALIFIER_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;

2560: );
2561:
2562: TYPE segment_id_tab IS TABLE OF qp_qualifiers.segment_id%TYPE INDEX BY BINARY_INTEGER;
2563: TYPE context_tab IS TABLE OF qp_qualifiers.QUALIFIER_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
2564: TYPE attribute_tab IS TABLE OF qp_qualifiers.QUALIFIER_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
2565:
2566: segment_id_t segment_id_tab;
2567: context_t context_tab;
2568: attribute_t attribute_tab;

Line 2606: update qp_qualifiers

2602: and b.SEGMENT_MAPPING_COLUMN = attribute_t(i);
2603: END LOOP;
2604:
2605: FORALL j in 1..context_t.count
2606: update qp_qualifiers
2607: set segment_id = segment_id_t(j)
2608: where QUALIFIER_CONTEXT = context_t(j)
2609: and QUALIFIER_ATTRIBUTE = attribute_t(j)
2610: and list_header_id = nvl(p_list_header_id, list_header_id)