APPS.OE_BULK_VALIDATE dependencies on MTL_SYSTEM_ITEMS

Line 1645: FROM mtl_system_items

1641: -- Added to fix bug 5394064. Validate this ID only if populated
1642: AND b.inventory_item_id IS NOT NULL -- added to fix bug 5394064
1643: AND NOT EXISTS (
1644: SELECT tracking_quantity_ind
1645: FROM mtl_system_items
1646: WHERE organization_id = b.ship_from_org_id
1647: AND inventory_item_id = b.inventory_item_id
1648: );
1649:

Line 1692: FROM mtl_system_items

1688: OR b.ordered_quantity2 IS NOT NULL )
1689:
1690: AND EXISTS (
1691: SELECT tracking_quantity_ind
1692: FROM mtl_system_items
1693: WHERE organization_id = b.ship_from_org_id
1694: AND inventory_item_id = b.inventory_item_id
1695: and tracking_quantity_ind = 'P' );
1696:

Line 1707: -- AND secondary UOM must be same as on mtl_system_items

1703: END IF;
1704: END IF;
1705:
1706: -- PROCESS DUAL HVOP 3. if secondary UOM is entered,then item must be process and type 1 2 or 3
1707: -- AND secondary UOM must be same as on mtl_system_items
1708:
1709:
1710: l_msg_text := l_msg_data||
1711: OE_ORDER_UTIL.Get_Attribute_Name('ORDERED_QUANTITY_UOM2');

Line 1737: FROM mtl_system_items

1733: WHERE batch_id = p_batch_id)
1734: AND ( b.ordered_quantity_uom2 IS NOT NULL )
1735: AND NOT EXISTS (
1736: SELECT tracking_quantity_ind
1737: FROM mtl_system_items
1738: WHERE organization_id = b.ship_from_org_id
1739: AND inventory_item_id = b.inventory_item_id
1740: and ( tracking_quantity_ind = 'PS' or
1741: ont_pricing_qty_source = 'S')

Line 1786: FROM mtl_system_items

1782: AND ( b.ordered_quantity_uom2 IS NULL)
1783:
1784: AND EXISTS (
1785: SELECT tracking_quantity_ind
1786: FROM mtl_system_items
1787: WHERE organization_id = b.ship_from_org_id
1788: AND inventory_item_id = b.inventory_item_id
1789: and ( tracking_quantity_ind = 'PS' or
1790: ont_pricing_qty_source = 'S')

Line 1840: FROM mtl_system_items

1836: AND b.ship_from_org_id IS NOT NULL
1837: AND b.inventory_item_id IS NOT NULL
1838: AND ( NOT EXISTS (
1839: SELECT grade_control_flag
1840: FROM mtl_system_items
1841: WHERE organization_id = b.ship_from_org_id
1842: AND inventory_item_id = b.inventory_item_id
1843: and grade_control_flag = 'Y' )
1844: