DBA Data[Home] [Help]

APPS.WSH_OTM_RIQ_XML dependencies on MTL_UNITS_OF_MEASURE

Line 1172: FROM MTL_UNITS_OF_MEASURE

1168:
1169: CURSOR c_get_EBS_UOM(c_uom_class IN VARCHAR2,c_uom IN VARCHAR2)
1170: IS
1171: SELECT uom_code
1172: FROM MTL_UNITS_OF_MEASURE
1173: WHERE uom_class=c_uom_class
1174: AND nvl(disable_date, sysdate) >= SYSDATE
1175: AND attribute15=c_uom;
1176:

Line 1180: FROM mtl_units_of_measure

1176:
1177: CURSOR c_check_uom(c_uom_class IN VARCHAR2, c_uom IN VARCHAR2)
1178: IS
1179: SELECT UOM_CODE
1180: FROM mtl_units_of_measure
1181: WHERE uom_code = c_uom
1182: AND nvl(disable_date, sysdate) >= SYSDATE
1183: AND uom_class = c_uom_class;
1184:

Line 1277: FROM MTL_UNITS_OF_MEASURE

1273:
1274: CURSOR c_get_OTM_UOM(c_uom IN VARCHAR2)
1275: IS
1276: SELECT attribute15
1277: FROM MTL_UNITS_OF_MEASURE
1278: WHERE uom_code=c_uom
1279: AND nvl(disable_date, sysdate) >= SYSDATE;
1280:
1281: l_uom VARCHAR2(30);