APPS.QP_VALIDATE_PLL_PRICING_ATTR dependencies on QP_PRICING_ATTRIBUTES

Line 335: from qp_pricing_attributes b, qp_list_lines c

331: l_count:=0;
332: for c1 in
333: (
334: select b.list_line_id col2
335: from qp_pricing_attributes b, qp_list_lines c
336: where b.list_line_id <> p_PRICING_ATTR_rec.list_line_id
337: and b.list_line_id=c.list_line_id
338: and c.primary_uom_flag='Y'
339: and b.product_attribute_context = p_PRICING_ATTR_rec.product_attribute_context

Line 658: FROM qp_list_lines l, qp_pricing_attributes a

654:
655: BEGIN
656: SELECT count(*)
657: INTO l_count
658: FROM qp_list_lines l, qp_pricing_attributes a
659: WHERE l.list_line_id = a.list_line_id
660: AND a.list_header_id = p_PRICING_ATTR_rec.list_header_id
661: AND a.product_attribute_context =
662: p_PRICING_ATTR_rec.product_attribute_context

Line 1893: from qp_pricing_attributes a, qp_pricing_attributes b

1889: l_attr_lines_count NUMBER;
1890:
1891: CURSOR get_rec(l_List_Line_ID NUMBER ) is
1892: select a.list_line_id col1, b.list_line_id col2
1893: from qp_pricing_attributes a, qp_pricing_attributes b
1894: where a.list_line_id = l_List_Line_ID
1895: and b.list_line_id <> l_List_Line_ID
1896: and not exists (select Null
1897: from qp_rltd_modifiers qrm

Line 1921: and count(b.list_line_id) = ( select count(*) from qp_pricing_attributes where list_line_id = b.list_line_id); --2326820

1917: and b.list_header_id = p_List_Header_Id
1918: and a.list_header_id = p_List_Header_Id
1919: group by a.list_line_id, b.list_line_id
1920: having count(b.list_line_id ) = l_attr_lines_count
1921: and count(b.list_line_id) = ( select count(*) from qp_pricing_attributes where list_line_id = b.list_line_id); --2326820
1922:
1923:
1924:
1925: l_count varchar2(2);

Line 1934: from qp_pricing_attributes

1930: BEGIN
1931:
1932: select count(*)
1933: Into l_attr_lines_count
1934: from qp_pricing_attributes
1935: where list_line_id = p_List_Line_ID;
1936:
1937: for rec in get_rec(p_List_Line_ID)
1938: loop

Line 2045: from qp_pricing_attributes a, qp_pricing_attributes b, qp_list_lines c

2041: BEGIN
2042:
2043: select a.list_line_id, b.list_line_id
2044: into l_dummy, l_dummy1
2045: from qp_pricing_attributes a, qp_pricing_attributes b, qp_list_lines c
2046: where a.list_line_id = p_List_Line_ID
2047: and b.list_line_id <> p_List_Line_ID
2048: and b.product_attribute_context = a.product_attribute_context
2049: and b.product_attribute = a.product_attribute

Line 2064: from qp_pricing_attributes

2060: and a.list_line_id = c.list_line_id
2061: and nvl(c.revision,' ') = nvl(p_Revision,' ')
2062: group by a.list_line_id, b.list_line_id
2063: having count(b.list_line_id) = ( select count(*)
2064: from qp_pricing_attributes
2065: where list_line_id = b.list_line_id) ;
2066:
2067:
2068: p_x_rows := sql%rowcount;

Line 2107: from qp_pricing_attributes a, qp_pricing_attributes b, qp_list_lines c

2103: BEGIN
2104:
2105: select a.list_line_id, b.list_line_id
2106: into l_dummy, l_dummy1
2107: from qp_pricing_attributes a, qp_pricing_attributes b, qp_list_lines c
2108: where a.list_line_id = p_List_Line_ID
2109: and b.list_line_id <> p_List_Line_ID
2110: and b.product_attribute_context = a.product_attribute_context
2111: and b.product_attribute = a.product_attribute

Line 2129: from qp_pricing_attributes

2125: nvl(trunc(end_date_active),sysdate) BETWEEN nvl(to_date(to_char(p_Start_Date_Active,'DD/MM/YYYY'),'DD/MM/YYYY'),sysdate )
2126: and nvl(to_date(to_char(p_End_Date_Active,'DD/MM/YYYY'),'DD/MM/YYYY'), sysdate ) )
2127: group by a.list_line_id, b.list_line_id
2128: having count(b.list_line_id) = ( select count(*)
2129: from qp_pricing_attributes
2130: where list_line_id = b.list_line_id) ;
2131:
2132:
2133: