DBA Data[Home] [Help]

APPS.QP_BULK_VALIDATE dependencies on MTL_SYSTEM_ITEMS

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'

Line 3766: from qp_interface_pricing_attribs qipa, mtl_system_items msi

3762: IF fnd_global.resp_appl_id=178 OR fnd_global.resp_appl_id=201
3763: THEN --Check if item is purchasing enabled
3764: Begin
3765: select count(*) into l_pa_count
3766: from qp_interface_pricing_attribs qipa, mtl_system_items msi
3767: where qipa.orig_sys_pricing_attr_ref = p_pricing_attr_rec.orig_sys_pricing_attr_ref(I)
3768: and qipa.request_id = P_PRICING_ATTR_REC.REQUEST_ID(I)
3769: and qipa.product_attribute_context = 'ITEM'
3770: and qipa.product_attribute = 'PRICING_ATTRIBUTE1'

Line 3782: from qp_interface_pricing_attribs qipa, mtl_system_items msi

3778: End;
3779: ELSE --Check if item is orderable
3780: Begin
3781: select count(*) into l_pa_count
3782: from qp_interface_pricing_attribs qipa, mtl_system_items msi
3783: where qipa.orig_sys_pricing_attr_ref = p_pricing_attr_rec.orig_sys_pricing_attr_ref(I)
3784: and qipa.request_id = P_PRICING_ATTR_REC.REQUEST_ID(I)
3785: and qipa.product_attribute_context = 'ITEM'
3786: and qipa.product_attribute = 'PRICING_ATTRIBUTE1'