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 1685: FROM MTL_UNITS_OF_MEASURE_TL

1681:
1682: CURSOR cs_validate_uom(p_uom_code IN VARCHAR2)
1683: is
1684: SELECT 1
1685: FROM MTL_UNITS_OF_MEASURE_TL
1686: WHERE uom_code = p_uom_code
1687: AND LANGUAGE = USERENV('LANG');
1688: cr_validate_uom cs_validate_uom%ROWTYPE;
1689:

Line 1817: FROM MTL_UNITS_OF_MEASURE_TL

1813:
1814: CURSOR cs_validate_uom(p_uom_code IN VARCHAR2)
1815: is
1816: SELECT 1
1817: FROM MTL_UNITS_OF_MEASURE_TL
1818: WHERE uom_code = p_uom_code
1819: AND LANGUAGE = USERENV('LANG');
1820: cr_validate_uom cs_validate_uom%ROWTYPE;
1821: