APPS.EDW_UTIL dependencies on EDW_MTL_LOCAL_UOM_M

Line 322: FROM EDW_MTL_LOCAL_UOM_M

318: l_inventory_id NUMBER;
319: l_edw_uom_code VARCHAR2(20);
320: CURSOR global_uom_c IS
321: SELECT UOM_EDW_BASE_UOM
322: FROM EDW_MTL_LOCAL_UOM_M
323: WHERE
324: UOM_EDW_UOM_PK = p_uom_code
325: AND UOM_global_flag = 'Y';
326: CURSOR uom_c IS

Line 374: FROM EDW_MTL_LOCAL_UOM_M

370: l_inventory_id NUMBER;
371: l_edw_uom_code VARCHAR2(20);
372: CURSOR global_uom_c IS
373: SELECT UOM_EDW_BASE_UOM
374: FROM EDW_MTL_LOCAL_UOM_M
375: WHERE
376: UOM_EDW_UOM_PK = p_uom_code
377: AND UOM_global_flag = 'Y';
378: CURSOR uom_c IS

Line 426: FROM EDW_MTL_LOCAL_UOM_M

422: l_edw_conv_rate NUMBER;
423:
424: CURSOR global_uom_c IS
425: SELECT UOM_conversion_rate
426: FROM EDW_MTL_LOCAL_UOM_M
427: WHERE
428: UOM_EDW_UOM_PK = p_uom_code
429: AND UOM_global_flag = 'Y';
430: CURSOR uom_c IS

Line 480: FROM EDW_MTL_LOCAL_UOM_M

476: l_edw_conv_rate NUMBER;
477:
478: CURSOR global_uom_c IS
479: SELECT UOM_conversion_rate
480: FROM EDW_MTL_LOCAL_UOM_M
481: WHERE
482: UOM_EDW_UOM_PK = p_uom_code
483: AND UOM_global_flag = 'Y';
484: CURSOR uom_c IS

Line 624: FROM EDW_MTL_LOCAL_UOM_M

620: l_inventory_id NUMBER;
621: l_edw_uom_code VARCHAR2(20);
622: CURSOR global_uom_c IS
623: SELECT uom_edw_uom_pk
624: FROM EDW_MTL_LOCAL_UOM_M
625: WHERE
626: UOM_EDW_UOM_PK = p_uom_code
627: AND UOM_global_flag = 'Y';
628: CURSOR uom_c IS

Line 675: FROM EDW_MTL_LOCAL_UOM_M

671: l_inventory_id NUMBER;
672: l_edw_uom_code VARCHAR2(20);
673: CURSOR global_uom_c IS
674: SELECT uom_edw_uom_pk
675: FROM EDW_MTL_LOCAL_UOM_M
676: WHERE
677: UOM_EDW_UOM_PK = p_uom_code
678: AND UOM_global_flag = 'Y';
679: CURSOR uom_c IS