APPS.QP_BULK_VALIDATE dependencies on MTL_SYSTEM_ITEMS_VL

Line 1867: from qp_interface_pricing_attribs qipa, mtl_system_items_vl msiv

1863: l_exist :=0;
1864:
1865: begin
1866: select count(*) into l_exist
1867: from qp_interface_pricing_attribs qipa, mtl_system_items_vl msiv
1868: where qipa.orig_sys_line_ref = p_line_rec.orig_sys_line_ref(I)
1869: and qipa.request_id = p_line_rec.request_id(I)
1870: and qipa.product_attribute_context = 'ITEM'
1871: and qipa.product_attribute = 'PRICING_ATTRIBUTE1'

Line 1884: from qp_pricing_attributes qpa, mtl_system_items_vl msiv

1880:
1881: if l_exist=0 then
1882: begin
1883: select count(*) into l_exist
1884: from qp_pricing_attributes qpa, mtl_system_items_vl msiv
1885: where qpa.orig_sys_line_ref = p_line_rec.orig_sys_line_ref(I)
1886: -- Bug 5246745 Use Composite Index for Ref columns
1887: and qpa.orig_sys_header_ref = p_line_rec.orig_sys_header_ref(I)
1888: and qpa.product_attribute_context = 'ITEM'