APPS.WMS_TASK_UTILS_PVT dependencies on MTL_PARAMETERS

Line 347: FROM mtl_parameters mp, mtl_material_transactions_temp mmtt

343: AND mmtt.transaction_temp_id = p_temp_id;
344:
345: SELECT nvl(mp.allocate_serial_flag,'N') /*Bug#4003553.Added NVL function*/
346: INTO v_allocate_serial_flag
347: FROM mtl_parameters mp, mtl_material_transactions_temp mmtt
348: WHERE mp.organization_id = mmtt.organization_id
349: AND mmtt.transaction_temp_id = p_temp_id;
350:
351: IF l_wms_task_types IN(wms_globals.g_wms_task_type_stg_move) THEN

Line 1191: FROM mtl_parameters

1187: END IF;
1188:
1189: SELECT allocate_serial_flag
1190: INTO v_allocate_serial_flag
1191: FROM mtl_parameters
1192: WHERE organization_id = l_org_id;
1193:
1194: /*****LOT controlled only **********/
1195: cnt := 1;

Line 1883: FROM mtl_parameters

1879: END IF;
1880:
1881: SELECT allocate_serial_flag
1882: INTO v_allocate_serial_flag
1883: FROM mtl_parameters
1884: WHERE organization_id = mmtt_table(cnt).organization_id;
1885:
1886: IF v_allocate_serial_flag = 'Y' THEN
1887: l_alloc_ser := 'Y';