APPS.OKE_DELIVERABLE_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 1378: FROM mtl_units_of_measure

1374: AND Inventory_Item_ID = P_ID;
1375:
1376: CURSOR C2 ( P_CODE VARCHAR2 ) IS
1377: SELECT 'X'
1378: FROM mtl_units_of_measure
1379: WHERE Sysdate < NVL(Disable_Date, Sysdate + 1)
1380: AND UOM_Code = P_Code;
1381:
1382: Begin

Line 1707: FROM mtl_units_of_measure uom, wsh_shipping_parameters wsp

1703: L_ID NUMBER;
1704:
1705: CURSOR C ( P_Code VARCHAR2, P_ID NUMBER ) IS
1706: SELECT 'X'
1707: FROM mtl_units_of_measure uom, wsh_shipping_parameters wsp
1708: WHERE uom.uom_class = wsp.volume_uom_class
1709: AND wsp.organization_ID = P_ID
1710: AND Sysdate < NVL(Disable_Date, Sysdate + 1)
1711: AND uom.Uom_Code = P_Code;

Line 1793: FROM mtl_units_of_measure uom, wsh_shipping_parameters wsp

1789: L_ID NUMBER;
1790:
1791: CURSOR C ( P_Code VARCHAR2, P_ID NUMBER ) IS
1792: SELECT 'X'
1793: FROM mtl_units_of_measure uom, wsh_shipping_parameters wsp
1794: WHERE uom.uom_class = wsp.weight_uom_class
1795: AND wsp.organization_ID = P_ID
1796: AND Sysdate < NVL(Disable_Date, Sysdate + 1)
1797: AND uom.Uom_Code = P_Code;