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 440: from qp_qualifiers qpq,

436: null modifier_level_code,
437: qpq.qualifier_datatype attribute_datatype,
438: qpq.qualifier_attr_value attribute_value,
439: 'QUAL' attribute_type
440: from qp_qualifiers qpq,
441: qp_list_headers_b qph
442: where qpq.list_line_id = -1
443: and qph.list_header_id = qpq.list_header_id
444: and qpq.list_header_id = nvl(p_list_header_id, qpq.list_header_id)

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

533: qpl.modifier_level_code modifier_level_code,
534: qpq.qualifier_datatype attribute_datatype,
535: qpq.qualifier_attr_value attribute_value,
536: 'QUAL' attribute_type
537: from qp_list_lines qpl, qp_qualifiers qpq, qp_list_headers_b qph
538: where qpq.list_line_id <> -1
539: and qph.list_header_id = qpq.list_header_id
540: and qpl.list_header_id = qph.list_header_id
541: and qpl.list_line_id = qpq.list_line_id

Line 2118: from qp_qualifiers

2114: elsif p_qualifier_group is not null then
2115: begin
2116: select 'Y'
2117: into l_qual_exists
2118: from qp_qualifiers
2119: where list_header_id = p_list_header_id
2120: and list_line_id = -1
2121: and ((list_type_code = 'PRL'
2122: AND QUALIFIER_CONTEXT <> 'MODLIST'

Line 2141: from qp_qualifiers

2137: else
2138: begin
2139: select 'Y'
2140: into l_qual_exists
2141: from qp_qualifiers
2142: where list_header_id = p_list_header_id
2143: and list_line_id = -1
2144: and ((list_type_code = 'PRL'
2145: AND QUALIFIER_CONTEXT <> 'MODLIST'

Line 2297: from qp_qualifiers

2293: elsif p_qualifier_group is not null then
2294: begin
2295: select 'Y'
2296: into l_qual_exists
2297: from qp_qualifiers
2298: where list_header_id = p_list_header_id
2299: and list_line_id = p_list_line_id
2300: and QUALIFIER_GROUPING_NO = p_qualifier_group
2301: and rownum = 1;

Line 2321: from qp_qualifiers

2317: else
2318: begin
2319: select 'Y'
2320: into l_qual_exists
2321: from qp_qualifiers
2322: where list_header_id = p_list_header_id
2323: and list_line_id = p_list_line_id
2324: and QUALIFIER_GROUPING_NO <> -1
2325: and rownum = 1;

Line 2483: from qp_qualifiers

2479: -- when called while set up of price list/modifier
2480: begin
2481: select 'Y'
2482: into l_qual_exists
2483: from qp_qualifiers
2484: where list_header_id = p_list_header_id
2485: and list_line_id = p_list_line_id
2486: and rownum = 1;
2487: exception

Line 2558: from qp_qualifiers

2554: ,p_high_list_line_id IN NUMBER)
2555: is
2556: cursor c_qual_seg_id is
2557: select distinct QUALIFIER_CONTEXT, QUALIFIER_ATTRIBUTE
2558: from qp_qualifiers
2559: where QUALIFIER_CONTEXT is not null
2560: and QUALIFIER_ATTRIBUTE is not null
2561: and list_header_id = nvl(p_list_header_id, list_header_id)
2562: and list_line_id between p_low_list_line_id and p_high_list_line_id

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

2564: OR
2565: (p_qualifier_group is null)
2566: );
2567:
2568: TYPE segment_id_tab IS TABLE OF qp_qualifiers.segment_id%TYPE INDEX BY BINARY_INTEGER;
2569: TYPE context_tab IS TABLE OF qp_qualifiers.QUALIFIER_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
2570: TYPE attribute_tab IS TABLE OF qp_qualifiers.QUALIFIER_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
2571:
2572: segment_id_t segment_id_tab;

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

2565: (p_qualifier_group is null)
2566: );
2567:
2568: TYPE segment_id_tab IS TABLE OF qp_qualifiers.segment_id%TYPE INDEX BY BINARY_INTEGER;
2569: TYPE context_tab IS TABLE OF qp_qualifiers.QUALIFIER_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
2570: TYPE attribute_tab IS TABLE OF qp_qualifiers.QUALIFIER_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
2571:
2572: segment_id_t segment_id_tab;
2573: context_t context_tab;

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

2566: );
2567:
2568: TYPE segment_id_tab IS TABLE OF qp_qualifiers.segment_id%TYPE INDEX BY BINARY_INTEGER;
2569: TYPE context_tab IS TABLE OF qp_qualifiers.QUALIFIER_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
2570: TYPE attribute_tab IS TABLE OF qp_qualifiers.QUALIFIER_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
2571:
2572: segment_id_t segment_id_tab;
2573: context_t context_tab;
2574: attribute_t attribute_tab;

Line 2612: update qp_qualifiers

2608: and b.SEGMENT_MAPPING_COLUMN = attribute_t(i);
2609: END LOOP;
2610:
2611: FORALL j in 1..context_t.count
2612: update qp_qualifiers
2613: set segment_id = segment_id_t(j)
2614: where QUALIFIER_CONTEXT = context_t(j)
2615: and QUALIFIER_ATTRIBUTE = attribute_t(j)
2616: and list_header_id = nvl(p_list_header_id, list_header_id)