APPS.QP_BULK_VALIDATE dependencies on MTL_SYSTEM_ITEMS_VL

Line 2023: from qp_interface_pricing_attribs qipa, mtl_system_items_vl msiv

2019: l_exist :=0;
2020:
2021: begin
2022: select count(*) into l_exist
2023: from qp_interface_pricing_attribs qipa, mtl_system_items_vl msiv
2024: where qipa.orig_sys_line_ref = p_line_rec.orig_sys_line_ref(I)
2025: and qipa.request_id = p_line_rec.request_id(I)
2026: and qipa.product_attribute_context = 'ITEM'
2027: and qipa.product_attribute = 'PRICING_ATTRIBUTE1'

Line 2040: from qp_pricing_attributes qpa, mtl_system_items_vl msiv

2036:
2037: if l_exist=0 then
2038: begin
2039: select count(*) into l_exist
2040: from qp_pricing_attributes qpa, mtl_system_items_vl msiv
2041: where qpa.orig_sys_line_ref = p_line_rec.orig_sys_line_ref(I)
2042: -- Bug 5246745 Use Composite Index for Ref columns
2043: and qpa.orig_sys_header_ref = p_line_rec.orig_sys_header_ref(I)
2044: and qpa.product_attribute_context = 'ITEM'