DBA Data[Home] [Help]

APPS.FTE_VEHICLE_PKG dependencies on MTL_UNITS_OF_MEASURE_TL

Line 68: FROM MTL_UNITS_OF_MEASURE_TL

64: if (p_weight_uom is not null)
65: then
66: BEGIN
67: SELECT UOM_CODE INTO x_weight_uom_code
68: FROM MTL_UNITS_OF_MEASURE_TL
69: WHERE UNIT_OF_MEASURE_TL = p_weight_uom
70: AND LANGUAGE = USERENV('LANG')
71: AND NVL(DISABLE_DATE, SYSDATE+1) > SYSDATE
72: AND UOM_CLASS = (select gu_weight_class

Line 86: FROM MTL_UNITS_OF_MEASURE_TL

82: if (p_volume_uom is not null)
83: then
84: BEGIN
85: SELECT UOM_CODE INTO x_volume_uom_code
86: FROM MTL_UNITS_OF_MEASURE_TL
87: WHERE UNIT_OF_MEASURE_TL = p_volume_uom
88: AND LANGUAGE = USERENV('LANG')
89: AND NVL(DISABLE_DATE, SYSDATE+1) > SYSDATE
90: AND UOM_CLASS = (select gu_volume_class

Line 103: FROM MTL_UNITS_OF_MEASURE_TL

99: if (p_dimension_uom is not null)
100: then
101: BEGIN
102: SELECT UOM_CODE INTO x_dimension_uom_code
103: FROM MTL_UNITS_OF_MEASURE_TL
104: WHERE UNIT_OF_MEASURE_TL = p_dimension_uom
105: AND LANGUAGE = USERENV('LANG')
106: AND NVL(DISABLE_DATE, SYSDATE+1) > SYSDATE
107: AND UOM_CLASS = (select gu_dimension_class