DBA Data[Home] [Help]

APPS.QP_BULK_VALIDATE dependencies on MTL_ITEM_UOMS_VIEW

Line 6137: from mtl_item_uoms_view

6133: and qpip.product_attribute_context = 'ITEM'
6134: and qpip.product_attribute = 'PRICING_ATTRIBUTE1'
6135: AND NOT EXISTS (
6136: select uom_code
6137: from mtl_item_uoms_view
6138: where organization_id = nvl(qpil.organization_id, organization_id)
6139: and inventory_item_id = to_number(qpip.product_attr_value)
6140: and uom_code = qpip.product_uom_code
6141: -- commented out for bug 4713401

Line 6145: from mtl_item_uoms_view

6141: -- commented out for bug 4713401
6142: /*
6143: union
6144: select uom_code
6145: from mtl_item_uoms_view
6146: where (organization_id = qpil.organization_id or qpil.organization_id is null)
6147: and inventory_item_id in ( select inventory_item_id
6148: from mtl_item_categories
6149: where category_id = to_number(qpip.product_attr_value)

Line 6159: from mtl_item_uoms_view

6155: -- added for bug 4713401
6156: /* commented out as this code is not performant
6157: union
6158: select uom_code
6159: from mtl_item_uoms_view
6160: where (organization_id = qpil.organization_id or qpil.organization_id is null) and
6161: qpip.product_attribute_context = 'ITEM' and
6162: qpip.product_attribute = 'PRICING_ATTRIBUTE2' and
6163: uom_code = qpip.product_uom_code and