DBA Data[Home] [Help]

APPS.EGO_GTIN_ATTRS_PVT dependencies on MTL_UNITS_OF_MEASURE_TL

Line 264: FROM EGO_FND_DF_COL_USGS_EXT a, MTL_UNITS_OF_MEASURE_TL u

260: GROUP BY ROW_IDENTIFIER;
261:
262: CURSOR c_uom_code IS
263: SELECT a.APPLICATION_COLUMN_NAME, u.UOM_CODE
264: FROM EGO_FND_DF_COL_USGS_EXT a, MTL_UNITS_OF_MEASURE_TL u
265: WHERE a.UOM_CLASS = u.UOM_CLASS(+)
266: AND u.BASE_UOM_FLAG(+) = 'Y'
267: AND u.LANGUAGE(+) = USERENV('LANG')
268: AND a.APPLICATION_ID = 431

Line 3845: FROM EGO_FND_DF_COL_USGS_EXT a, MTL_UNITS_OF_MEASURE_TL u

3841: ,x_msg_data OUT NOCOPY VARCHAR2) IS
3842:
3843: CURSOR c_uom_code IS
3844: SELECT a.APPLICATION_COLUMN_NAME, u.UOM_CODE
3845: FROM EGO_FND_DF_COL_USGS_EXT a, MTL_UNITS_OF_MEASURE_TL u
3846: WHERE a.UOM_CLASS = u.UOM_CLASS(+)
3847: AND u.BASE_UOM_FLAG(+) = 'Y'
3848: AND u.LANGUAGE(+) = USERENV('LANG')
3849: AND a.APPLICATION_ID = 431