DBA Data[Home] [Help]

APPS.QP_BULK_VALIDATE dependencies on MTL_ITEM_UOMS_VIEW

Line 6125: from mtl_item_uoms_view

6121: and qpip.product_attribute_context = 'ITEM'
6122: and qpip.product_attribute = 'PRICING_ATTRIBUTE1'
6123: AND NOT EXISTS (
6124: select uom_code
6125: from mtl_item_uoms_view
6126: where organization_id = nvl(qpil.organization_id, organization_id)
6127: and inventory_item_id = to_number(qpip.product_attr_value)
6128: and uom_code = qpip.product_uom_code
6129: -- commented out for bug 4713401

Line 6133: from mtl_item_uoms_view

6129: -- commented out for bug 4713401
6130: /*
6131: union
6132: select uom_code
6133: from mtl_item_uoms_view
6134: where (organization_id = qpil.organization_id or qpil.organization_id is null)
6135: and inventory_item_id in ( select inventory_item_id
6136: from mtl_item_categories
6137: where category_id = to_number(qpip.product_attr_value)

Line 6147: from mtl_item_uoms_view

6143: -- added for bug 4713401
6144: /* commented out as this code is not performant
6145: union
6146: select uom_code
6147: from mtl_item_uoms_view
6148: where (organization_id = qpil.organization_id or qpil.organization_id is null) and
6149: qpip.product_attribute_context = 'ITEM' and
6150: qpip.product_attribute = 'PRICING_ATTRIBUTE2' and
6151: uom_code = qpip.product_uom_code and