DBA Data[Home] [Help]

APPS.OKS_OMINT_PUB dependencies on MTL_UNITS_OF_MEASURE_TL

Line 50: From MTL_UNITS_OF_MEASURE_TL --OKX_UNITS_OF_MEASURE_V

46: Where SYSTEM_ID = P_system_id;
47:
48: Cursor l_UOM_Csr Is
49: Select UOM_Code, Unit_Of_Measure
50: From MTL_UNITS_OF_MEASURE_TL --OKX_UNITS_OF_MEASURE_V
51: Where UOM_Code = p_Service_Period;
52:
53:
54: Cursor l_tce_csr(p_code varchar2, p_qty Number) Is

Line 1638: FROM MTL_UNITS_OF_MEASURE_TL

1634:
1635: CURSOR cs_validate_uom(p_uom_code IN VARCHAR2)
1636: is
1637: SELECT 1
1638: FROM MTL_UNITS_OF_MEASURE_TL
1639: WHERE uom_code = p_uom_code
1640: AND LANGUAGE = USERENV('LANG');
1641: cr_validate_uom cs_validate_uom%ROWTYPE;
1642:

Line 1770: FROM MTL_UNITS_OF_MEASURE_TL

1766:
1767: CURSOR cs_validate_uom(p_uom_code IN VARCHAR2)
1768: is
1769: SELECT 1
1770: FROM MTL_UNITS_OF_MEASURE_TL
1771: WHERE uom_code = p_uom_code
1772: AND LANGUAGE = USERENV('LANG');
1773: cr_validate_uom cs_validate_uom%ROWTYPE;
1774: