APPS.QP_VALIDATE_PLL_PRICING_ATTR dependencies on QP_PRICING_ATTRIBUTES

Line 329: from qp_pricing_attributes b, qp_list_lines c

325: l_count:=0;
326: for c1 in
327: (
328: select b.list_line_id col2
329: from qp_pricing_attributes b, qp_list_lines c
330: where b.list_line_id <> p_PRICING_ATTR_rec.list_line_id
331: and b.list_line_id=c.list_line_id
332: and c.primary_uom_flag='Y'
333: and b.product_attribute_context = p_PRICING_ATTR_rec.product_attribute_context

Line 601: FROM qp_list_lines l, qp_pricing_attributes a

597:
598: BEGIN
599: SELECT count(*)
600: INTO l_count
601: FROM qp_list_lines l, qp_pricing_attributes a
602: WHERE l.list_line_id = a.list_line_id
603: AND a.list_header_id = p_PRICING_ATTR_rec.list_header_id
604: AND a.product_attribute_context =
605: p_PRICING_ATTR_rec.product_attribute_context

Line 1836: from qp_pricing_attributes a, qp_pricing_attributes b

1832: l_attr_lines_count NUMBER;
1833:
1834: CURSOR get_rec(l_List_Line_ID NUMBER ) is
1835: select a.list_line_id col1, b.list_line_id col2
1836: from qp_pricing_attributes a, qp_pricing_attributes b
1837: where a.list_line_id = l_List_Line_ID
1838: and b.list_line_id <> l_List_Line_ID
1839: and not exists (select Null
1840: from qp_rltd_modifiers qrm

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

1852: and b.list_header_id = p_List_Header_Id
1853: and a.list_header_id = p_List_Header_Id
1854: group by a.list_line_id, b.list_line_id
1855: having count(b.list_line_id ) = l_attr_lines_count
1856: and count(b.list_line_id) = ( select count(*) from qp_pricing_attributes where list_line_id = b.list_line_id); --2326820
1857:
1858:
1859:
1860: l_count varchar2(2);

Line 1869: from qp_pricing_attributes

1865: BEGIN
1866:
1867: select count(*)
1868: Into l_attr_lines_count
1869: from qp_pricing_attributes
1870: where list_line_id = p_List_Line_ID;
1871:
1872: for rec in get_rec(p_List_Line_ID)
1873: loop

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

1976: BEGIN
1977:
1978: select a.list_line_id, b.list_line_id
1979: into l_dummy, l_dummy1
1980: from qp_pricing_attributes a, qp_pricing_attributes b, qp_list_lines c
1981: where a.list_line_id = p_List_Line_ID
1982: and b.list_line_id <> p_List_Line_ID
1983: and b.product_attribute_context = a.product_attribute_context
1984: and b.product_attribute = a.product_attribute

Line 1999: from qp_pricing_attributes

1995: and a.list_line_id = c.list_line_id
1996: and nvl(c.revision,' ') = nvl(p_Revision,' ')
1997: group by a.list_line_id, b.list_line_id
1998: having count(b.list_line_id) = ( select count(*)
1999: from qp_pricing_attributes
2000: where list_line_id = b.list_line_id) ;
2001:
2002:
2003: p_x_rows := sql%rowcount;

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

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

Line 2064: from qp_pricing_attributes

2060: nvl(trunc(end_date_active),sysdate) BETWEEN nvl(to_date(to_char(p_Start_Date_Active,'DD/MM/YYYY'),'DD/MM/YYYY'),sysdate )
2061: and nvl(to_date(to_char(p_End_Date_Active,'DD/MM/YYYY'),'DD/MM/YYYY'), sysdate ) )
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: