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

Line 2053: Select count(*) into l_org_line from qp_qualifiers where list_line_id = rec.col1;

2049:
2050: CT_DUPLI_QUAL := 1;
2051: DUPLI_QUAL := FALSE;
2052:
2053: Select count(*) into l_org_line from qp_qualifiers where list_line_id = rec.col1;
2054:
2055: Select count(*) into l_other_line from qp_qualifiers where list_line_id = rec.col2;
2056:
2057: if (l_org_line = 0 and l_other_line = 0) then

Line 2055: Select count(*) into l_other_line from qp_qualifiers where list_line_id = rec.col2;

2051: DUPLI_QUAL := FALSE;
2052:
2053: Select count(*) into l_org_line from qp_qualifiers where list_line_id = rec.col1;
2054:
2055: Select count(*) into l_other_line from qp_qualifiers where list_line_id = rec.col2;
2056:
2057: if (l_org_line = 0 and l_other_line = 0) then
2058:
2059: DUPLI_QUAL := TRUE;

Line 2065: select qualifier_id qual_id, list_header_id hdr_id from qp_qualifiers

2061: elsif(l_org_line = l_other_line) then
2062:
2063: Declare
2064: Cursor get_same_quals(l_list_id in Number) is
2065: select qualifier_id qual_id, list_header_id hdr_id from qp_qualifiers
2066: where list_line_id = l_list_id;
2067: CT_DUPLI_QUAL NUMBER;
2068:
2069: begin

Line 2074: from qp_qualifiers q1, qp_qualifiers q2

2070: for rec1 in get_same_quals(rec.col1)
2071: loop
2072:
2073: Select count(*) into CT_DUPLI_QUAL
2074: from qp_qualifiers q1, qp_qualifiers q2
2075: where q1.qualifier_id = rec1.qual_id
2076: and q2.list_line_id = rec.col2
2077: and nvl(q1.qualifier_grouping_no, 0) = nvl(q2.qualifier_grouping_no, 0)
2078: and q1.qualifier_context = q2.qualifier_context

Line 2162: Select count(*) into l_org_line from qp_qualifiers where list_line_id = rec.col1;

2158: l_max_date := to_date('12/31/9999', 'MM/DD/YYYY');
2159: CT_DUPLI_QUAL := 1;
2160: DUPLI_QUAL := FALSE;
2161:
2162: Select count(*) into l_org_line from qp_qualifiers where list_line_id = rec.col1;
2163:
2164: Select count(*) into l_other_line from qp_qualifiers where list_line_id = rec.col2;
2165:
2166: if (l_org_line = 0 and l_other_line = 0) then

Line 2164: Select count(*) into l_other_line from qp_qualifiers where list_line_id = rec.col2;

2160: DUPLI_QUAL := FALSE;
2161:
2162: Select count(*) into l_org_line from qp_qualifiers where list_line_id = rec.col1;
2163:
2164: Select count(*) into l_other_line from qp_qualifiers where list_line_id = rec.col2;
2165:
2166: if (l_org_line = 0 and l_other_line = 0) then
2167:
2168: DUPLI_QUAL := TRUE;

Line 2174: select qualifier_id qual_id, list_header_id hdr_id from qp_qualifiers

2170: elsif(l_org_line = l_other_line) then
2171:
2172: Declare
2173: Cursor get_same_quals(l_list_id in Number) is
2174: select qualifier_id qual_id, list_header_id hdr_id from qp_qualifiers
2175: where list_line_id = l_list_id;
2176: CT_DUPLI_QUAL NUMBER := 0;
2177:
2178: begin

Line 2183: from qp_qualifiers q1, qp_qualifiers q2

2179: for rec1 in get_same_quals(rec.col1)
2180: loop
2181:
2182: Select count(*) into CT_DUPLI_QUAL
2183: from qp_qualifiers q1, qp_qualifiers q2
2184: where q1.qualifier_id = rec1.qual_id
2185: and q2.list_line_id = rec.col2
2186: and nvl(q1.qualifier_grouping_no, 0) = nvl(q2.qualifier_grouping_no, 0)
2187: and q1.qualifier_context = q2.qualifier_context