APPS.QP_BULK_VALIDATE dependencies on MTL_SYSTEM_ITEMS

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'

Line 3654: from qp_interface_pricing_attribs qipa, mtl_system_items msi

3650: IF fnd_global.resp_appl_id=178 OR fnd_global.resp_appl_id=201
3651: THEN --Check if item is purchasing enabled
3652: Begin
3653: select count(*) into l_pa_count
3654: from qp_interface_pricing_attribs qipa, mtl_system_items msi
3655: where qipa.orig_sys_pricing_attr_ref = p_pricing_attr_rec.orig_sys_pricing_attr_ref(I)
3656: and qipa.request_id = P_PRICING_ATTR_REC.REQUEST_ID(I)
3657: and qipa.product_attribute_context = 'ITEM'
3658: and qipa.product_attribute = 'PRICING_ATTRIBUTE1'

Line 3670: from qp_interface_pricing_attribs qipa, mtl_system_items msi

3666: End;
3667: ELSE --Check if item is orderable
3668: Begin
3669: select count(*) into l_pa_count
3670: from qp_interface_pricing_attribs qipa, mtl_system_items msi
3671: where qipa.orig_sys_pricing_attr_ref = p_pricing_attr_rec.orig_sys_pricing_attr_ref(I)
3672: and qipa.request_id = P_PRICING_ATTR_REC.REQUEST_ID(I)
3673: and qipa.product_attribute_context = 'ITEM'
3674: and qipa.product_attribute = 'PRICING_ATTRIBUTE1'