APPS.OZF_SD_REQUEST_PUB dependencies on MTL_UNITS_OF_MEASURE

Line 422: FROM mtl_units_of_measure_vl MTLUOM2

418: CURSOR c_category_UOM_N(p_category_id IN NUMBER
419: ,p_org_id IN NUMBER
420: ,p_uom_code IN VARCHAR2) IS
421: SELECT MTLUOM2.uom_code
422: FROM mtl_units_of_measure_vl MTLUOM2
423: WHERE EXISTS
424: (SELECT /*+no_unnest*/ 1
425: FROM mtl_system_items_b MTLITM1,
426: mtl_uom_conversions MTLUCV

Line 443: FROM MTL_UNITS_OF_MEASURE MTLPRI1

439: AND MTLUOM2.BASE_UOM_FLAG = 'Y'
440: AND MTLUOM2.UOM_CLASS = MTLUCV.UOM_CLASS
441: AND MTLUCV.UOM_CLASS IN
442: (SELECT MTLPRI1.UOM_CLASS
443: FROM MTL_UNITS_OF_MEASURE MTLPRI1
444: WHERE MTLPRI1.UOM_CODE = MTLITM1.PRIMARY_UOM_CODE
445: ))
446: OR ( MTLUCV.INVENTORY_ITEM_ID = 0
447: AND MTLUCV.UOM_CODE IN

Line 463: FROM MTL_UNITS_OF_MEASURE MTLPRI

459: AND NVL(MTLUCC.DISABLE_DATE, TRUNC(SYSDATE)+1) > TRUNC(SYSDATE)
460: )
461: OR MTLUCV.UOM_CLASS =
462: (SELECT MTLPRI.UOM_CLASS
463: FROM MTL_UNITS_OF_MEASURE MTLPRI
464: WHERE MTLPRI.UOM_CODE = MTLITM1.PRIMARY_UOM_CODE
465: ) ) ) )
466: )
467: AND MTLUOM2.uom_code = p_uom_code;

Line 472: FROM mtl_units_of_measure

468:
469: --//Cursor for ALL ITEMS UOM
470: CURSOR c_all_items_UOM(p_uom_code IN VARCHAR2) IS
471: SELECT uom_code
472: FROM mtl_units_of_measure
473: WHERE uom_code = p_uom_code;
474:
475: CURSOR c_category_chk (p_category_id IN NUMBER) IS
476: SELECT 'Y'

Line 1289: FROM mtl_units_of_measure a,

1285: --//Bugfix : 12538544
1286: /*
1287: CURSOR c_item_uom(p_item_uom IN VARCHAR2,p_inventory_item_id IN NUMBER,p_org_id IN NUMBER)IS
1288: SELECT a.uom_code
1289: FROM mtl_units_of_measure a,
1290: mtl_system_items c
1291: WHERE c.primary_unit_of_measure = a.unit_of_measure
1292: AND c.organization_id = p_org_id
1293: AND c.inventory_item_id = p_inventory_item_id