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

Line 785: from qp_qualifiers

781: comparison_operator_code <> '='
782: and pricing_segment_id is not NULL
783: UNION all
784: select segment_id
785: from qp_qualifiers
786: where /*list_line_id in (
787: select list_line_id from qp_attribute_groups where eq_flag = 'N'
788: UNION
789: select list_line_id from qp_list_lines where eq_flag = 'N')

Line 811: from qp_qualifiers

807: --AND comparison_operator_code <> '='
808: and pricing_segment_id is not NULL
809: UNION all
810: select segment_id
811: from qp_qualifiers
812: where /*list_line_id in (
813: select list_line_id from qp_attribute_groups where eq_flag = 'N'
814: UNION
815: select list_line_id from qp_list_lines where eq_flag = 'N')

Line 1123: from qp_qualifiers qpq,

1119: null modifier_level_code,
1120: qpq.qualifier_datatype attribute_datatype,
1121: qpq.qualifier_attr_value attribute_value,
1122: 'QUAL' attribute_type
1123: from qp_qualifiers qpq,
1124: qp_list_headers_all_b qph
1125: where qpq.list_line_id = -1
1126: and qph.list_header_id = qpq.list_header_id
1127: and qpq.list_header_id = nvl(p_list_header_id, qpq.list_header_id)

Line 1186: FROM qp_qualifiers qpq

1182: from qp_list_headers_all_b qph
1183: where
1184: qph.list_header_id = nvl(p_list_header_id, qph.list_header_id)
1185: AND NOT EXISTS ( SELECT 1
1186: FROM qp_qualifiers qpq
1187: WHERE qpq.list_header_id = qph.list_header_id
1188: AND qpq.list_line_id = -1
1189: AND (( qph.list_type_code IN ('PRL','AGR') AND qpq.qualifier_context <> 'MODLIST'
1190: and qpq.qualifier_attribute <> 'QUALIFIER_ATTRIBUTE4'

Line 1322: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_qualifiers qpq

1318: qpl.modifier_level_code modifier_level_code,
1319: qpq.qualifier_datatype attribute_datatype,
1320: qpq.qualifier_attr_value attribute_value,
1321: 'QUAL' attribute_type
1322: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_qualifiers qpq
1323: where qph.list_header_id = p_list_header_id
1324: AND qpl.list_header_id = qph.list_header_id
1325: and qph.list_header_id = qpq.list_header_id
1326: and qpl.list_line_id = qpq.list_line_id

Line 1498: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_qualifiers qpq

1494: qpl.modifier_level_code modifier_level_code,
1495: qpq.qualifier_datatype attribute_datatype,
1496: qpq.qualifier_attr_value attribute_value,
1497: 'QUAL' attribute_type
1498: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_qualifiers qpq
1499: where qpl.list_header_id = qph.list_header_id
1500: and qph.list_header_id = qpq.list_header_id
1501: and qpl.list_line_id = qpq.list_line_id
1502: AND qpq.list_line_id <> -1

Line 4374: from qp_qualifiers

4370: elsif p_qualifier_group is not null then
4371: begin
4372: select 'Y'
4373: into l_qual_exists
4374: from qp_qualifiers
4375: where list_header_id = p_list_header_id
4376: and list_line_id = -1
4377: and ((list_type_code = 'PRL'
4378: AND QUALIFIER_CONTEXT <> 'MODLIST'

Line 4397: from qp_qualifiers

4393: else
4394: begin
4395: select 'Y'
4396: into l_qual_exists
4397: from qp_qualifiers
4398: where list_header_id = p_list_header_id
4399: and list_line_id = -1
4400: and ((list_type_code = 'PRL'
4401: AND QUALIFIER_CONTEXT <> 'MODLIST'

Line 4506: from qp_qualifiers

4502:
4503: begin
4504: select 'Y'
4505: into l_qual_exists
4506: from qp_qualifiers
4507: where list_header_id = p_list_header_id
4508: and list_line_id = -1
4509: and ((list_type_code = 'PRL'
4510: AND QUALIFIER_CONTEXT <> 'MODLIST'

Line 4556: from qp_qualifiers

4552: --AND comparison_operator_code <> '='
4553: and pricing_segment_id is not null
4554: UNION all
4555: select segment_id
4556: from qp_qualifiers
4557: where /*list_line_id in (
4558: select list_line_id from qp_attribute_groups where eq_flag = 'N'
4559: UNION
4560: select list_line_id from qp_list_lines where eq_flag = 'N')

Line 4660: from qp_qualifiers

4656: elsif p_qualifier_group is not null then
4657: begin
4658: select 'Y'
4659: into l_qual_exists
4660: from qp_qualifiers
4661: where list_header_id = p_list_header_id
4662: and list_line_id = p_list_line_id
4663: and QUALIFIER_GROUPING_NO = p_qualifier_group
4664: and rownum = 1;

Line 4684: from qp_qualifiers

4680: else
4681: begin
4682: select 'Y'
4683: into l_qual_exists
4684: from qp_qualifiers
4685: where list_header_id = p_list_header_id
4686: and list_line_id = p_list_line_id
4687: and QUALIFIER_GROUPING_NO <> -1
4688: and rownum = 1;

Line 4806: from qp_qualifiers

4802: --AND comparison_operator_code <> '='
4803: and pricing_segment_id is not null
4804: UNION all
4805: select segment_id
4806: from qp_qualifiers
4807: where /*list_line_id in (
4808: select list_line_id from qp_attribute_groups where eq_flag = 'N'
4809: UNION
4810: select list_line_id from qp_list_lines where eq_flag = 'N')

Line 4900: from qp_qualifiers

4896: -- when called while set up of price list/modifier
4897: begin
4898: select 'Y'
4899: into l_qual_exists
4900: from qp_qualifiers
4901: where list_header_id = p_list_header_id
4902: and list_line_id = p_list_line_id
4903: and rownum = 1;
4904: exception

Line 4973: from qp_qualifiers

4969: --AND comparison_operator_code <> '='
4970: and pricing_segment_id is not null
4971: UNION all
4972: select segment_id
4973: from qp_qualifiers
4974: where /*list_line_id in (
4975: select list_line_id from qp_attribute_groups where eq_flag = 'N'
4976: UNION
4977: select list_line_id from qp_list_lines where eq_flag = 'N')

Line 5046: from qp_qualifiers

5042: ,p_high_list_line_id IN NUMBER)
5043: is
5044: cursor c_qual_seg_id is
5045: select distinct QUALIFIER_CONTEXT, QUALIFIER_ATTRIBUTE
5046: from qp_qualifiers
5047: where QUALIFIER_CONTEXT is not null
5048: and QUALIFIER_ATTRIBUTE is not null
5049: and list_header_id = p_list_header_id
5050: and list_line_id between p_low_list_line_id and p_high_list_line_id

Line 5058: from qp_qualifiers

5054: );
5055:
5056: cursor c_qual_seg_id_hdr_null is
5057: select distinct QUALIFIER_CONTEXT, QUALIFIER_ATTRIBUTE
5058: from qp_qualifiers
5059: where QUALIFIER_CONTEXT is not null
5060: and QUALIFIER_ATTRIBUTE is not null
5061: and list_line_id between p_low_list_line_id and p_high_list_line_id
5062: and ((p_qualifier_group is not null and qualifier_grouping_no in (-1, p_qualifier_group))

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

5062: and ((p_qualifier_group is not null and qualifier_grouping_no in (-1, p_qualifier_group))
5063: OR
5064: (p_qualifier_group is null)
5065: );
5066: TYPE segment_id_tab IS TABLE OF qp_qualifiers.segment_id%TYPE INDEX BY BINARY_INTEGER;
5067: TYPE context_tab IS TABLE OF qp_qualifiers.QUALIFIER_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
5068: TYPE attribute_tab IS TABLE OF qp_qualifiers.QUALIFIER_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
5069:
5070: segment_id_t segment_id_tab;

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

5063: OR
5064: (p_qualifier_group is null)
5065: );
5066: TYPE segment_id_tab IS TABLE OF qp_qualifiers.segment_id%TYPE INDEX BY BINARY_INTEGER;
5067: TYPE context_tab IS TABLE OF qp_qualifiers.QUALIFIER_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
5068: TYPE attribute_tab IS TABLE OF qp_qualifiers.QUALIFIER_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
5069:
5070: segment_id_t segment_id_tab;
5071: context_t context_tab;

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

5064: (p_qualifier_group is null)
5065: );
5066: TYPE segment_id_tab IS TABLE OF qp_qualifiers.segment_id%TYPE INDEX BY BINARY_INTEGER;
5067: TYPE context_tab IS TABLE OF qp_qualifiers.QUALIFIER_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
5068: TYPE attribute_tab IS TABLE OF qp_qualifiers.QUALIFIER_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
5069:
5070: segment_id_t segment_id_tab;
5071: context_t context_tab;
5072: attribute_t attribute_tab;

Line 5118: update qp_qualifiers

5114: and b.SEGMENT_MAPPING_COLUMN = attribute_t(i);
5115: END LOOP;
5116:
5117: FORALL j in 1..context_t.count
5118: update qp_qualifiers
5119: set segment_id = segment_id_t(j)
5120: where QUALIFIER_CONTEXT = context_t(j)
5121: and QUALIFIER_ATTRIBUTE = attribute_t(j)
5122: and list_header_id = nvl(p_list_header_id, list_header_id)