DBA Data[Home] [Help]

APPS.WMS_WAVE_PLANNING_PVT dependencies on MTL_UNITS_OF_MEASURE_VL

Line 14100: FROM mtl_units_of_measure_vl

14096: begin
14097:
14098: SELECT uom_code
14099: into v_weight_uom
14100: FROM mtl_units_of_measure_vl
14101: WHERE uom_class = (SELECT weight_uom_class
14102: FROM wsh_shipping_parameters
14103: WHERE organization_id = p_orgid)
14104: AND base_uom_flag = 'Y';

Line 14145: FROM mtl_units_of_measure_vl

14141: begin
14142:
14143: SELECT uom_code
14144: into v_volume_uom
14145: FROM mtl_units_of_measure_vl
14146: WHERE uom_class = (SELECT volume_uom_class
14147: FROM wsh_shipping_parameters
14148: WHERE organization_id = p_orgid)
14149: AND base_uom_flag = 'Y';

Line 14204: FROM mtl_units_of_measure_vl

14200: begin
14201:
14202: SELECT uom_code
14203: into v_weight_uom
14204: FROM mtl_units_of_measure_vl
14205: WHERE uom_class = (SELECT weight_uom_class
14206: FROM wsh_shipping_parameters
14207: WHERE organization_id = p_orgid)
14208: AND base_uom_flag = 'Y';

Line 14212: FROM mtl_units_of_measure_vl

14208: AND base_uom_flag = 'Y';
14209:
14210: SELECT uom_code
14211: into v_volume_uom
14212: FROM mtl_units_of_measure_vl
14213: WHERE uom_class = (SELECT volume_uom_class
14214: FROM wsh_shipping_parameters
14215: WHERE organization_id = p_orgid)
14216: AND base_uom_flag = 'Y';